Helpful Amazon Redshift Tutorials
September 9, 2026 · RougeWarehouse Team
How to put Amazon Redshift Serverless under Terraform: namespace and workgroup resources, scoped IAM roles for COPY and Spectrum, scheduled RPU scaling, what Terraform should not own, and how to import a warehouse that was built by hand.
Read moreSeptember 9, 2026 · RougeWarehouse Team
A practical migration playbook for moving an on-premises Teradata, Oracle or SQL Server data warehouse to Amazon Redshift: assessment with AWS SCT, schema conversion, historical and CDC loads with DMS, SQL rewrite patterns, dual-run validation and cutover.
Read moreSeptember 9, 2026 · RougeWarehouse Team
A practical tutorial on semi-structured data in Amazon Redshift: loading JSON into SUPER columns, navigating and unnesting with PartiQL, choosing between keeping SUPER and shredding to columns, and the performance rules that decide which one is faster.
Read moreSeptember 9, 2026 · RougeWarehouse Team
A repeatable workflow for diagnosing slow Amazon Redshift queries with the SYS monitoring views, then fixing them with query priority, auto WLM query monitoring rules, concurrency scaling and RPU limits on Serverless.
Read moreSeptember 9, 2026 · RougeWarehouse Team
A hands-on Redshift security tutorial: nested roles instead of groups, row-level security driven by an entitlements table, dynamic data masking with priorities, and the datashare, materialized view and change-management gotchas.
Read more