Hello @TejeshS,

Thanks for your question!

You need to set the delta.enableRowTracking property to true on the DLT base table. This can be done using the TBLPROPERTIES clause when creating or altering the table.

Example:

CREATE OR REPLACE TABLE catalog_name.silver_schema.base_dlt_table

TBLPROPERTIES ('delta.enableRowTracking' = 'true')

AS

SELECT col_a, col_b

FROM source_table;

Once row tracking is enabled on the base table, you can create the materialized view as usual. The materialized view will now be able to use the row tracking information to perform incremental refreshes