Helpful Amazon Redshift Tutorials
September 9, 2026 · RougeWarehouse Team
A practical guide to dbt on Amazon Redshift: connection profiles for RA3 and Serverless, project layout, Redshift-specific model configs (dist, sort, late-binding views), incremental strategies including merge and microbatch, tests, and a CI job that builds only what changed.
Read moreAugust 27, 2026 · RougeWarehouse Team
A working tutorial for Amazon Redshift ML: the IAM setup, point-in-time feature views, CREATE MODEL with Autopilot, the cheaper AUTO OFF XGBoost path, bring-your-own-model, Bedrock LLM functions, and how to operate models over time.
Read moreAugust 25, 2026 · RougeWarehouse Team
An honest positioning piece from a Redshift shop: where Snowflake and Databricks are genuinely better, and the situations in which Amazon Redshift is the right choice and by a wide margin.
Read moreAugust 25, 2026 · RougeWarehouse Team
Put a Kinesis Data Stream behind a Redshift materialized view: external schema, the view definition with JSON parsing, auto-refresh, and handling late and duplicate records.
Read moreAugust 25, 2026 · RougeWarehouse Team
What Automatic Table Optimization actually does, when to trust SORTKEY AUTO and DISTSTYLE AUTO, how to read SVV_ALTER_TABLE_RECOMMENDATIONS, and the cases where pinning a compound sort key still wins.
Read more