How to find what records were added between the 2 versions of a Delta Table

- - Certifications
- - Learning Paths
- - Databricks Product Tours
- - Get Started Guides
- - Product Platform Updates

- - Get Started Resources
- - Events
- - Support FAQs
- - Technical Blog
- - Knowledge Sharing Hub
- - Announcements
- - DatabricksTV

- - Private Groups
  - Farfetch Databricks User Community
- - Skills@Scale

- - Databricks Community Champions
- - Khoros Community Forums Support (Not for Databricks Product Questions)
- - Databricks Community Code of Conduct

Data Engineering

Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.

1 ACCEPTED SOLUTION

Accepted Solutions

SELECT * FROM delta_table_name@v2 EXCEPT ALL FROM delta_table_name@v0

View solution in original post

1 REPLY 1

SELECT * FROM delta_table_name@v2 EXCEPT ALL FROM delta_table_name@v0

never-displayed

You must be signed in to add attachments

never-displayed

Announcements

Data + AI Summit 2025 — registration now open!

Unlocking Next-Gen Customer Experiences with Data Intelligence for Marketing

Deep Dive: How Row-level Concurrency Works Out of the Box

2025 DLT Update: Intelligent, fully governed data pipelines

Databricks Community

How to find what records were added between the 2 versions of a Delta Table

Join Us as a Local Community Builder!

Data + AI Summit 2025 — registration now open!

Unlocking Next-Gen Customer Experiences with Data Intelligence for Marketing

Deep Dive: How Row-level Concurrency Works Out of the Box

2025 DLT Update: Intelligent, fully governed data pipelines