title: How to get actual, specific column data types in Snowflake using SQL?
body: <p>I need to get column data types for multiple Snowflake tables and views, using SQL. SQL can be Snowflake-specific.</p>
  <p>I know that this task can be accomplished by querying standard <code>INFORMATION_SCHEMA</code> objects. However, the column data types returned from such a query are generalized types like TEXT, NUMBER etc. I am trying to get actual Snowflake column data types, e.g. VARCHAR, DATETIME, SMALLINT etc.</p>
  <p>In SQL Server, for example, this can be done by querying <code>sys</code> views. Is there an equivalent set of objects in Snowflake that can be queried? I haven’t been able to find any.</p>
  <p>Additional constraint is that it should be a single query that returns column types for multiple tables, not one query per table or view.</p>