Documentation

Table of Contents:


    Snowflake support

    2018-06-07 2018-09-13

    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
    • 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.
    Found issue with this article? Comment below
    Comments (0)