
Explanation:
The correct answer is B (TABLE_STORAGE_METRICS) because this Snowflake metadata view specifically displays table-level storage utilization information that includes data for dropped tables that are still incurring storage costs. According to the Snowflake documentation and the community discussion consensus (with 100% agreement and multiple upvoted comments), TABLE_STORAGE_METRICS is designed to show storage billing information for all tables in the account, including those that have been dropped but still have storage costs. The other options are incorrect: DATABASE_STORAGE_USAGE_HISTORY shows database-level usage, STORAGE_DAILY_HISTORY shows daily storage metrics, and STAGE_STORAGE_USAGE_HISTORY shows stage storage usage - none of these specifically include dropped table data in the same way TABLE_STORAGE_METRICS does.
Which Snowflake metadata view contains storage utilization information, including data for dropped tables?
A
DATABASE_STORAGE_USAGE_HISTORY
B
TABLE_STORAGE_METRICS
C
STORAGE_DAILY_HISTORY
D
STAGE_STORAGE_USAGE_HISTORY
No comments yet.