Tomáš provides a detailed overview of stored procedures, including a wide variety of examples and best practices.

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.

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

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.

Tomas shares a deep dive into using Snowpipe for continuous data loading in Snowflake, including a discussion on pricing and best practices.

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?

A deep dive into how to effectively work with JSON data, and the different functions Snowflake offers.

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

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.

An overview of the 5 different bulk data loading options in Snowflake and how to choose between them.