20 Oct 18 · victor ·       Add to Favorites  

Find the space consumed by a table / schema in Snowflake

We can use the information schema to find the space consumed by a table in Snowflake.

To find the space consumed (GB) per schema:

select table_schema,(sum(bytes)*1024*1024*1024) as Space_GB
from mydatabase.information_schema.tables
group by table_schema;

To find the tablewise space consumption:

select table_schema,table_name,(sum(bytes)*1024*1024*1024) as Space_GB
from mydatabase.information_schema.tables
group by table_schema,table_name;

victor

posted on 20 Oct 18

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

Copied