Viewing and monitoring Amazon RDS zero-ETL integrations with Amazon Redshift - Amazon Relational Database Service
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).

Viewing and monitoring Amazon RDS zero-ETL integrations with Amazon Redshift

This is prerelease documentation for Amazon RDS zero-ETL integrations with Amazon Redshift, which is in preview release. The documentation and the feature are both subject to change. We recommend that you use this feature only in test environments, and not in production environments. For preview terms and conditions, see Betas and Previews in Amazon Service Terms.

You can view the details of an Amazon RDS zero-ETL integration to see its configuration information and current status. You can also monitor the status of your integration by querying specific system views in Amazon Redshift. In addition, Amazon Redshift publishes certain integration-related metrics to Amazon CloudWatch, which you can view within the Amazon Redshift console.

Viewing integrations

You can view Amazon RDS zero-ETL integrations with Amazon Redshift using the Amazon Web Services Management Console, the Amazon CLI, or the RDS API.

To view the details of a zero-ETL integration
  1. Sign in to the Amazon Web Services Management Console and open the Amazon RDS console at

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

  3. Select an integration to view more details about it, such as its source database and target data warehouse.

    Details about a zero-ETL integration

An integration can have the following statuses:

  • Creating – The integration is being created.

  • Active – The integration is sending transactional data to the target data warehouse.

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

  • Needs attention – The integration encountered an event or error that requires manual intervention to resolve it. To fix the issue, follow the instructions in the error message on the integration details page.

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

  • Deleting – The integration is being deleted.

To view all zero-ETL integrations in the current account using the Amazon CLI, use the describe-integrations command and specify the --integration-identifier option.

For Linux, macOS, or Unix:

aws rds describe-integrations \ --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374

For Windows:

aws rds describe-integrations ^ --integration-identifier ee605691-6c47-48e8-8622-83f99b1af374

To view zero-ETL integration using the Amazon RDS API, use the DescribeIntegrations operation with the IntegrationIdentifier parameter.

Monitoring integrations using system tables

Amazon Redshift has system tables and views that contain information about how the system is functioning. You can query these system tables and views the same way that you would query any other database table. For more information about system tables and views in Amazon Redshift, see System tables reference in the Amazon Redshift Database Developer Guide.

You can query the following system views and tables to get information about your zero-ETL integrations with Amazon Redshift:

All integration-related Amazon CloudWatch metrics originate from Amazon Redshift. For more information, see Monitoring zero-ETL integrations in the Amazon Redshift Management Guide. Currently, Amazon RDS doesn't publish any integration metrics to CloudWatch.

Monitoring integrations with Amazon EventBridge

Amazon Redshift sends integration-related events to Amazon EventBridge. For a list of events and their corresponding event IDs, see Zero-ETL integration event notifications with Amazon EventBridge in the Amazon Redshift Management Guide.