MariuszK
Valued Contributor III

hi,

You can use ADF to extract data incrementally into the bronze layer, and use DLT to load this data into silver with SCD1 or SCD2.

You will need to store somewhere information about last extracted ID and read it in ADF pipeline to get only new records.