Fabric CDC messages can be classified into two main categories:
Schema update - initiated by updates on the LU level or by a CDC_REPUBLISH_SCHEMA command.
Data update - initiated by updates on a given LUI or by a CDC_REPUBLISH_INSTANCE.
The following diagram describes a list of events that trigger CDC messages:
Republish by demand a full LU schema definition or the schema of a selected list of LU tables.
An LU schema can be republished to all CDC consumers or to a selected list of CDC consumers.
Usage:
cdc_republish_schema <LUT_NAME> [types='<type1,type2...>'] [tables='table1,...'] [drop_table=true/false];
Parameters:
Note: You must run the CDC_REPUBLISH_INSTANCE command with TRUNCATE = FALSE on all Fabric LUIs to repopulate the data in the newly created indexes.
Examples:
cdc_republish_schema Customer;
cdc_republish_schema Customer types='Search','Tableau';
cdc_republish_schema Customer types='Search' tables='Address' drop_table=true;
When updating CDC metadata, i.e. adding, updating, or deleting CDC columns in LU tables, the LU must be redeployed to Fabric. The deployment initiates republish of the changes both in the LU schema and background LUI data whereby:
Note that if a new LU table with CDC columns is added to the LU schema, deployment of the updated LU republishes the metadata of the new LU table. However, the data of the new LU table cannot be republished to CDC consumers since it has not been synced with Fabric. In this scenario it is recommended to remigrate all LUIs to enable the population of the new LU table in Fabric and to enable Fabric to republish the data of the new LU table to CDC consumers. For example, to remigrate all customers:
BATCH Customer from fabric fabric_command='sync_instance Customer.?';
Click for more information about Batch commands.
Republish the CDC data of a selected LUI.
Usage:
cdc_republish_instance <LUT_NAME>.<INSTANCE_ID> [TABLES='<table1,tables2...>'] [TYPES='<type1,type2...>'] [TRUNCATE=true/false];
Parameters:
TABLES – the list of LU tables to be included in the CDC message.
TYPES – a list of CDC consumer types.
TRUNCATE – if True, send a CDC Delete Tables message about the LUI before republishing its CDC data. The default value is True.
Examples:
cdc_republish_instance Customer.1;
cdc_republish_instance Customer.1 tables='CUSTOMER, ADDRESS’;
cdc_republish_instance Customer.1 types='Search,Tableau';
cdc_republish_instance Customer.1 types='Search,Tableau' truncate=false;
cdc_republish_instance Customer.1 tables='CUSTOMER, ADDRESS’ types='Search,Tableau';
Fabric CDC messages can be classified into two main categories:
Schema update - initiated by updates on the LU level or by a CDC_REPUBLISH_SCHEMA command.
Data update - initiated by updates on a given LUI or by a CDC_REPUBLISH_INSTANCE.
The following diagram describes a list of events that trigger CDC messages:
Republish by demand a full LU schema definition or the schema of a selected list of LU tables.
An LU schema can be republished to all CDC consumers or to a selected list of CDC consumers.
Usage:
cdc_republish_schema <LUT_NAME> [types='<type1,type2...>'] [tables='table1,...'] [drop_table=true/false];
Parameters:
Note: You must run the CDC_REPUBLISH_INSTANCE command with TRUNCATE = FALSE on all Fabric LUIs to repopulate the data in the newly created indexes.
Examples:
cdc_republish_schema Customer;
cdc_republish_schema Customer types='Search','Tableau';
cdc_republish_schema Customer types='Search' tables='Address' drop_table=true;
When updating CDC metadata, i.e. adding, updating, or deleting CDC columns in LU tables, the LU must be redeployed to Fabric. The deployment initiates republish of the changes both in the LU schema and background LUI data whereby:
Note that if a new LU table with CDC columns is added to the LU schema, deployment of the updated LU republishes the metadata of the new LU table. However, the data of the new LU table cannot be republished to CDC consumers since it has not been synced with Fabric. In this scenario it is recommended to remigrate all LUIs to enable the population of the new LU table in Fabric and to enable Fabric to republish the data of the new LU table to CDC consumers. For example, to remigrate all customers:
BATCH Customer from fabric fabric_command='sync_instance Customer.?';
Click for more information about Batch commands.
Republish the CDC data of a selected LUI.
Usage:
cdc_republish_instance <LUT_NAME>.<INSTANCE_ID> [TABLES='<table1,tables2...>'] [TYPES='<type1,type2...>'] [TRUNCATE=true/false];
Parameters:
TABLES – the list of LU tables to be included in the CDC message.
TYPES – a list of CDC consumer types.
TRUNCATE – if True, send a CDC Delete Tables message about the LUI before republishing its CDC data. The default value is True.
Examples:
cdc_republish_instance Customer.1;
cdc_republish_instance Customer.1 tables='CUSTOMER, ADDRESS’;
cdc_republish_instance Customer.1 types='Search,Tableau';
cdc_republish_instance Customer.1 types='Search,Tableau' truncate=false;
cdc_republish_instance Customer.1 tables='CUSTOMER, ADDRESS’ types='Search,Tableau';