Snowflake DBA

Monitoring, Auditing & Alerting

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.

This is 12 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples