Viewing and monitoring Aurora zero-ETL integrations with Amazon Redshift - Amazon Aurora
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 Aurora zero-ETL integrations with Amazon Redshift

You can view the details of an Amazon Aurora 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 Aurora 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 https://console.amazonaws.cn/rds/.

    If the integration has an Aurora PostgreSQL source DB cluster, you must sign in to the Amazon RDS Database Preview Environment at https://us-east-2.console.aws.amazon.com/rds-preview/home?region=us-east-2#databases.

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

  3. Select an integration to view more details about it, such as its source DB cluster 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 Aurora 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 Aurora 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.