Helpful Amazon Redshift Tutorials
October 19, 2026 · RougeWarehouse Team
A design guide for the fact and dimension layer on Amazon Redshift: when a star schema beats a wide table, how distribution and sort keys follow from the model, surrogate keys and SCD2 point-in-time joins, column-type traps, and five checks that validate a model before the data grows.
Read moreOctober 12, 2026 · RougeWarehouse Team
A practical guide to querying S3 from Amazon Redshift with Spectrum: external schemas on the Glue Data Catalog, partition registration and projection, Parquet file layout, proving pushdown with SVL_S3QUERY_SUMMARY, and the guardrails that stop a per-terabyte scan bill from running away.
Read moreOctober 5, 2026 · RougeWarehouse Team
How to read an Amazon Redshift query plan: data-distribution labels, nested loops and row estimates, confirming them against SYS_QUERY_DETAIL, and the rewrites that fix broadcasts, zone-map misses, nested loops and disk spills.
Read moreSeptember 28, 2026 · RougeWarehouse Team
How to read and write Amazon Redshift from Apache Spark on AWS Glue and EMR: the built-in integration, IAM and temp S3 setup, which operations push down to Redshift, write modes and the failure patterns that silently cost you hours.
Read moreSeptember 21, 2026 · RougeWarehouse Team
Where business logic should live in a Redshift warehouse: inlined SQL UDFs, per-row Python UDFs and their performance trap, batched Lambda UDFs for external calls, and PL/pgSQL stored procedures with real error handling — plus a decision table and an inventory query.
Read more