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';
Nicola Simboli Senior Analytics Engineer
15+ years across SaaS, enterprise and consulting. Focused on scalable data platforms, metric reliability and analytics systems that teams actually use.