topic How to find what records were added between the 2 versions of a Delta Table in Data Engineering https://community.databricks.com/t5/data-engineering/how-to-find-what-records-were-added-between-the-2-versions-of-a/m-p/18639#M12406 Fri, 25 Jun 2021 21:41:22 GMT brickster_2018 2021-06-25T21:41:22Z How to find what records were added between the 2 versions of a Delta Table https://community.databricks.com/t5/data-engineering/how-to-find-what-records-were-added-between-the-2-versions-of-a/m-p/18639#M12406 Fri, 25 Jun 2021 21:41:22 GMT https://community.databricks.com/t5/data-engineering/how-to-find-what-records-were-added-between-the-2-versions-of-a/m-p/18639#M12406 brickster_2018 2021-06-25T21:41:22Z Re: How to find what records were added between the 2 versions of a Delta Table https://community.databricks.com/t5/data-engineering/how-to-find-what-records-were-added-between-the-2-versions-of-a/m-p/18640#M12407 <PRE><CODE>SELECT * FROM delta_table_name@v2 EXCEPT ALL FROM delta_table_name@v0</CODE></PRE><P></P> Fri, 25 Jun 2021 21:41:34 GMT https://community.databricks.com/t5/data-engineering/how-to-find-what-records-were-added-between-the-2-versions-of-a/m-p/18640#M12407 brickster_2018 2021-06-25T21:41:34Z