Managing zero-ETL integrations - Amazon Redshift
Sharing your data in 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).

Managing zero-ETL integrations

You can view the details of a zero-ETL integration to see its configuration information and status on the Amazon Redshift console.

To view the details of a zero-ETL integration

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Redshift console at https://console.amazonaws.cn/redshiftv2/.

  2. From the left navigation pane, choose either the Serverless or Provisioned clusters dashboard. Then, choose Zero-ETL integrations.

  3. Select the zero-ETL integration that you want to view. For each integration, the following information is provided:

    • Integration ID is the identifier returned when the integration is created.

    • Status can be one of the following:

      • Active – The zero-ETL integration is sending transactional data to the target Amazon Redshift data warehouse.

      • Syncing – The zero-ETL integration has encountered a recoverable error and is reseeding data. Affected tables aren’t available for querying in Amazon Redshift until they finish resyncing.

      • Failed – The zero-ETL integration encountered an unrecoverable event or error that can't be fixed. You must delete and recreate the zero-ETL integration.

      • Creating – The zero-ETL integration is being created.

      • Deleting – The zero-ETL integration is being deleted.

      • Needs attention – The zero-ETL integration encountered an event or error that requires manual intervention to resolve it. To fix the issue, follow the steps in the error message.

    • Source ARN is the ARN of the source data.

    • Destination is the ARN of the target data warehouse namespace.

    • Database can be one of the following:

      • No database – There is no destination database for the integration.

      • Creating – Amazon Redshift is creating the destination database for the integration.

      • Active – Data is being replicated from the integration source to Amazon Redshift.

      • Error – There is an error with the integration.

      • Recovering – The integration is recovering after the data warehouse restarted.

      • Resyncing – Amazon Redshift is resynchronizing the tables in the integration.

    • Destination type is the type of Amazon Redshift data warehouse.

    • Creation date is the date and time (UTC) when the integration was created.

Note

To view integration details for a data warehouse, choose the details page for your provisioned cluster or serverless namespace and then choose the Zero-ETL integrations tab.

From the Zero-ETL integrations list, you can choose Query data to jump to Amazon Redshift query editor v2. The Amazon Redshift target database has the enable_case_sensitive_identifier parameter enabled. When you write SQL, you might need to surround schemas, tables, and column names with double quotes ("<name>"). For more information about querying data in your Amazon Redshift data warehouse, see Querying a database using the Amazon Redshift query editor v2.

From the Zero-ETL integrations list, you can choose Share data to create a datashare. To create a datashare for the Amazon Redshift database, follow the instructions on the Create datashare page. Before you can share data in your Amazon Redshift database, you must first create a destination database. For more information about data sharing, see Data sharing concepts for Amazon Redshift.

To refresh your integration, you can use the ALTER DATABASE command. Doing so replicates all of the data from your integration source into your destination database. The following example refreshes all synced and failed tables within your zero-ETL integration.

ALTER DATABASE sample_integration_db INTEGRATION REFRESH ALL tables;

Sharing your data in Amazon Redshift

After you add data to the source, it's immediately replicated into Amazon Redshift and ready to be shared by creating datashares.

To share data, you must create a destination database first.

Important

To share data from an Amazon Redshift preview data warehouse to an Amazon Redshift consumer data warehouse, your consumer data warehouse must be on the preview_2023 track. For more information about datashares, see What is a datashare? in the Amazon Redshift Database Developer Guide.

To create a target data warehouse in preview, see one of the following topics depending on your deployment type:

Sharing data in Amazon Redshift Serverless using the Amazon Redshift console

  1. In the Amazon Redshift console, in the left navigation pane, choose Amazon Redshift Serverless > Serverless dashboard.

  2. From the left navigation pane, choose Zero-ETL integrations.

  3. Choose Share data.

  4. On the create datashare page, follow the steps in Creating datashares.

Sharing data in Amazon Redshift provisioned clusters using the Amazon Redshift console

  1. In the Amazon Redshift console, in the left navigation pane, choose Provisioned clusters dashboard.

  2. From the left navigation pane, choose Zero-ETL integrations.

  3. From the integration list, choose an integration.

  4. On the integration details page, choose Connect to database.

  5. On the Connection to database page, you can either create a new connection or use a recent connection. Make sure that the connection is made to the destination database.

  6. If you create a new connection, then enter a Database name for the database. Then, click Connect.

  7. On the integration details page, choose Share data.

  8. On the create datashare page, follow the steps in Creating datashares.