Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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.
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"