Create a zero-ETL integration for Aurora
In this step, you create an Aurora zero-ETL integration with Amazon Redshift.
To create an Aurora zero-ETL integration with Amazon Redshift
-
From the Amazon RDS console, create a custom DB cluster parameter group as described in the Amazon Aurora User Guide.
-
From the Amazon RDS console, create a source Amazon Aurora DB cluster as described in the Amazon Aurora User Guide.
-
From the Amazon Redshift console: Create and configure a target Amazon Redshift data warehouse.
-
From the Amazon CLI or Amazon Redshift console: Turn on case sensitivity for your data warehouse.
-
From the Amazon Redshift console: Configure authorization for your Amazon Redshift data warehouse.
-
-
From the Amazon RDS console, create a zero-ETL integration as described in the Amazon Aurora User Guide.
-
From the Amazon Redshift console or the query editor v2, create an Amazon Redshift database from your integration.
Then, query and create materialized views with replicated data.
For detailed information to create Aurora zero-ETL integrations, see Creating Amazon Aurora zero-ETL integrations with Amazon Redshift in the Amazon Aurora User Guide.