Snowflake support

Applies to: Dataedo 9.x versions, Article available also for: 10.x (current), 8.x, 7.x
You are looking at documentation for an older release.
Switch to the documentation for Dataedo 10.x (current).

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


Dataedo reads comments from following Snowflake objects:

  • Tables
    • Columns
  • Views
    • Columns
  • Functions

Dataedo does not write comments back to Snowflake at this moment.

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
There are no comments. Click here to write the first comment.