Helpful Amazon Redshift Tutorials
September 9, 2026 · RougeWarehouse Team
Run Redshift SQL without a JDBC driver, a VPC attachment or a password: ExecuteStatement and BatchExecuteStatement, named parameters, --with-event notifications, a Step Functions ELT state machine, idempotency with ClientToken, and the quotas to design around.
Read moreSeptember 9, 2026 · RougeWarehouse Team
What Redshift snapshots and Serverless recovery points actually cover, how to copy them across Regions and accounts, how to restore a single table, and how to set an RPO and RTO you can defend.
Read moreSeptember 9, 2026 · RougeWarehouse Team
A hands-on tutorial for reading Apache Iceberg data from Amazon Redshift: registering an S3 Tables bucket in the AWS Glue Data Catalog, wiring Lake Formation permissions, creating the external schema, and tuning the queries that follow.
Read moreSeptember 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 more