Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
11-05-2024 06:09 AM
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;