Snowflake snippets

How to describe a table structure in Snowflake

To query the structure of a table you can just use the following snippet:

SELECT column_name, data_type, character_maximum_length, column_default, is_nullable
FROM INFORMATION_SCHEMA.COLUMNS 
WHERE table_name = 'FOOD';

Back to Snowflake cookbook page