📊 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.