Helpful Amazon Redshift Tutorials
August 25, 2026 · RougeWarehouse Team
Stop scheduling COPY with cron and Lambda. Redshift COPY JOB loads new S3 objects as they arrive. File layout, compression, the job definition, and monitoring with SYS_LOAD_HISTORY.
Read moreAugust 25, 2026 · RougeWarehouse Team
Producer and consumer setup for Amazon Redshift data sharing: creating the datashare, granting it to another account, authorizing and associating it, querying shared data, and chargeback patterns.
Read moreAugust 25, 2026 · RougeWarehouse Team
Fifteen concrete things to check on any Amazon Redshift environment, provisioned or Serverless, that reliably reduce the bill: limits, scaling caps, priorities, materialized views, stale tables, storage growth and sharing.
Read moreAugust 25, 2026 · RougeWarehouse Team
Provisioned RA3 or Redshift Serverless? A workload-shape quadrant, the break-even arithmetic between node-hours and RPU-hours, the reserved-instance angle, and what the migration actually involves.
Read moreAugust 25, 2026 · RougeWarehouse Team
DC2 nodes are the legacy tier of Amazon Redshift. Here is the snapshot-restore path to RA3 or Serverless, how to translate sizing, what changes in behaviour, and the gotchas we hit on real migrations.
Read more