Walter_C
Databricks Employee
Databricks Employee

List All Tables: In each notebook, write a SQL query to list all tables in the respective environment. You can use a query like: 

SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'your_schema_name';

Count Rows and Perform Distinct Checks: For each table, write SQL queries to count the number of rows and perform a few distinct checks. For example:

SELECT COUNT(*) AS row_count
FROM your_table_name;

SELECT COUNT(DISTINCT your_column_name) AS distinct_count
FROM your_table_name;