Question

A data governance analyst needs to build a monthly report showing the total average bytes of storage consumed by each individual table across the entire account, including bytes attributable to Time Travel and Fail-safe. They want a single query that requires ACCOUNTADMIN-level visibility across all databases. Which approach should they use?

Accepted Answer

Query the TABLE_STORAGE_METRICS view in the SNOWFLAKE.ACCOUNT_USAGE schema, which reports active, Time Travel, and Fail-safe bytes per table for the whole account

Answer

Query the TABLES view in each database's INFORMATION_SCHEMA and sum the BYTES column across all schemas

Answer

Query the STORAGE_USAGE view in SNOWFLAKE.ACCOUNT_USAGE, which returns per-table storage broken down by Time Travel and Fail-safe

Answer

Query the DATABASE_STORAGE_USAGE_HISTORY view in SNOWFLAKE.ACCOUNT_USAGE to obtain per-table storage details