Monitoring zero-ETL integrations
You can monitor your zero-ETL integrations by querying the system views or with Amazon EventBridge.
Monitoring zero-ETL integrations with Amazon Redshift system views
You can monitor your zero-ETL integrations by querying the following system views in Amazon Redshift.
-
SVV_INTEGRATION provides information about configuration details of zero-ETL integrations.
-
SYS_INTEGRATION_ACTIVITY provides information about completed zero-ETL integrations.
-
SVV_INTEGRATION_TABLE_STATE provides information about integration state.
-
SYS_INTEGRATION_TABLE_ACTIVITY provides information about insert, delete, and update activity of integrations.
-
SYS_INTEGRATION_TABLE_STATE_CHANGE provides information about table state change log for integrations.
Monitoring zero-ETL 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.