changefeed.change_feed_tables (Transact-SQL)

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure Synapse Analytics

Contains metadata that is used to configure change feed tables for Azure Synapse Link for SQL.

Column name	Data type	Description
`table_group_id`	uniqueidentifier	Unique Identifier of the change feed table group.
`table_id`	uniqueidentifier	Unique Identifier of the link table. Generated by the setup flow.
`object_id`	uniqueidentifier	Object ID of the original table in SQL database.
`state`	tinyint	Current state of table. Valid state values: 1 - Enabled. 2 - Exporting. 3 - Exported. 4 - Active. 5 - Disabled. 6 - Pending Disablement.
`version`	binary(10)	The table's version at the time of capturing the table version Log Sequence Number (LSN).
`enable_lsn`	binary(10)	The LSN value when Azure Synapse Link starts tracking table changes.
`disable_lsn`	binary(10)	The LSN value when Azure Synapse Link stops tracking table changes.
`snapshot_phase`	tinyint	Phase of the current snapshot, which progresses from one to six. `ABORT_PRIOR_SNAPSHOT_IF_ANY` = 1 `SET_TABLEVERSIONLSN` = 2 `EXPORT_SCHEMA_FILE` = 3 `EMIT_SNAPSHOT_BEGINENTRY` = 4 `EXPORT_DATA_FILE` = 5 `EMIT_SNAPSHOT_ENDENTRY` = 6
`snapshot_current_phase_time`	datetime	Time when the current snapshot phase started.
`snapshot_retry_count`	int	Number of times snapshot has attempted to retry.
`snapshot_start_time`	datetime	Start time of snapshot phase.
`snapshot_end_time`	datetime	End time of snapshot phase.

Remarks

The changefeed.change_feed_tables system table isn't used in Fabric mirrored databases, instead use the sys.sp_help_change_feed_table system stored procedure.