How Personio drove cost awareness while scaling Snowflake across 280+ users
- 60%
- reduction in dbt pipeline execution times
- 280+
- direct Snowflake users supported
Exiger's Snowflake costs ballooned by over 200% year over year, raising questions around the company around whether it could be sustainably managed. As Snowflake's rudimentary monitoring provided no granularity into cost drivers or actionable optimization insights, the Exiger team looked to SELECT to help drive immediate results.
SELECT provided the Exiger team with immediate cost insights and 1-click Automated Savings that allowed them to instantly reduce costs by 40%. Setup took less than an hour. Following the initial cost reduction, Exiger has continued to benefit from SELECT's monitoring and visibility to enable immediate identification of waste and prevent future cost overruns.
Through SELECT's automated savings feature and deep cost visibility, we were able to instantly lower our Snowflake spend by over 40% and achieve a 20X ROI on our SELECT investment.
Skyler Chi, SVP, GTM Productivity & Excellence at Exiger
Five years ago, Exiger operated fragmented data infrastructure across many different database systems. The company adopted Snowflake to create unified data access for product teams, analysts, and data scientists analyzing petabytes of risk management data. Today, Snowflake at Exiger serves 15,000 external users through embedded BI tools while 200 internal analysts constantly iterate on datasets. However, rapid democratization created problems. Users spun up 4XL warehouses for impatient queries, built inefficient SQL without optimization, and scheduled processes without understanding cost implications.
After ramping up adoption of Snowflake, costs exploded by 200% in a single year, which began to raise questions around the organization. The degree of growth was unsustainable. All of leadership was asking why Snowflake costs were growing out of proportion with revenue growth. Before SELECT, Exiger relied on Snowflake's native monitoring which provided no actionable insights or the necessary visibility to drive change.
Exiger needed to rapidly identify why costs were ballooning. SELECT immediately provided granular insights, leading to instant cost wins. Setup took just 20 minutes for the first Snowflake instance and five minutes for each subsequent instance. Through SELECT's Automated Savings feature and deep cost visibility, Exiger was able to immediately lower costs by 40%. SELECT helped identify orphaned projects across 200 analysts - for example, processes running on oversized warehouses with cron jobs against stale data that nobody used anymore.
After eliminating initial waste, Exiger shifted strategy to ongoing monitoring with SELECT's automated cost anomaly alerts. This proactive approach prevents future waste rather than cleaning up after the fact. With Snowflake, you get a warning that your top level budget is off, but no additional granular details as to why. With SELECT, you receive a notification telling you what service spiked, from what workload, when and why, along with all the additional telemetry you need to investigate.
Since adopting SELECT, it has become incorporated into Exiger's engineering workflows. When developing new workloads or experimenting with warehouse configurations, developers can easily monitor costs and performance to make data-driven decisions with confidence. SELECT gave Exiger a very easy way to change culture around spend, and also give senior executives comfort that they had general control over the tools they've entrusted teams with. It's really hard to change culture and to change a 200 person organization's way of thinking, but providing them with airbags and safety nets from SELECT has given them the ability to do exactly that.
Explore how SELECT helps teams reduce warehouse waste, improve visibility, and act on data cost insights.
“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.”

“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!”

“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.”

“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.”

“This is the easiest thing we've ever done to save money - 20x ROI. Does this not exist for AWS?”

“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.”

“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.”

“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.”
