https://community.databricks.com/t5/data-engineering/row-level-validation/m-p/16051#M10270 <P>Hi, You can use except command for the same. Please refer: <A href="https://stackoverflow.com/questions/70366209/databricks-comparing-two-tables-to-see-which-records-are-missing" target="test_blank">https://stackoverflow.com/questions/70366209/databricks-comparing-two-tables-to-see-which-records-are-missing</A>. </P><P>Please let us know if this helps.</P><P></P> Mon, 19 Dec 2022 16:49:55 GMT Debayan 2022-12-19T16:49:55Z https://community.databricks.com/t5/data-engineering/row-level-validation/m-p/16050#M10269 <P>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.</P><P>Pyspark script or SQL query.</P><P>Any kind of help will be appreciated.</P><P>Thanks !!</P> Mon, 19 Dec 2022 06:08:44 GMT https://community.databricks.com/t5/data-engineering/row-level-validation/m-p/16050#M10269 SM14 2022-12-19T06:08:44Z https://community.databricks.com/t5/data-engineering/row-level-validation/m-p/16051#M10270 <P>Hi, You can use except command for the same. Please refer: <A href="https://stackoverflow.com/questions/70366209/databricks-comparing-two-tables-to-see-which-records-are-missing" target="test_blank">https://stackoverflow.com/questions/70366209/databricks-comparing-two-tables-to-see-which-records-are-missing</A>. </P><P>Please let us know if this helps.</P><P></P> Mon, 19 Dec 2022 16:49:55 GMT https://community.databricks.com/t5/data-engineering/row-level-validation/m-p/16051#M10270 Debayan 2022-12-19T16:49:55Z