Script to iterate through the tables in a database

Job ID: 33332568

Budget: $10 – $30 CAD

I have a simple task which needs to iterate through the tables in a database and query the count(*) of the each table and store the result in a separate table. This should be done by using pyspark / sql / spark using databricks.
Related categories: SQL MySQL Microsoft SQL Server PySpark Apache Spark