How Kargo identified a $500K/year savings opportunity and delivered 5X ROI with SELECT

SELECT provided immediate cost visibility through comprehensive query tagging down to the Airflow task level, enabling precise cost attribution across their consolidated warehouse infrastructure. The platform's intuitive interface eliminated friction from cost analysis, while usage groups enabled aggregate cost monitoring for leadership reporting.

Kargo has been using Snowflake since its inception, making them one of the platform's earliest adopters. Their architecture centers on processing massive volumes of raw JSON logs from microservices that handle their supply-side platform operations. The platform processes auction data and outcome data across web and CTV advertising channels. As a mature Snowflake user, Kargo initially managed costs through warehouse separation - different microservice logs processed in dedicated warehouses to enable cost breakdowns. However, this approach proved inefficient for resource utilization.

When Diana joined three years ago, leadership was concerned about Snowflake costs and worked with Snowflake RSAs to optimize their setup. The recommendation was warehouse consolidation to improve resource utilization. While consolidation improved efficiency by maximizing usage of already-running warehouses, it eliminated the ability to see cost breakdowns. Teams moved from microservice-level visibility to a single lump sum with no granular insights. The Snowflake RSAs provided basic dashboards, but these were inadequate for the level of analysis needed to optimize their complex, high-volume processing pipelines.

SELECT's Automated Savings feature provided instant value, reducing Kargo's Looker warehousing costs by 30% with zero effort required from the team, and giving Kargo an immediate 5X ROI on SELECT. This immediate cost reduction not only paid for SELECT but demonstrated the platform's value in identifying optimization opportunities that weren't visible through traditional monitoring approaches.

The Kargo team implemented comprehensive query tagging across their pipelines, tagging down to individual Airflow tasks to enable precise cost attribution across their consolidated warehouse infrastructure. This granular tagging immediately revealed their most costly processing pipeline: bid request events, which were costing $500,000 annually - far more than anticipated. This insight enabled a strategic architecture decision to move their most expensive workload from Snowflake to Spark processing, fundamentally changing how they approached their most costly operations.

SELECT's usage groups feature solved a critical reporting challenge by enabling cost aggregation across multiple pipelines and warehouses for high-level business reporting. Usage groups allowed the team to group related workloads and provide accurate aggregate costs to leadership, even when those workloads spanned multiple warehouses and processing pipelines. Leadership could now get instant answers to questions like "how much is this whole targeting thing costing?"

SELECT enabled democratization of cost insights across the data engineering team, allowing individual engineers to track the impact of their optimization efforts independently. This self-service capability transformed how the team approached optimization work, making cost impact visible and measurable for individual contributors rather than requiring centralized analysis. As the team undertook systematic refactoring of their data pipelines, SELECT provided crucial before-and-after visibility that enabled them to measure optimization success.