Snowflake’s virtual warehouses are the compute engine that powers every query, transformation, and ETL job. For years, we’ve run on what are now called Generation-1 Warehouses. With the release of Snowflake Gen 2 Warehouses, the natural question is: ...
This article explains how the Snowflake cache works using an innovative three-layer hardware architecture. Unlike most other database platforms, which allow the DBA to tune the cache sizes, the process is entirely automatic on Snowflake, raising the ...
Snowflake Dynamic Tables share functionality similar to Snowflake Streams and Materialized Views, yet they have distinct differences and advantages over the alternative solutions. This article will describe Dynamic Tables, their target use cases, and...
Snowflake offers advanced features that empower organizations to handle terabytes of data more efficiently and effectively. Query Acceleration Service, Cluster keys and Search Optimization Service stand out for their ability to significantly improve...
Having worked with over 50 Snowflake customers across Europe and the Middle East, I've analyzed hundreds of Query Profiles and identified many issues including issues around performance and cost. In this article, I'll explain: What is the Snowflake ...
This article will demonstrate how a simple Snowflake virtual warehouse change can lead to queries running over a hundred times faster and 40% cheaper. Plot spoiler - it involves spilling to storage. We will explain what causes spilling to storage, a...
