SVV_INTEGRATION_TABLE_STATE
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. |
| table_rows | bigint | The total number of rows in the table. |
| table_size | bigint | The size of the table in megabytes (MB). |
Sample queries
The following SQL command displays the columns of 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 |table_rows | table_size --------------------------------------+-----------------+-------------+-------------------+--------------+---------------------------------+--------+----------------------------+------------+----------- 4798e675-8f9f-4686-b05f-92c538e19629 | sample_test2 | sample | SampleTestChannel | Synced | {"txn_seq":3,"txn_id":3122} | | 2023-05-12 12:40:30.656625 | 2 | 16
