Snowflake support

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

Available from version 7.0.2 beta.

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
  • Procedures
    • Script
    • Parameters
  • 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

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