Use Case: Data Warehouse

Use CREATE TABLE AS SELECT to power a data warehouse — building bronze, silver and gold layer tables, an ETL pipeline with CTAS, aggregation tables, and best practices.