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';