Snowflake support

Supported schema elements and metadata

Current version imports:

• Tables, External tables
  • Columns
    • Data types
    • Nullability
    • Column comments
  • Table comments
• 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.

Learn more

Connect to Snowflake