Viewing the column name of the snowflake table
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.
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 1,992 Neuron
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"