How to find the Storage size of a SINGLE COLUMN in a Table in Snowflake ?

Snowflake doesn't capture the column level size. If you need this information for planning purposes, you can create a new temp table with just that one column and then use that size for your estimates

For example:

create transient table <transient_table> as select col from <source_table>;

The size of the resulting table should be reasonably close to the actual size of the column in the source table. The sizes likely won't match exactly because of compression ratio differences between the two tables

nVector

posted on 23 Apr 20