Snowflake is the leading cloud data warehouse.  Due to it's modern architecture, it provides incredible power and simplicity together with a massively reduced total cost of ownership.  

Snowflake Architecture
The Snowflake architecture is an evolution over traditional data warehouses, modernised to take advantage of the cloud. Many of the benefits of Snowflake such as the performance, cost profile and security are as a direct result of these architectural properties. OverviewThe Snowflake Architectur…
The Difference Between Snowflake Stage Types
When we load data into Snowflake, we will typically follow a two step process: Upload the data from your source to some staging area. Perform the COPY INTO operation to take data from that staging area and copy it into the Snowflake table in a relational format.With regards to
Best Practices For Staging Data Into Snowflake
Much of the work of a Snowflake data engineer is in loading and transforming their data into Snowflake tables. Though this is easy to achieve, there are a number of best practices that will help to keep the process organised, scalable and performing well: Use The Correct Staging Area Type
Why Doesn’t Snowflake Enforce Referential Integrity
Many relational databases support the capability of referential integrity. This is where the database helps to ensure that primary/foreign key references within data remain valid in order to keep the dataset making logical sense. For example, say we have an Orders table that contains a Customer I…
Building A DBT Model In Snowflake
We have written about DBT extensively on the site, explaining how it helps to implement a repeatable developer lifecycle around database transformations executed within a data warehouse. DBT and Snowflake are very complementary, and are frequently deployed together as part of modern cloud based da…
Understanding The Load And Performance Of Your Snowflake Warehouse
Due to its focus on simplicity and the SaaS delivery model, Snowflake has relatively few options for understanding and then optimising performance. Though Snowflake generally performs extremely well, DBAs from a more traditional background can feel as though they are flying blind, and want to see…