changefeed.change_feed_table_groups (Transact-SQL)
Applies to: 
SQL Server 2022 (16.x)
Azure SQL Database
Azure Synapse Analytics
Contains metadata that is used to configure change feed table groups for Azure Synapse Link for SQL.
| Column name | Data type | Description |
|---|---|---|
table_group_id |
uniqueidentifier | Unique identifier of the change feed table group. |
table_group_name |
nvarchar(140) | The name of the table group. |
destination_location |
nvarchar(512) | URL string of the landing zone folder. |
destination_credential |
sysname | The credential name to access the landing zone. |
workspace_id |
nvarchar(247) | The related Azure Synapse Analytics workspace Azure resource ID. |
synapse_workgroup_name |
nvarchar(50) | The related Synapse workspace name. |
enabled |
bit | Tracks if the table group is enabled for change feed. 1 - Yes, 0 - No. |
Remarks
The changefeed.change_feed_table_groups system table isn't used in Fabric mirrored databases, instead use the sys.sp_help_change_feed_table_groups system stored procedure.