Snowflake Data Dictionary Query Toolbox

Databases and schemas

List databases in Snowflake
List schemas in Snowflake
List user created schemas in Snowflake

Tables

List tables in Snowflake
List tables in Snowflake schema
Find recently created tables in Snowflake
Find recently modified tables in Snowflake

Columns

List table columns in Snowflake
List all columns in specific table in Snowflake

Views

List views in Snowflake with their scripts
List views columns in Snowflake

Primary keys

List all primary keys (PKs) in Snowflake
List tables with their primary keys (PKs) in Snowflake
Find tables without primary keys (PKs) in Snowflake
How many tables don't have primary keys (with percentage) in Snowflake

Foreign keys

List foreign keys in Snowflake
List all tables refrenced by specific table (by FK) in Snowflake
List all tables referencing a specific table (by FK) in Snowflake
List tables with most foreign keys in Snowflake
List most referenced tables (by FK) in Snowflake
List tables with most relationships in Snowflake
Find tables without foreign keys in Snowflake
Find tables that are not referenced by the foreign keys in Snowflake
Find tables without relationships - Loner Tables - in Snowflake
Loner Ratio - how many tables have no relationships in Snowflake

Unique keys

List unique keys and indexes in Snowflake

Default values

List table default values in Snowflake
Compare default values of different columns with the same name in Snowflake database
Summary of default values in Snowflake

Constraints

List all table constraints (PK, FK, Unique, Default) in Snowflake
Find required (non nullable) columns in Snowflake
Check if is column nullable in Snowflake

Data types

Find most used data type in Snowflake
Find all numeric columns in Snowflake
Find all string (character) columns in Snowflake database
Find all date and time columns in Snowflake
Find all semi-structured data columns in Snowflake

Functions and stored procedures

List user defined functions (UDFs) in Snowflake

Searching schema

Find a table by the name in Snowflake
Find tables with names with specific prefix in Snowflake
Find tables with names with specific suffix in Snowflake
Find tables with specific word in name in Snowflake
Find tables with digits in names in Snowflake
Find tables with specific column name in Snowflake
Find table that DON'T have a column with specific name in Snowflake

Schema statistics

Find number of tables in Snowflake
Find number of columns in Snowflake
List tables with the largest number of columns in Snowflake
Average number of columns per table in Snowflake

Schema naming

Find most popular column names in Snowflake
Get column name length distribution in Snowflake
List columns by name length in Snowflake

Security and users

List users in Snowflake

Session

Find last query executed by specific user in Snowflake
Find queries executed in specific time range in Snowflake
Find queries executed in specific warehouse in Snowflake
List sessions / active connections in Snowflake
Find last query executed by specific session in Snowflake
Abort (kill) specific session on a server

Environment

How to check the Snowflake version

Number of rows

List tables by the number of rows in Snowflake
Find empty tables in Snowflake
Number of tables by the number of rows in Snowflake

Data size

List tables by their size in Snowflake
List 10 largest tables in Snowflake

Data usage

Find unused tables in Snowflake
Find tables not accessed for past n months in Snowflake

Schema compare

Compare tables and columns in two databases in Snowflake
Compare tables and columns in two schemas in Snowflake

There are no comments. Click here to write the first comment.

Supported Technologies

Metadata Management: Why Start Now?

Why Dataedo?

Dataedo Cartoons

Snowflake Data Dictionary Query Toolbox

Supported
Technologies