Cost Visibility
A monthly bill with no breakdown is useless for chargeback and useless for catching a runaway pipeline. This page is entirely about closing that gap: which views hold the numbers, which one to reach for depending on how fresh or how far back you need to look, and the query shape that answers "who spent what."
Where the cost data lives
Snowflake ships the audit trail with the product: the SNOWFLAKE database (a share from Snowflake itself) exposes ACCOUNT_USAGE views that break every credit and byte down by source. The ones worth knowing by name:
| View (SNOWFLAKE. | Answers |
|---|---|
| WAREHOUSE_ | Credits per warehouse per hour: the chargeback backbone |
| METERING_ | Daily credits by service type: warehouses vs each serverless feature vs cloud services |
| AUTOMATIC_ | What each clustered table spent on reclustering |
| MATERIALIZED_ | What each MV spent staying fresh |
| SEARCH_ | What SOS maintenance cost per table |
| PIPE_ | Snowpipe credits and bytes per pipe |
| QUERY_ | Which past queries would have benefited from QAS, before you pay for it |
| TABLE_ | Active vs Time Travel vs Fail-safe bytes per table: where storage money hides |
| QUERY_ | 365 days of every statement, with spill, scan, and queue columns for workload forensics |
All of them lag up to a few hours but keep a year of history; the INFORMATION_SCHEMA table functions are the zero-latency, short-retention counterparts for "right now" questions.
Who can actually query these views
By default, nobody but ACCOUNTADMIN. The SNOWFLAKE database is a share, imported from Snowflake itself, and shared databases don't accept ordinary object grants; access is opened one of two ways. The classic grant hands over everything in the database at once. The newer, finer path grants one of the built-in SNOWFLAKE database roles, each scoping a family of views: USAGE_VIEWER for most of the cost and metering views on this page, and its siblings GOVERNANCE_VIEWER (access history, policies, and also QUERY_HISTORY and QUERY_ACCELERATION_ELIGIBLE), SECURITY_VIEWER (grants, login history), and OBJECT_VIEWER (object metadata).
-- Classic: everything in the SNOWFLAKE database, all at onceGRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE finops;-- Finer-grained: just the usage and cost viewsGRANT DATABASE ROLE SNOWFLAKE.USAGE_ VIEWER TO ROLE finops;
One adjacent privilege completes the picture: the account-level MONITOR USAGE privilege lets a role see the Snowsight cost dashboards and run SHOW commands across objects it doesn't own, without granting any table access. A requirement like "a FinOps role must query WAREHOUSE_METERING_HISTORY without ACCOUNTADMIN" calls for IMPORTED PRIVILEGES or USAGE_VIEWER, and "shared databases can't be granted object by object" is why.
SNOWFLAKE.
SNOWFLAKE.
INFORMATION_SCHEMA
TABLE FUNCTIONSOne databasereal time, no lag7 days to 6 months of history, by function
VIEWSWhole account365 days of history45 min to 3 h lag
VIEWSEvery accountin the organization
Two sources, one distinction. The INFORMATION_SCHEMA in each database has table functions like WAREHOUSE_METERING_HISTORY with near real-time data but short retention (7 days to 6 months depending on the function). The SNOWFLAKE.ACCOUNT_USAGE schema has views with 365 days of retention but latency, typically 45 minutes to 3 hours depending on the view. Real-time troubleshooting: INFORMATION_SCHEMA. Historical analysis and chargeback: ACCOUNT_USAGE. Org-wide, across accounts: ORGANIZATION_USAGE, readable via ORGADMIN.
-- Credits by warehouse, last 30 days (ACCOUNT_ USAGE: 365d retention, some latency) SELECT warehouse_name, SUM( credits_ used) AS credits FROM snowflake.account_ usage. warehouse_ metering_ history WHERE start_time >= DATEADD('day', -30, CURRENT_TIMESTAMP( )) GROUP BY 1 ORDER BY 2 DESC;
- Resource monitors watch warehouse credits and can suspend warehouses. Budgets also watch serverless and AI spend; they notify and can run custom actions, but have no built-in suspend.
- INFORMATION_SCHEMA = fresh but short-lived. ACCOUNT_USAGE = 365 days but latent. ORGANIZATION_USAGE = all accounts in the org.

