SVV_INTEGRATION_TABLE_STATE displays details about table-level integration information.

SVV_INTEGRATION_TABLE_STATE is visible only to superusers. For more information, see Visibility of data in system tables and views.

For more information, see Working with zero-ETL integrations.

Table columns

Column name Data type Description
integration_id character(128) The identifier associated with the integration.
target_database character(128) The name of the Amazon Redshift database.
schema_name character(128) The name of the Amazon Redshift schema.
table_name character(128) The name of the table.
table_state character(128) The state of the table. Possible values are Synced, Failed, Deleted, ResyncRequired, and ResyncInitiated.
table_last_replicated_checkpoint character(128) The current synced log coordinates.
reason character(256) The reason for the last state transition. Common reasons can be unsupported data types in tables, tables don't have primary keys. To learn more about how to troubleshoot common issues, see Troubleshooting zero-ETL integrations in Amazon Redshift.
last_updated_timestamp timestamp without time zone The time (UTC) when the table is last updated.

Sample queries

The following SQL command displays the log of integrations.

select * from svv_integration_table_state; integration_id | target_database | schema_name | table_name | Table_state |table_last_replicated_checkpoint | reason | last_updated_timestamp --------------------------------------+-----------------+-------------+-------------------+--------------+---------------------------------+------------------------------------- 4798e675-8f9f-4686-b05f-92c538e19629 | sample_test2 | sample | SampleTestChannel | Synced | {"txn_seq":3,"txn_id":3122} | | 2023-05-12 12:40:30.656625