how to get actual specific column data types in snowflake using sql?

If the COLUMNS-view ( doesn’t provide you enough information, you can try to use SHOW COLUMNS to list all columns from all tables for which you have access priviliges:

According to the docs you can see at least presicion and scale of the data type there:


CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top