Row Level Validation

[SM14]

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 !!

[Debayan]

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.