Amazon Redshift now supports refresh interval in a zero-ETL integration

This set of tasks walks you through setting up your first zero-ETL integration. First, you configure your integration source and set it up with the required parameters and permissions. Then, you continue to the rest of the initial setup from the Amazon Redshift console or AWS CLI.

Topics

• Create and configure a target Amazon Redshift data warehouse
• Turn on case sensitivity for your data warehouse
• Configure authorization for your Amazon Redshift data warehouse
• Create a zero-ETL integration

Creating destination databases in Amazon Redshift
To replicate data from your source into Amazon Redshift, you must create a database from your integration in Amazon Redshift.

Connect to your target Redshift Serverless workgroup or provisioned cluster and create a database with a reference to your integration identifier. This identifier is the value returned for integration_id when you query the SVV_INTEGRATION view.

Note- Before creating a database from your integration, your zero-ETL integration must be created and in the Active state on the Amazon Redshift console.

Before you can start replicating data from your source into Amazon Redshift, create a database from the integration in Amazon Redshift. You can either create the database using the Amazon Redshift console or the query editor v2.

1. In the left navigation pane, choose Zero-ETL integrations.
2. From the integration list, choose an integration.
3. If you're using a provisioned cluster, you must first connect to the database. Choose Connect to database. You can connect using a recent connection, or by creating a new connection.
4. To create a database from the integration, choose Create database from integration.
5. Enter a Destination database name. The Integration ID and Data warehouse name are pre-populated. For Aurora PostgreSQL sources, enter the Source named database that you specified when creating your zero-ETL integration. You can map a maximum of 100 Aurora PostgreSQL databases to Amazon Redshift databases.
6. Choose Create database.

Ref: Getting started with zero-ETL integrations