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
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
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