Helpful Amazon Redshift Tutorials
September 10, 2026 · RougeWarehouse Team
How to expose an Amazon Redshift warehouse to LLM agents safely: running the Redshift MCP server, what Amazon Q generative SQL needs from your schema, read-only roles and RLS, cost and concurrency guardrails, and how to log and evaluate agent-generated SQL.
Read moreSeptember 9, 2026 · RougeWarehouse Team
How AWS Glue zero-ETL integrations for applications replace bespoke SaaS connectors: creating the source connection, authorizing the Redshift target, choosing objects and refresh intervals, case-sensitive identifiers, and modelling the landed tables.
Read moreSeptember 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 more