My account
Book a demo
Search
product
product
Data Catalog
Data Community
Business Glossary
Data Profiling
Data Lineage
Reference Data Management
Report Catalog
Sensitive Data Discovery
Data Dictionary
Database Documentation
ER Diagrams
Schema Change Tracking
Supported
Technologies
See all features →
Solutions
Solutions
Metadata Management: Why Start Now?
By Use Case
Business Intelligence
Data Warehousing
Data Governance
Data Protection
Metadata Management
All Use Cases
By Industry
Financial Services
Healthcare
Public & Government
Education
Technology
All Industries
By Technology
SQL Server
Snowflake
Power BI
Azure
AWS
Supported Technologies
See all →
Pricing
Company
Why Dataedo?
About us
Careers
Our Customers
Case Studies
Testimonials
Contact Us
Resources
Resources
Dataedo Cartoons
General
Blog
Webinars
Videos
Library
Dataedo Cartoons
Dataedo
Documentation
Tutorials
Free trial
Download
Support
Contact support
Documentation
Tutorials
Free trial
Product tour
Database Data Dictionary Query Toolbox
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
Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please
accept statistics cookies
.
0
There are no comments.
Click here
to write the first comment.
Please enable JavaScript to view the
comments powered by Disqus.