SELECT
SELECT Blog
Perspectives, product guidance, and practical stories for teams working with SELECT.
Latest
All Posts
55 published posts
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.