23 Apr 20 · npack · #Snowflake ·   Bookmark   ×

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

npack

posted on 23 Apr 20

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds