Snowflake support

Applies to: 10.x (current) versions, Article available also for: 9.x, 8.x, 7.x

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

Found issue with this article? Comment below
0
There are no comments. Click here to write the first comment.