Helpful Amazon Redshift Tutorials
October 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 moreSeptember 21, 2026 · RougeWarehouse Team
How to make Redshift DDL repeatable and safe: what ALTER TABLE can and cannot do, lock timeouts, additive expand-migrate-contract changes, deep-copy rename swaps, blue/green schema releases, a versioned migration runner and a CI pipeline that catches the expensive mistakes.
Read moreSeptember 21, 2026 · RougeWarehouse Team
Redshift does not enforce PRIMARY KEY, UNIQUE or FOREIGN KEY. Here is a practical data-quality layer: honest constraint checks, freshness and volume monitoring from the SYS views, a test suite the pipeline runs, and an atomic swap that keeps bad loads away from users.
Read more