Answer: TABLE_STORAGE_METRICS view

The TABLE_STORAGE_METRICS view in the Snowflake ACCOUNT_USAGE schema provides the most granular level of detail for individual table storage information. This view contains comprehensive storage metrics including active bytes, time travel bytes, failsafe bytes, and total table bytes at the individual table level. The community discussion confirms this with 100% consensus on option D, and the referenced Snowflake documentation link validates that TABLE_STORAGE_METRICS is specifically designed for detailed table storage analytics. Other options are less suitable: SHOW TABLES and SHOW EXTERNAL TABLES commands provide basic table metadata but lack detailed storage metrics, while the TABLES view in INFORMATION_SCHEMA contains general table information but not the comprehensive storage details available in TABLE_STORAGE_METRICS.

Author: LeetQuiz Editorial Team