Skip to main content
Skip table of contents

Enable CDC on Azure SQL

Use the SQL Server CDC Source option for incremental masking. 

Enable CDC at database level:

EXEC sys.sp_cdc_enable_db;

Verify CDC is enabled:

SELECT name, is_cdc_enabled
    FROM sys.databases;

Enable CDC at each table level:

EXEC sys.sp_cdc_enable_table
    @source_schema = N Sales',
    @source_name   = N'customers',
    @role_name     = NULL,
    @supports_net_changes = 1

Verify the table has CDC enabled:

SELECT name, is_tracked_by_cdc
    FROM sys.tables
    where name = 'customers'
    and schema_id = SCHEMA_ID('sales');

Under Sink Settings, make sure to check all boxes.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.