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 Paid 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.
View vs table in SQL, what are the differences? Paid 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.
Materialized view vs table in SQL, what are the differences? Paid 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?
View vs materialized view, what are the differences? Paid 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.
Snowflake CREATE VIEW, what you need to know Paid 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.
Snowflake materialized view, simply explained Paid 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.
Snowflake substring function, what you need to know Paid 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.
Snowflake concat function, explained Paid 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.