Question
ACCOUNT_USAGE versus INFORMATION_SCHEMA: what differs, and when should each be used?
Answer
ACCOUNT_USAGE provides account-wide historical metadata and usage records, including dropped objects, with view-dependent latency. INFORMATION_SCHEMA provides current metadata and near-real-time table-function results with shorter retention. Use ACCOUNT_USAGE for audit history; use INFORMATION_SCHEMA for operational checks.