When data is loaded from datavese to Azure Data Lake Storage gen2 using Append-Only Loading, existing records aren’t updated, but instead appended to tables as new rows. This means that as time goes on, tables will contain different versions of the same record, reflecting how the record has changed over time.
How can I get the latest version of a record ?