Snowflake support

Connection requirements

To connect to Snowflake, you need to install Snowflake ODBC first.

Installation guide can be found here:

https://docs.snowflake.net/manuals/user-guide/odbc-windows.html

Supported schema elements and metadata

Current version imports:

• Tables
  • Columns
    • Data types
    • Nullability
    • Column comments
  • Table comments
• Views
  • Script
  • Columns
    • Data types
    • Column comments
  • View comments
• 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.

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