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