Row Level Validation

SM14
New Contributor

‎12-18-2022 10:08 PM

I have two array one of devl other one is prod.Inside this there are many tables .How do i compare and check the count difference.Wanted to create a automated script so as to check the count difference and perform row level validation.

Pyspark script or SQL query.

Any kind of help will be appreciated.

Thanks !!

0 Kudos

Debayan
Databricks Employee
Databricks Employee

‎12-19-2022 08:49 AM

Hi, You can use except command for the same. Please refer: https://stackoverflow.com/questions/70366209/databricks-comparing-two-tables-to-see-which-records-ar....

Please let us know if this helps.

0 Kudos