Wave 14 · Data, Reporting & FinOps Operations Snowflake / FinOps / warehouse-cost proof Synthetic account, warehouse, and workload exports

Snowflake cost posture, query hotspots, and optimization packets that stay operator-readable.

This control plane turns raw Snowflake usage exports into one FinOps surface: warehouse spikes, idle compute, query hotspots, tag-coverage gaps, storage bloat, telemetry drift, and the remediation packets needed before forecast, chargeback, or optimization windows slip.

Overview Warehouse Lane Query Risks Optimization Posture Verification Docs

Commercial Front Door

Snowflake cost governance and warehouse optimization operations for platform, finance, and analytics teams.
Audit-safe visibility into warehouse spikes, query hotspots, telemetry gaps, and tag hygiene without exposing live credentials.

Proof Layer

Offline analyzer + CLI + dashboard surface.
This repo includes a reusable analyzer that reads warehouse-cost snapshots and drift exports and turns them into severity, owner, and optimization packets.

Why it matters

Recruiters looking for Snowflake / FinOps / data platform should see real warehouse-cost work: compute containment, hotspot tuning, chargeback hygiene, and telemetry continuity.

Query Risks

severity · owner · resource

Risk	Owner	Subject	Family	Message
high warehouse-spike	Data Platform	/accounts/kg-prod/warehouses/transform_xl TRANSFORM_XL	Warehouse	Warehouse spend spike on "/accounts/kg-prod/warehouses/transform_xl" is already pressuring the monthly Snowflake runway by 1,240 credits.
high telemetry-gap	Data Platform	/accounts/kg-prod/usage/telemetry_exports ACCOUNT_USAGE_EXPORT	Telemetry	Telemetry coverage is broken on "/accounts/kg-prod/usage/telemetry_exports", which weakens downstream cost governance and optimization trust.
medium stale-snapshot	Data Platform	/accounts/kg-prod/warehouses/finance_transform	—	Spend snapshot for "Finance mart and replication" is stale and should be refreshed before certifying warehouse-cost posture.
medium idle-compute-surge	Data Platform	/accounts/kg-prod/warehouses/transform_xl TRANSFORM_XL	Warehouse	Idle compute is accumulating on "/accounts/kg-prod/warehouses/transform_xl" and should be rebalanced before warehouse credits leak further.
medium idle-compute-surge	Data Platform	/accounts/kg-prod/warehouses/bi_medium BI_MEDIUM	Warehouse	Idle compute is accumulating on "/accounts/kg-prod/warehouses/bi_medium" and should be rebalanced before warehouse credits leak further.
medium query-cost-hotspot	Analytics Engineering	/accounts/kg-prod/workloads/weekly_exec_rollup weekly_exec_rollup.sql	Queries	Query-cost hotspot is active on "weekly_exec_rollup.sql" within "/accounts/kg-prod/workloads/weekly_exec_rollup" and should be tuned before warehouse efficiency slips.
medium low-tag-coverage	FinOps Operations	/accounts/kg-prod/databases/finance_mart FINANCE_MART	Tagging	Tag coverage drift is active on "/accounts/kg-prod/databases/finance_mart" and unattributed Snowflake spend is reducing chargeback trust.
medium storage-retention-bloat	Data Platform	/accounts/kg-prod/databases/raw_events RAW_EVENTS	Storage	Storage-retention bloat is active on "/accounts/kg-prod/databases/raw_events" and should be reviewed before historical-data credits keep compounding.
low stale-optimization-window	Data Platform	/accounts/kg-prod/warehouses/bi_medium BI_MEDIUM	Warehouse	Drift on "/accounts/kg-prod/warehouses/bi_medium" has remained unresolved for 31 hours.
low stale-optimization-window	Data Platform	/accounts/kg-prod/databases/finance_mart FINANCE_MART	Tagging	Drift on "/accounts/kg-prod/databases/finance_mart" has remained unresolved for 42 hours.
low stale-optimization-window	Data Platform	/accounts/kg-prod/databases/raw_events RAW_EVENTS	Storage	Drift on "/accounts/kg-prod/databases/raw_events" has remained unresolved for 28 hours.
low stale-optimization-window	Data Platform	/accounts/kg-prod/usage/telemetry_exports ACCOUNT_USAGE_EXPORT	Telemetry	Drift on "/accounts/kg-prod/usage/telemetry_exports" has remained unresolved for 36 hours.