Snowflake

Snowflake is an important tool for many data scientists. A versatile data warehouse which integrates with many other tools. These posts describe the ways a data scientist can get the most out of Snowflake, especially when working within Python and notebooks.

CREATE TABLE AS SELECT in Snowflake

CREATE TABLE AS SELECT in Snowflake Members Public

You can create a table in Snowflake manually with a table definition, or you can do so directly from a select query, which can save you a lot of time. In this post I will explain how you can do this, and cover common questions that users have.

Stephen Allwright
Stephen Allwright
Snowflake
View vs table in SQL, what are the differences?

View vs table in SQL, what are the differences? Members Public

Views and tables are common ways of organising data in a SQL database, but when should you use one or the other? In this post I explain what they are, their differences, and help you decide which is best to use for your use case.

Stephen Allwright
Stephen Allwright
Snowflake
Materialized view vs table, what are the differences?

Materialized view vs table in SQL, what are the differences? Members Public

Materialized views and tables are used for organising and storing data in a SQL database. But what are the differences between them, and in which use cases should you use one over the other?

Stephen Allwright
Stephen Allwright
Snowflake
View vs materialized view, what are the differences?

View vs materialized view, what are the differences? Members Public

Views and materialized views are methods for creating a virtual table in SQL. But, which one should you use? In this post I will look at what they are, their similarities and differences, and help you decide which is best.

Stephen Allwright
Stephen Allwright
Snowflake
Snowflake create view

Snowflake CREATE VIEW, what you need to know Members Public

A view is a SQL query that is stored for repeat usage, and is simple to implement in Snowflake. In this post I will walk through the code required to create a view, the benefits, and common errors that users experience.

Stephen Allwright
Stephen Allwright
Snowflake
Snowflake materialized view

Snowflake materialized view, simply explained Members Public

A materialized view has the flexibility of a view and the speed of a table, but there are some caveats to this. In this post I look at the benefits, how to implement it, and most importantly when you should use it.

Stephen Allwright
Stephen Allwright
Snowflake
Snowflake substring function

Snowflake substring function, what you need to know Members Public

Substring, also known as substr, is a string and binary function in Snowflake. In this post I will walk through what itโ€™s useful for and how to use it in your database.

Stephen Allwright
Stephen Allwright
Snowflake
Snowflake concat function

Snowflake concat function, explained Members Public

Concat is a transformation function in Snowflake. In this post I will walk through what itโ€™s useful for and how to use it in your database.

Stephen Allwright
Stephen Allwright
Snowflake