Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

Viewing the column name of the snowflake table

jaejeon
Dataiker
Viewing the column name of the snowflake table

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
 

 

0 Kudos
1 Reply
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"
0 Kudos