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.