Snowflake audit· Read-only· ACCOUNT_USAGE tables

Snowflake audit,
with receipts.

A ranked, read-only sweep of your own Snowflake account — cost, waste, governance, storage, tasks and Cortex — delivered as findings you can verify line by line.

01What the audit is

A read-only sweep of your own account.

Plain SELECTs against your ACCOUNT_USAGE tables. No vendor installed, no agent running, no live connection to your data — a ranked list of findings across six domains, each one tracing back to a query you can run yourself. The queries are the receipts.

01 — Cost
Where the credits go

Warehouse metering read credit by credit from ACCOUNT_USAGE — attributed by warehouse, role, and query, not guessed at from a monthly total.

CreditsMeteringAttribution
02 — Waste
Idle and oversized

Warehouses sized for a peak that never comes, auto-suspend gaps, and multi-cluster overspill — the credits that buy nothing.

Auto-suspendRight-sizingMulti-cluster
03 — Governance
Grants and blind spots

Role grants, access history, and masking-policy coverage — including the Cortex-AI RBAC gap that hands broad model access to roles that never asked for it.

RBACAccess historyMasking
04 — Storage
What tables weigh

TABLE_STORAGE_METRICS read straight: what each table costs to keep, plus the Time Travel and Fail-safe tails still on the bill.

Storage metricsTime TravelFail-safe
05 — Tasks
Pipelines on the clock

Tasks and streams ranked by real cost: failures, long tails, and the pipelines that quietly doubled without anyone opening the bill.

TasksStreamsTask history
06 — Serving
Cortex and monitors

Cortex function spend and data-metric-function coverage — what the AI features cost, and where the monitoring quietly isn't running.

CortexDMFMonitoring
Contact

Start a conversation.

A paragraph about your platform, one number that looks wrong, or just a hello — send an email. Replies within two working days.

darshansingh@crosshire.ch