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.
Select all columns except one or multiple in Snowflake Paid Members Public
Learn how to write SQL queries that select all columns in Snowflake except for one or more, by using the exclude and rename functions.
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.
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.
How to use SUBSTRING function in Snowflake 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.
How to use CONCAT function in Snowflake 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.