Documentation

Table of Contents:


    Snowflake support

    Applies to: 8.x (current), Article available also for: 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.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy.
    Accept