The definitive guide to using Snowflake Tasks
A deep dive into all things Snowflake Tasks. Tomas covers setting up Tasks with dependencies, choosing a compute model and operational considerations when managing Tasks.
- Date
Gain visibility into Snowflake usage, optimize performance and automate savings with the click of a button.
SELECT automatically optimizes warehouse utilization and provides unprecedented visibility into account cost drivers, down to the workload level.
SELECT’s automatic cost savings, comprehensive alerting and fast cost exploration experience enables teams to focus on business impact.
Created by Snowflake performance experts, SELECT provides recommendations to optimize query performance without increasing costs.
SELECT is a SaaS application dedicated to helping Snowflake customers automate savings, quickly identify and implement optimization opportunities and control their usage with ease.
Hear firsthand how SELECT helps Snowflake users automatically optimize and better control their Snowflake usage.
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 decrease our annual run rate and 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!
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, our daily credit usage is reduced, allowing us to save our credits for future compute-intensive data projects.
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 60%. The reporting let me find in bottlenecks in minutes that would’ve otherwise taken weeks to dig through metadata and sort out. The automated warehouse savings feature alone is saving us over $10k a month across our accounts.
Before SELECT, we were blind to our Snowflake cost drivers. Minutes after install, we identified a single loader that was driving 50% of our cost. The instant visibility makes a big difference for a lean team like ours.
We love using SELECT to monitor our snowflake costs and usage. The interface drills down by warehouse, by integration, and surfaces cost anomalies at the query level so we can quickly identify and optimize our pipeline. The automated savings are easy to implement and pay for themselves. This product is a perfect compliment to our Snowflake account.
We got up and running with SELECT in about 20 minutes and we're able to drop our usage by 43% in just two days. Our team was able to focus on other valuable business initiatives instead of worrying about costs. Awesome product!
SELECT has streamlined our data warehouse monitoring and reduced costs by 50%. Set up is quick and the reporting provides all the information we need to efficiently focus on where to make improvements, allowing the team to focus on building rather than having to worry about increasing costs. It has saved us a huge amount of time and money overnight!
Setup for SELECT was swift and pain-free. Within 30 minutes we had a full view of our Snowflake usage and cost drivers, including a level of depth on our dbt project spend which we've struggled to get via other means. This helps us stay lean on our costs, without holding back innovation within the team.
Engaging with SELECT was nothing short of transformative for our operations. Their fast and seamless integration effortlessly optimized our Snowflake warehouses, and we instantaneously reaped the benefits with a noticeable 20% reduction in our bill. But, it's not just about cost savings. SELECT's exceptional product stands as an invaluable tool for identifying costly query workloads, and it expertly guides us through efficient remediation processes. It's a must-have investment where the ROI isn't future promise — it's present fact.
Onboarding onto SELECT was quick and the instant insights made our spend management a lot more efficient. We immediately dropped our spend by 17%, allowing the team to focus on more valuable business initiatives. It's an absolute no-brainer to add to a Snowflake stack!
We offer a flat rate pricing tailored to your Snowflake usage, up to a maximum of 3% of your annual Snowflake spend. We always ensure we save you more than we charge, guaranteed. Chat with our team to learn more.
SELECT is a SaaS product that helps Snowflake customers lower their costs, save time, and optimize performance.
Snowflake savings will vary depending on a variety of factors relating to how Snowflake is being used at your company. With that said, SELECT customers typically see a minimum 25% reduction in costs, coming from a combination of automated savings and cost savings recommendations surfaced in the product. Get an accurate estimate for SELECT's automated savings using the Snowflake native app.
Recent posts from our blog.
A deep dive into all things Snowflake Tasks. Tomas covers setting up Tasks with dependencies, choosing a compute model and operational considerations when managing Tasks.
Andrey unpacks Snowflake proprietary storage system and covers key concepts such at table versionining, failsafe, time travel and billing.
Ian and Niall share their learnings and best practices on dbt optimization at dbt's 2023 Coalesce conference in San Diego.
Subscribe to get notified.