Skip to main content

📊 ACCOUNT_USAGE & INFORMATION_SCHEMA

⚠️ Placeholder / draft — content to be expanded.

Purpose: Use Snowflake's built-in metadata views — the SNOWFLAKE.ACCOUNT_USAGE share and per-database INFORMATION_SCHEMA — as the backbone for operational monitoring, auditing, and reporting.


INFORMATION_SCHEMA​

TODO: Per-database scope, real-time metadata, table functions (e.g. QUERY_HISTORY, WAREHOUSE_METERING_HISTORY), retention limits.

ACCOUNT_USAGE Share​

TODO: Account-wide views, latency, 365-day history, granting access to monitoring roles.

Key Views for Admins​

TODO: QUERY_HISTORY, LOGIN_HISTORY, ACCESS_HISTORY, WAREHOUSE_METERING_HISTORY, STORAGE_USAGE, GRANTS_TO_ROLES.

Building Operational Dashboards​

TODO: Common monitoring queries, scheduling with Tasks, surfacing in Snowsight.

Best Practices​

TODO: Dedicated monitoring role, latency awareness, cost of querying.