How to Check AWS Redshift ZeroETL Database Settings

Select Language:

If you’re working with a zero-ETL database in Amazon Redshift and want to check its settings, there’s a straightforward way to do this. First, you can run a query on the system view called SVV_INTEGRATION. This view shows details about how your zero-ETL integrations are set up, including options like TRUNCATECOLUMNS and QUERY_ALL_STATES.

In addition, several other system views can help you keep track of your integrations:

– SVV_INTEGRATION: Displays the main configuration details.
– SYS_INTEGRATION_ACTIVITY: Shows completed integration activities.
– SVV_INTEGRATION_TABLE_MAPPING: Reveals how data from sources maps to your target tables.
– SVV_INTEGRATION_TABLE_STATE: Provides the current status of your tables in the integration process.
– SYS_INTEGRATION_TABLE_ACTIVITY: Tracks insertions, deletions, and updates.
– SYS_INTEGRATION_TABLE_STATE_CHANGE: Logs changes in the status of your tables.

You can also view and monitor your integrations directly through the Amazon Redshift console. Simply go to the “Zero-ETL integrations” section listed on the left menu, then select your specific integration ID. This will display detailed metrics and configurations related to your setup.

For more detailed guidance, check out the official Amazon Redshift documentation on monitoring zero-ETL integrations or see how to verify change data capture (CDC) on RDS Zero E TL setups through AWS re:Post.