The correct answer is D. ACCOUNT_USAGE.TABLE_STORAGE_METRICS .
ACCOUNT_USAGE.TABLE_STORAGE_METRICS provides detailed storage metrics for tables, including active bytes, Time Travel bytes, Fail-safe bytes, and retained-for-clone bytes. This view is more detailed for table-level storage than SHOW TABLES or DESC TABLE.
Why D is correct:
TABLE_STORAGE_METRICS is designed specifically to report table-level storage usage.
Why the other options are incorrect:
A. SHOW TABLES provides table metadata, but not the most detailed storage breakdown.
B. DESC TABLE describes the table structure, such as columns and data types, not detailed storage consumption.
C. ACCOUNT_USAGE.STORAGE_USAGE provides account-level storage usage, not the most detailed table-level storage metrics.
Official Snowflake documentation reference:
Snowflake documentation describes ACCOUNT_USAGE.TABLE_STORAGE_METRICS as a view that provides storage information for tables, including active, Time Travel, Fail-safe, and retained-for-clone storage.
[Reference: Snowflake Documentation — ACCOUNT_USAGE.TABLE_STORAGE_METRICS; Snowflake Documentation — Storage usage; SnowPro Core Study Guide — Snowflake Account and Resource Management., ========================]
