Snowflake support

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

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.