topic Re: How to capture/Identify Incremental rows when No primary key columns in tables in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-capture-identify-incremental-rows-when-no-primary-key/m-p/62658#M32034 <P>Hi,&nbsp;</P><P>what kind of SQL source is it? MS SQL, MySQL, PostgreSQL?</P> Tue, 05 Mar 2024 14:34:55 GMT Slaw 2024-03-05T14:34:55Z How to capture/Identify Incremental rows when No primary key columns in tables https://community.databricks.com/t5/data-engineering/how-to-capture-identify-incremental-rows-when-no-primary-key/m-p/62584#M32004 <P>Q1. My source is SQL server tables, I want to identify only latest records(incremental rows) and load those into BRNZE layer. Instead of full load to ADLS, we want to capture only incremental rows and load into ADLS for further processing.&nbsp;</P><P><STRONG>NOTE:</STRONG> Problem here is table has <STRONG>NO PRIMARY KEY column or DATE columns</STRONG> for identification. Could someone please help on this?</P> Mon, 04 Mar 2024 12:34:19 GMT https://community.databricks.com/t5/data-engineering/how-to-capture-identify-incremental-rows-when-no-primary-key/m-p/62584#M32004 Govind3331 2024-03-04T12:34:19Z Re: How to capture/Identify Incremental rows when No primary key columns in tables https://community.databricks.com/t5/data-engineering/how-to-capture-identify-incremental-rows-when-no-primary-key/m-p/62658#M32034 <P>Hi,&nbsp;</P><P>what kind of SQL source is it? MS SQL, MySQL, PostgreSQL?</P> Tue, 05 Mar 2024 14:34:55 GMT https://community.databricks.com/t5/data-engineering/how-to-capture-identify-incremental-rows-when-no-primary-key/m-p/62658#M32034 Slaw 2024-03-05T14:34:55Z