Viewing the column name of the snowflake table

jaejeon

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.

Turribeach

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"