Getting All Tables Information in Redshift

According to the AWS Document, Redshift provides PG_TABLE_DEF table that contains all the table information, and you can query that table like 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 SELECT DISTINCT schemaname, tablename, column, type, encoding, distkey, sortkey, notnull FROM PG_TABLE_DEF WHERE 1=1 AND schemaname in ('<SCHEMA_NAME>') ORDER BY schemaname ASC, tablename ASC ; However, this only returns all the information in the public schema, I assume there maybe some permission problem with my account....

August 29, 2018 · 1 min · 185 words · Eric

Redshift Pipelines  [draft]

Reference Mark Smallcombe: 15 Examples of Data Pipelines Built with Amazon Redshift

July 25, 2018 · 1 min · 12 words · Eric

Redshift Data Ingestion from S3  [draft]

S3 -> COPY -> Redshift Staging Database -> Redshift Database Reference Data Engineering in S3 and Redshift with Python Amazon redshift: bulk insert vs COPYing from s3

May 25, 2018 · 1 min · 27 words · Eric

Understand AWS Redshift Query Execution Plan  [draft]

May 9, 2018 · 0 min · 0 words · Eric