SELECT
All Resources
Explore every published landing page, blog post, webinar, announcement, and demo page available for this product.
Published Resources
91
Resource Types
4
Collection
Microsites
4 published resources
The Guide to Databricks Cost Optimization
Five proven strategies to reduce Databricks costs without slowing your team down. Learn how to stop idle resource waste, choose the right compute type, and build governance that sticks. Free guide by a Principal Data Engineer.
The Unofficial Snowflake AI Optimization Guide
Download the guide to Snowflake AI cost patterns. Learn how AI Functions, Cortex Analyst, Cortex Search, and Snowflake Intelligence create costs most teams don't see coming, based on data from 100+ accounts.
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.
85 published resources
SELECT Announces Automated BigQuery Cost Optimization Early Access Program
SELECT by DoiT automates BigQuery cost optimization — storage, slot reservations, and query routing — built on $250M+ in proven data platform spend.
Snowflake vs Databricks Showdown
Snowflake vs. Databricks: See real benchmark results across 5 workload types — sequential queries, concurrency, cold starts, CTAS, and DML. Find out which platform is faster, cheaper, and right for your data team.
5 Snowflake Query Patterns That Silently Drain Your Budget
Five common Snowflake query patterns silently inflate compute bills by hundreds or thousands of dollars. Learn to spot and stop them before they drain your budget.
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.
SELECT Product Updates - October 9, 2025
See what's new in SELECT over the last 4 weeks.
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 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 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 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.
August 2025 Product Release: New Monitors Experience and more!
What's new in SELECT in August 2025.
July 2025 Product Release: Advanced Filters, Configurable Table Grain, Terraform Provider, and More!
Let's review the new features released in SELECT in July 2025
What's New in Snowflake: June 2025
Jeff walks us through the most important changes in Snowflake in June 2025.
CI/CD and DevOps in Snowflake (Part 2): Step-by-Step Implementation Guide
Tomáš provides a step by step guide to use GitHub Actions to create a CI/CD pipeline that deploys infrastructure in Snowflake.
June 2025 Product Release: Views, Favourites, Lineage Improvements, and More!
Let's review the new features released in SELECT in June 2025.
Unlocking Data Governance with Snowflake Object Tagging
Jeff walks us through why object tags are a critical governance feature in Snowflake. He gives examples of how to use them and a more complex example on how to automate object tags.
CI/CD and DevOps in Snowflake (Part 1): A Comprehensive Overview of Features and Tools
Tomas gives an overview of DevOps in Snowflake, highlighting the platform's native features like CREATE OR ALTER, Git integration, and the Snowflake CLI. He also compares third-party tools such as Terraform, Permifrost, Titan, and Schema Change to help teams choose the right infrastructure-as-code approach.
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.
Snowflake Generation 2 (Gen2) Warehouses: Are the Speed Gains Worth the Cost?
Snowflake's new Gen2 warehouses are much faster and cost 25% to 35% more. In this post, we help you understand the break even analysis and suggest specific workloads that show a large cost savings.
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.
A deep dive into Snowflake's Git Integration
Tomas walks through Snowflake's native Git integration feature, and how to synchronize a remote repository with your Snowflake account
Everything You Need to Know About Snowflake Dynamic Tables
Jeff does a deep dive into how to make use of dynamic tables in Snowflake, covering key gotchas and best practices.
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!
Secrets Management in Snowflake: A Step-by-Step Guide
Jeff dives into Snowflake's new Secrets functionality and how they can be used for securely storing API keys and more!
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.
Effective Filtering of Window Functions With Snowflake QUALIFY
Jeff discusses how to use one of Snowflake's top SQL features, QUALIFY, to effectively filter window function results.
Using Streams in Snowflake for Change Data Capture
In this deep dive, Jeff covers everything you need to know about using Snowflake Streams for tracking change data capture in your Snowflake tables.
Unpacking Snowflake's New User Type Property
Jeff Skoldberg of Green Mountain Data Solutions unpacks Snowflake's user type property.
Our Top 7 Snowflake RBAC Best Practices
Miguel Duarte of Tasman Analytics their top 7 best practices for Snowflake RBAC, based on their experience of designing access control systems for over 20 Snowflake clients.
Snowflake Summit 2024: All 28 announcements and my takeaways
Ian recaps all 28 announcements and updates from Snowflake Summit 2024, sharing his opinions on their significance and impact for Snowflake customers and partners.
Event Tables for Structured Logging & Tracing in Snowflake
Tomas shows how you can take advantage of Snowflake's event tables feature for structured logging and tracing when building applications in Snowflake.
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.
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.
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.
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 Logo, Brand Guidelines & Icons (2024)
A quick guide on how to download the official Snowflake logo.
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 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 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 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.
Terraform for Streamlined Snowflake Management (2024)
Gary James shares practical lessons and guidance on when and how to use Terraform for managing Snowflake infrastructure based on many years of experience. He includes practical examples, cases where you shouldn't use Terraform, and other important considerations.
dbt Threads: The easiest way to speed up your dbt project in Snowflake
In this post, Ian & Niall answer a frequent question posed by dbt users to optimize dbt performance and cost efficiency: how many dbt threads should be used?
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.
SELECT Achieves SOC 2 Type 2 Certification: A Milestone in Our Commitment to Security
SELECT is proud to announce our achievement of SOC 2 Type II Certification, affirming our commitment to the highest standards of security and privacy for our clients and partners.
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.
Proven methods for optimizing your dbt project - dbt Coalesce 2023
Ian and Niall share their learnings and best practices on dbt optimization at dbt's 2023 Coalesce conference in San Diego.
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.
Analyzing your DAG to identify unused dbt models in Snowflake
In this post, Jay does a deep dive into how you can identify unused dbt models in Snowflake by analyzing your DAG and the historical access patterns.
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.
Every Major Announcement at Snowflake Summit 2023 and 1 Word Never Mentioned
In this post we provide a deep dive into all Snowflake Summit 2023 announcements, why they matter and which ones we're most excited about.
Insights from Niall on dbt Labs' Analytics Engineering Podcast
In the podcast, Niall shares practical insights and actionable steps that organizations can take to effectively manage and reduce their Snowflake costs.
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.
Monitoring dbt model spend and performance with metadata
In this post, we show how you can use query tags or comments to achieve better visibility & monitoring for your Snowflake dbt model costs and performance.
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.
Defining multiple cluster keys in Snowflake with materialized views
How to effectively utilize Snowflake’s materialized views to allow your table to have multiple, separate cluster keys.
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.
60x faster database clones in Snowflake
Snowflake's zero-copy cloning feature is extremely powerful for quickly creating production replica environments. But, anyone who has cloned a database or schema with a large number of tables has experienced that it can take over ten minutes to complete. In this post we explore a potential solution.
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