Create a zero-ETL integration for Amazon RDS - Amazon Redshift
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Create a zero-ETL integration for Amazon RDS

In this step, you create an RDS zero-ETL integration with Amazon Redshift.

To create an RDS zero-ETL integration with Amazon Redshift

  1. From the Amazon RDS console, create a custom DB parameter group as described in the Amazon RDS User Guide.

  2. From the Amazon RDS console, create a source Amazon RDS instance as described in the Amazon RDS User Guide.

  3. From the Amazon Redshift console: Create and configure a target Amazon Redshift data warehouse.

  4. From the Amazon RDS console, create a zero-ETL integration as described in the Amazon RDS User Guide.

  5. 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.

The Amazon RDS console offers a step-by-step integration creation flow, in which you specify the source database and the target Amazon Redshift data warehouse. If issues occur, then you can choose to have Amazon RDS fix the issues for you instead of manually fixing them on either the Amazon RDS or Amazon Redshift console.

For detailed instructions to create RDS zero-ETL integrations, see Creating Amazon RDS zero-ETL integrations with Amazon Redshift in the Amazon RDS User Guide.