How can i check what settings have been used when creating a zeroETL database in redshift

To check the settings used when creating a zero-ETL database in Amazon Redshift, including settings like TRUNCATECOLUMNS and QUERY_ALL_STATES, you can query the SVV_INTEGRATION system view. This view provides information about the configuration details of your zero-ETL integrations.

Additionally, you can monitor your zero-ETL integrations through several other system views:

1. SVV_INTEGRATION - Shows configuration details of your zero-ETL integrations
2. SYS_INTEGRATION_ACTIVITY - Provides information about completed zero-ETL integrations
3. SVV_INTEGRATION_TABLE_MAPPING - Shows mapping metadata values from source to target
4. SVV_INTEGRATION_TABLE_STATE - Provides information about integration state
5. SYS_INTEGRATION_TABLE_ACTIVITY - Shows insert, delete, and update activity of integrations
6. SYS_INTEGRATION_TABLE_STATE_CHANGE - Provides information about table state change logs

You can also check the integration settings through the Amazon Redshift console by navigating to the "Zero-ETL integrations" section in the left navigation pane and selecting your integration ID. This will display metrics and configuration details for your integration.
Sources
Monitoring zero-ETL integrations - Amazon Redshift
How to check Change data capture (CDC) on RDS Zero ETL | AWS re:Post