SELECT
All Resources
Explore every published landing page, blog post, webinar, announcement, and demo page available for this product.
Published Resources
60
Resource Types
4
Collection
Microsites
3 published resources
The Unofficial Guide to AI Cost Optimization on Snowflake
Download the guide to Snowflake AI cost patterns. Learn how Cortex, Document AI, and ML features create hidden costs, based on 250+ production environments.
Snowflake Cost Optimization: 15 proven strategies for reducing costs
Download the complete guide to reducing Snowflake costs through platform configuration. 15 proven techniques that cut costs by 45% without code changes.
Stop Snowflake Cost Surprises with Query-Level Visibility
Download the complete guide to the 5 query patterns that spike Snowflake costs by 10x. Learn query-level monitoring to prevent budget overruns.
Collection
Blog Posts
Read product stories, practical guidance, and editorial content.
55 published resources
5 Snowflake Query Patterns That Silently Drain Your Budget
Discover the 5 costly Snowflake query patterns causing budget surprises. Learn how query-level monitoring prevents expensive patterns before they hit production.
SELECT is joining DoiT to scale our mission of eliminating data platform waste
We're incredibly excited to share that we are officially joining the DoiT team to scale our mission of eliminating data platform waste. Learn more about the why behind the acquisition and what this means going forward.
Snowflake BUILD 2025 Recap
Jeff walks us through all the major announcements from Snowflake BUILD 2025 - a virtual conference geared towards builders.
A Beginner's Guide to Snowpark Container Services: Understanding the Building Blocks and Pricing
Jeff explains the concepts of Compute Pools, Services, And Image Repositories which are the building blocks of Snowpark Container Services
Snowflake Cloud Services: Pricing and Monitoring
Jeff walks through how the Cloud Services layer in Snowflake is billed and how you can keep an eye on the spend.
Snowflake Data Transfer Pricing and Egress Cost Optimizer
In this article, Jeff explains what you're actually paying for with Snowflake data transfer costs, which operations incur egress fees, and practical strategies to optimize your spend across regions and cloud platforms. We'll look at how Egress Cost Optimizer works in Snowflake.
Monitoring Snowflake AI Costs: The Complete Series
Jeff walks us through every Snowflake Cortex AI service, how to use it, how it is billed, how to monitor costs, and best practices.
Snowflake Document AI: Overview, Pricing & Cost Monitoring
In this article we'll take a deep dive into how Snowflake Document AI works, how it is priced, how to monitor the costs, as well as best practices when using this feature.
Snowflake Cortex Search: Overview, Pricing & Cost Monitoring
In this article we'll take a deep dive into how Cortex Search works, how it is priced, how to monitor the costs, as well as best practices when using this feature.
Snowflake Cortex AI SQL: Overview, Pricing & Cost Monitoring
In this article we'll take a deep dive into how Cortex AISQL works, how it is priced, how to monitor the costs, as well as best practices when using this feature.
Snowflake Cortex Analyst: Overview, Pricing & Cost Monitoring
In this article we'll take a deep dive into how Cortex Analyst works, how it is priced, how to monitor the costs, as well as best practices when using this feature.
Snowflake Intelligence: Overview, Pricing & Cost Monitoring
Snowflake Intelligence is a new app for non-technical business users to chat with data. In this article we'll take a deep dive into how Snowflake Intelligence works, how it is priced, how to monitor the costs, as well as best practices when using this feature.
What's New in Snowflake: Summer 2025
Jeff walks us through all new features in Snowflake released in July and August 2025.
What's New in Snowflake: June 2025
Jeff walks us through the most important changes in Snowflake in June 2025.
Snowflake Summit 2025: Product Announcement Recap
Discover the biggest announcements from Snowflake Summit 2025, including innovations in platform economics, data governance, AI agents, and more - shaping the future of data and AI for modern businesses.
What's New In Snowflake: March 2025 Product Updates
In this post, Jeff covers the key features released by Snowflake in March 2025, including automatic sensitive data classification, schema-level replication for failover groups, asynchronous child jobs, and expanded support for dynamic tables.
Best Practices for dbt Workflows, Part 3: Slim Scheduled Builds
Alex gives the best practice for dbt workflows in Snowflake in a 3-part series, explaining how to effectively use slim scheduled builds.
Best Practices for dbt Workflows, Part 2: Slim CI/CD Builds
Alex gives the best practice for dbt workflows in Snowflake in a 3-part series, describing some techniques for achieving slim builds in CI/CD pipelines.
Best Practices for dbt Workflows, Part 1: Concepts & Slim Local Builds
Alex gives the best practice for dbt workflows in Snowflake in a 3-part series, outlining key concepts and slim local builds.
Sending Alerts to MS Teams from Snowflake
Jeff provides a detailed walkthrough of how to send alerts to Teams from Snowflake
Sending Alerts to Slack from Snowflake
Jeff provides a detailed walkthrough of how to send alerts to Slack from Snowflake!
Snowflake Pricing Explained | 2025 Billing Model Guide
In this post, Ian & Niall do a deep dive into Snowflake's pricing model and explain the billing for each service.
Snowflake Cost Management: Insights from 100+ Customers
Ian shares a framework for Snowflake Cost Management based on the learnings from working with over 100 Snowflake customers.
Up & Running With the Snowflake Connector for Python
Get up & running in <5 minutes with the Snowflake Connector for Python. Ian covers how the core concepts for working with the Python package then dives into a number of practical, real-world examples.
Snowflake Access History: 8 ways to audit your account
Learn how you can leverage Snowflake's Access History dataset to audit and understand Snowflake usage.
Calculating cost per query in Snowflake
Understanding the cost of each query in your Snowflake virtual warehouses is critical for cost management. This post provides a detailed overview and working code to help you calculate cost per query.
Using the Snowflake Query History: 9 Practical Examples
In this post, Ian explains how to leverage the Snowflake Query History dataset with 9 practical examples.
Databricks vs. Snowflake: An Honest Comparison in 2024
Jeff from Sync Computing and Ian from SELECT sit down for an hour to discuss Snowflake and Databricks.
Snowflake 101: Working with Stored Procedures
Tomáš provides a detailed overview of stored procedures, including a wide variety of examples and best practices.
Snowflake Roles 101: Comprehensive Guide to Access Control
Jovan Saković of Tasman Analytics provides an overview of key concepts in Snowflake access control and explains the different types of roles. Whether you're a Snowflake administrator or data engineer looking to better understand access control, this post is for you.
Snowflake Query Optimization: 16 tips to make your queries run faster
In this guide, we share 16 proven optimization techniques to maximize the performance and efficiency of Snowflake. Follow these best practices to make queries run faster while reducing costs.
Snowflake Cost Optimization: 15 proven strategies for reducing costs
Snowflake is an incredibly powerful platform, easily scaling to handle ever-larger data volumes without compromising on performance. But, if not controlled, costs associated with this scaling quickly climb. Whether your goal is to reduce the price of an upcoming renewal, extend your existing contract's runway, or reduce on-demand costs, use the strategies in this post to make significant savings.
Snowflake Snowpipe: The Definitive Guide (2024)
Tomas shares a deep dive into using Snowpipe for continuous data loading in Snowflake, including a discussion on pricing and best practices.
Snowflake JSON Data Parsing Guide | 2024
A deep dive into how to effectively work with JSON data, and the different functions Snowflake offers.
Snowflake 101: Working with Semi-Structured Data
In this post, Tomas explains how to work with semi-structured data in Snowflake. First, we cover the different types of semi-structured data. Then, we cover how to load it into Snowflake and all the different ways to create your tables.
Snowflake Batch Data Loading | Best Practices in 2024
In this post, we cover the most important techniques and best practices for efficiently loading data into Snowflake, with an emphasis on optimizing for cost efficiency and performance.
Data Loading in Snowflake: A Comparison of 5 Different Options
An overview of the 5 different bulk data loading options in Snowflake and how to choose between them.
Alerts & Notifications in Snowflake (Updated for 2024)
In this post Tomáš of Tietoevry does a deep dive into Snowflake native alerting and notification features.
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.
A deep dive into Snowflake storage costs
Andrey unpacks Snowflake proprietary storage system and covers key concepts such at table versioning, failsafe, time travel and billing.
Error Notifications for Snowflake Tasks
In this post Tomáš of Tietoevry does a deep dive into how to set up Slack error noticications for Snowflake Tasks using Amazon SNS.
Effectively using the MERGE command in Snowflake
In this post Andrey of Deliveroo does a deep dive into the Merge statement in Snowflake, how to effectively use it, and how it compares to other alternatives.
Identifying unused tables in Snowflake
Removing unused tables in your Snowflake account can reduce spend, increase security and improve overall warehouse usability. In this post, we show how to identify tables that have not been accessed recently.
How to use Query Timeouts in Snowflake
Query timeouts are an important tool for Snowflake users looking to control costs and prevent accidental cost spikes. In this post we’ll cover why they’re useful and how they can be configured.
Controlling Costs with Snowflake Resource Monitors
A comprehensive guide to resource monitors and alerting to control spend in Snowflake.
Should you use CTEs in Snowflake?
CTEs are an extremely valuable tool for modularizing and reusing SQL logic. They're also a frequent focus of optimization discussions, as their usage has been associated with unexpected and sometimes inefficient query execution. In this post, we dig into the impact of CTEs on query plans, understand when they are safe to use, and when they may be best avoided.
Snowflake query tags for enhanced monitoring
Snowflake query tags allow users to associate arbitrary metadata with each query. In this post, we show how you can use query tags to achieve better visibility & monitoring for your Snowflake query costs and performance.
3 ways to configure Snowflake warehouse sizes in dbt
The ability to use different warehouse sizes for different workloads in Snowflake provides enormous value for performance and cost optimization. dbt natively integrates with Snowflake to allow specific warehouses to be chosen down to the model level. In this post, we explain exactly how to use this feature and share some best practices.
How to speed up range joins in Snowflake by 300x
A deep dive into how you can optimize queries involving a range join for up to a 300x performance improvement.
Exclude and rename columns when using SELECT * in Snowflake
An overview of Snowflake's new SQL syntax which allows users to exclude and rename specific columns when running a SELECT * style query.
How to use the Snowflake Query Profile
The Snowflake Query Profile is the single best resource you have to understand how Snowflake is executing your query and learn how to improve it. In this post we cover important topics like how to interpret the Query Profile and the things you should look for when diagnosing poor query performance.
Choosing the right warehouse size in Snowflake
Snowflake users enjoy a lot of flexibility when it comes to compute configuration. In this post we cover the implications of virtual warehouse sizing on query speeds, and share some techniques to determine the right one.
3 Ways to Achieve Effective Clustering in Snowflake
Pairing query design with effective clustering can dramatically improve pruning and query speeds. We'll explore how and when you should leverage this powerful Snowflake feature, and the three ways you can effectively cluster your tables.
Micro-Partitions: Understanding Snowflake's File Structure
Independently scalable compute and storage is an architecture fundamental of Snowflake. In this post, we’ll be focusing on how Snowflake stores data, and how it can greatly accelerate query performance.
Snowflake Architecture Explained: 3 Crucial Layers
An overview of Snowflake's unique elastic data warehouse architecture and its three subcomponents cloud: cloud services, compute and storage
Collection
Webinars
Explore live and on-demand sessions for deeper product context.
1 published resource
Collection
Demo Pages
Find guided demos and solution-specific walkthroughs.
1 published resource