# Reducing Snowflake Spend for an Analytics Platform

> TechSupport Team supported MetricHarbor’s Snowflake and dbt analytics platform. Over six months, the client’s Snowflake bill fell from $52,000 to $36,000 per month. Airflow pipeline failures fell from 38 to 8 per month.

- Publisher: TechSupport Team
- Canonical page: https://techsupport-team.com/case-studies/snowflake-analytics-platform-support/
- Updated: 2026-11-16

Client: MetricHarbor · AI/ML & Data · US analytics platform (100 staff)

## Client and engagement facts

- **Client:** MetricHarbor
- **Industry:** AI/ML & Data
- **Business context:** US analytics platform (100 staff)
- **Delivery model:** Data platform support
- **Application:** Analytics platform on Snowflake
- **Supplied geography:** US
- **Company size in source:** 100 staff

## Application stack and tools

### Application stack

- Snowflake
- dbt
- Airflow
- Python
- AWS

### Tools used

- Snowflake usage records
- Airflow
- Datadog
- dbt

Related services: [Application support](https://techsupport-team.com/services/application-support/)

## Why Support Was Needed

A dbt refactor dropped a filter, causing three dashboards to scan a 40 TB table every 15 minutes. The engineers restored the filter and added cost alerts by dashboard.

## Technical Work

- Rebuilt the affected dbt model with the missing filter.
- Right-sized warehouses based on actual concurrency.
- Added per-dashboard cost alerting so waste becomes visible within hours.

## Representative Incident

A Snowflake price change added cost in month five. The team adjusted warehouse sizing again within two weeks to partially offset it.

## Results and how they were measured

Table: Reported results and their measurement scope

| Metric | Baseline | Result | Units | Measurement window | Source and scope |
| --- | --- | --- | --- | --- | --- |
| Snowflake spend | $52k/mo | $36k/mo |  | 6 months | Client Snowflake |
| Pipeline failures | 38/mo | 8/mo | /mo | 6 months | Client Airflow |
| Dashboard freshness | 6 h | 45 min | Baseline: h; Result: min | 6 months | Client Datadog |

## Evidence and Limitations

The comparison uses six months of client Snowflake, Airflow and Datadog records. Usage was flat at the time of the original cost spike, and the provider changed pricing during the reporting window.

## Cause of Excess Query Cost

A dropped WHERE clause in a dbt refactor caused three dashboards to scan the full table.

## Scope a Similar Engagement

Share one query or dashboard that drives a disproportionate share of your platform cost. [Request a support plan](https://techsupport-team.com/contact/) or explore [application support](https://techsupport-team.com/services/application-support/).

## Related pages

- [Application support](https://techsupport-team.com/services/application-support/): The related service for this engagement.

## Contact

Request engineers from TechSupport Team or ask a question: https://techsupport-team.com/contact/
