Improve your ETL performance using multiple Redshift warehouses for writes (Preview)

This article introduces a new feature in Amazon Redshift that allows using multiple warehouses to write to the same databases through data sharing. It explains the benefits of this approach and provides a step-by-step guide on how to set it up.

Specifically, the article covers:

• Reasons for using multiple warehouses to write to the same databases, such as better performance and predictability for mixed workloads, ability to control and monitor costs, and easier collaboration on live data.
• Overview of the solution architecture involving a primary warehouse (producer) and a secondary ETL warehouse (consumer).
• Prerequisites needed to follow along.
• Step-by-step guide on setting up the primary namespace (producer), including creating a database, schemas, tables, copying data, creating a datashare, granting permissions, and authorizing the secondary namespace.
• Step-by-step guide on setting up the secondary ETL namespace (consumer), including creating a database from the datashare, creating a user, granting permissions, and writing data to the shared database.
• Conclusion highlighting the key benefits of the multi-warehouse write approach.