Loop optimizes Snowflake costs across thousands of embedded analytics users
- 20%
- immediate cost reduction
- $20K
- cost increase prevented
The Challenge
Personio was scaling rapidly on Snowflake with 280+ direct users across analytics, machine learning, and customer-facing applications. They relied on manual queries against Snowflake metadata and Google Sheets to understand costs, with different teams running inconsistent analyses. As their consumption grew, they needed structured cost management to avoid budget overruns.
The Solution
SELECT provided immediate visibility into cost allocation across Personio's multiple analytics verticals through usage groups and dbt integration. The platform's intuitive interface required no formal training, allowing teams to quickly adopt cost-conscious workflows. Automated Slack alerts and saved views streamlined ongoing cost monitoring, while the Insights feature regularly surfaces quick-win savings opportunities.
Results
- Reduced dbt pipeline execution times by 60% through warehouse sizing insights
- Enabled flexible cost allocation across business verticals for accurate showbacks
- Automated Slack alerting increased cost awareness throughout engineering teams
- Eliminated manual cost reporting workflows and inconsistent analysis across teams
SELECT has made important cost data readily accessible. I will often pull it up during engineering design reviews so we can quickly evaluate cost impact and projections and factor that into our design decisions.
Douglas Zickuhr, Senior Data Platform Engineer at Personio
Scaling Snowflake without cost visibility
Personio operates a modern data stack with Snowflake as their core warehouse, supporting both internal analytics and customer-facing features. With 280+ direct Snowflake users across analytics engineering, data science, and machine learning teams, the platform powers everything from HR dashboards to AI-driven insights. Before SELECT, cost management was fragmented and manual. Teams ran different queries against Snowflake metadata, analyzed results in Google Sheets, and struggled to connect the dots between workloads and spending.
Getting ahead of growth with SELECT
As Snowflake consumption accelerated, Douglas recognized the need for proactive cost management. The company was preparing for scale and needed visibility before costs became a business concern. SELECT's adoption was seamless, requiring no formal training sessions. The platform's intuitive design allowed teams to immediately start using cost visibility features.
Driving a culture of cost awareness
SELECT transformed how Personio approaches Snowflake cost management. Usage groups enabled precise cost allocation across analytics verticals supporting different departments - engineering, customer experience, and sales. The platform's automated Slack alerts created a culture of cost consciousness. Teams began proactively discussing optimization opportunities when alerts highlighted expensive workloads. Since adopting SELECT, cost has come to the forefront of engineering discussions.
Optimizing data pipeline execution times
One significant win came through SELECT's dbt integration and DAG visualization. The team identified bottlenecks in their morning data pipeline and optimized warehouse sizing to reduce execution time by 60%. By regularly reviewing SELECT every week, the analytics engineering team has been able to quickly review their new data models and carefully evaluate the ROI of their data products.
Looking ahead with SELECT
As Personio continues expanding their AI platform and exploring Snowflake Cortex, SELECT remains central to their cost optimization strategy to ensure positive ROI and proactive monitoring on their AI investments. With tight morning data windows and growing ML workloads, SELECT helps ensure optimal performance while maintaining cost efficiency as the platform scales.
See how SELECT helps data teams move faster
Explore how SELECT helps teams reduce warehouse waste, improve visibility, and act on data cost insights.
More customer stories
How Kargo identified a $500K/year savings opportunity and delivered 5X ROI with SELECT
- 5X
- ROI
- 30%
- Looker warehousing cost reduction
- $500K/year
- Single event processing cost identified
HomeChef tamed Snowflake costs while raising cost awareness across their analytics team
- 60%
- cost savings
- 15X
- cost spike before SELECT
- 30 minutes
- setup time
How Entain achieved 35% Snowflake savings by empowering teams with better cost management tooling
- 35%
- Snowflake cost reduction
- 50%
- data pipeline cost reduction
- $200K
- annual ingestion savings
ClickUp adopted proactive FinOps strategy for Snowflake before costs ballooned
How Exiger dropped their Snowflake costs by 40% in two weeks
- 40%
- cost reduction
- 20x
- ROI
- $700K
- prevented cost increases
How a fast-growing AI startup tamed spiralling Snowflake costs by 60%
- 60%
- cost reduction
- 10X
- cost growth over 2 years
Loop optimizes Snowflake costs across thousands of embedded analytics users
- 20%
- immediate cost reduction
- $20K
- cost increase prevented
How Kargo identified a $500K/year savings opportunity and delivered 5X ROI with SELECT
- 5X
- ROI
- 30%
- Looker warehousing cost reduction
- $500K/year
- Single event processing cost identified
HomeChef tamed Snowflake costs while raising cost awareness across their analytics team
- 60%
- cost savings
- 15X
- cost spike before SELECT
- 30 minutes
- setup time
How Entain achieved 35% Snowflake savings by empowering teams with better cost management tooling
- 35%
- Snowflake cost reduction
- 50%
- data pipeline cost reduction
- $200K
- annual ingestion savings
ClickUp adopted proactive FinOps strategy for Snowflake before costs ballooned
How Exiger dropped their Snowflake costs by 40% in two weeks
- 40%
- cost reduction
- 20x
- ROI
- $700K
- prevented cost increases
How a fast-growing AI startup tamed spiralling Snowflake costs by 60%
- 60%
- cost reduction
- 10X
- cost growth over 2 years
Customer Love.Supercharging thousands of data cloud users.
Read more customer love“SELECT is a team favorite - its cost monitoring and auto savings give us peace of mind that our Snowflake spend is in check. The platform’s detailed insights across SQL queries, dbt, and Looker usage provides a comprehensive view into credit spend that is unmatched by other solutions. SELECT has helped us significantly optimize how we use Snowflake.”
Dan CorcoranSenior Data Engineering Manager at Gopuff
“SELECT's app has become an invaluable resource to our company. It clearly breaks down our costs to allow us to focus on the most important areas of cost. SELECT has repeatedly surfaced inefficient common query patterns, and has helped us spot 200 TiB of unused tables to drop, resulting in continued significant cost savings. SELECT is always adding new features to help their customers better understand and reduce their spending. We can't recommend them highly enough!”
Sean AbrahamSenior Principal Software Engineer at VideoAmp
“I love clicking through SELECT to understand how our environment and workloads are evolving. I probably check it every day. It's coffee and SELECT for me every morning.”
Ian FaheySenior Analytics Engineer at Loop
“SELECT helps us quickly identify inefficient queries that consume unnecessary Snowflake credits, providing all the information we need in a single application. With the Automated Savings feature, we were able to allocate credits to new compute-intensive data projects.”
Jessica FranksData Engineering Manager at NOTHS
“This is the easiest thing we've ever done to save money - 20x ROI. Does this not exist for AWS?”
Skyler ChiSVP, GTM Productivity & Excellence at Exiger
“SELECT provides our team with complete visibility into all aspects of our Snowflake bill and usage. Our team regularly uses SELECT to monitor costs and get alerted on key changes. The dbt & Looker integrations are also super helpful for identifying performance bottlenecks.”
Jonathan TalmiSenior Data Engineering Manager at Super
“SELECT helped us monitor and reduce our overall Snowflake spend by almost 40%. The reporting showed me bottlenecks in minutes that would’ve otherwise taken weeks to dig through metadata and sort out. The 'Automated Savings' savings feature alone is saving us over $10k a month across our accounts, allowing us to bring on new workloads.”
Garrett McClintockAnalytics Engineering Manager at Heap
“Before SELECT, we were blind to our Snowflake cost drivers. Minutes after install, we identified a single job that was driving over 20% of our costs. The instant visibility & not having to build & maintain our own monitoring makes a big difference for a lean team like ours.”
Erik WebbHead of Data at Clair
