Supported schema elements and metadata
Current version imports:
- Tables, External tables
- Columns
- Data types
- Nullability
- Column comments
- Table comments
- Columns
- Views
- Script
- Columns
- Data types
- Column comments
- View comments
- Procedures
- Script
- Parameters
- User-defined Functions
- Script
- Input arguments (all as a single field)
- Output results (as a single field)
- Function comments
Comments
Dataedo reads comments from following Snowflake objects:
- Tables
- Columns
- Views
- Columns
- Functions
Dataedo does not write comments back to Snowflake at this moment.
Data profiling
Datedo supports following data profiling in Snowflake:
- Tables
- Rows count
- Column distribution
- Distinct values
- Non-distinct values
- Empty
- NULL
- Numeric columns profile
- Minimum value
- Maximum value
- Average of values
- Variance of values
- Standard deviation
- Span as difference between min and max value
- Number of distinct values
- String columns profile
- Min value as first string in alphabetical order
- Max value as last string in alphabetical order
- Number of distinct values
- Date columns profile
- Min value as earliest date
- Max value as latest date
- Span as difference between min and max dates
- Number of distinct dates
- Top N values
- Top 10/100/1000 popular values
- All values if less than 1000 distinct
- 10 Random values
Read more about profiling in a Data Profliling documentation.
Under development
- Unique constraints names and tables
- Relations names and tables
- Splitting function arguments into separate lines
Known limitations
- Snowflake’s INFORMATION_SCHEMA currently doesn’t contain data on unique constraints and foreign keys columns and Dataedo doesn't import it. We will add this to import once Snowflake adds it to the metadata.
- There’s a similar limitation with object dependencies.