Viewing and monitoring Amazon RDS zero-ETL integrations with Amazon Redshift
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.
Topics
Viewing integrations
You can view Amazon RDS zero-ETL integrations with Amazon Redshift using the AWS Management Console, the AWS CLI, or the RDS API.
To view the details of a zero-ETL integration
Sign in to the AWS Management Console and open the Amazon RDS console at https://console.aws.amazon.com/rds/
. -
From the left navigation pane, choose Zero-ETL integrations.
-
Select an integration to view more details about it, such as its source database and target data warehouse.
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 AWS 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:
-
SVV_INTEGRATION – Provides configuration details for your integrations.
-
SVV_INTEGRATION_TABLE_STATE – Describes the state of each table within an integration.
-
SYS_INTEGRATION_TABLE_STATE_CHANGE – Displays table state change logs for an integration.
-
SYS_INTEGRATION_ACTIVITY – Provides information about completed integration runs.
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.