Viewing the column name of the snowflake table

jaejeon
jaejeon Dataiker, Registered Posts: 2 Dataiker

When creating a dataset with a Snowflake table in Dataiku, is it possible to view the column names (COMMENT) of the Snowflake table in Dataiku? We need to see the column names (COMMENT) of the Snowflake table in the Dataiku dataset due to standardization requirements, but they are not visible. We are inquiring about this issue.

Screenshot 2023-08-03 at 10.32.59 AM.pngScreenshot 2023-08-03 at 10.33.23 AM.png

Answers

  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,992 Neuron
    edited July 17

    Hi, table and column comments are not usually retrieved with data but are usually available in the metadata tables/views provided by the database technology. For Snowflake you can use:

    SELECT * FROM "SNOWFLAKE"."INFORMATION_SCHEMA"."COLUMNS"

    for columns and this one for tables:

    SELECT * FROM "SNOWFLAKE"."INFORMATION_SCHEMA"."TABLES"
Setup Info
    Tags
      Help me…