List all columns wtih datatype in specific table in Snowflake

Question

I am looking for a programmatic way to get the Snowflake table schema, is there a way for that?

Answer 1

You can use a SHOW command to list table columns e.g.

SHOW COLUMNS IN TABLE MYSCHEMA.MYTABLE;

Note that SHOW commands have the advantage that they do not require a running warehouse to execute, so are zero cost queries.