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.
How to use COALESCE function in Snowflake Paid Members Public
Coalesce is a column transformation 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 REPLACE function in Snowflake Paid Members Public
Replace is a column transformation function in Snowflake which replaces sub-strings. In this post I will walk through what it’s useful for and how to use it in your database.
How to use LISTAGG function in Snowflake Paid Members Public
Listagg is an aggregation function in Snowflake which concatenates values. In this post I will walk through what it’s useful for and how to use it in your database.
Swap table in Snowflake, simply explained Paid Members Public
Swapping a table in Snowflake is a common and easy task to undertake by using the alter table command.
Add multiple columns to Snowflake table, simply explained Paid Members Public
Adding multiple columns to a table in Snowflake is a common and easy task to undertake by using the alter table command.
Add column to Snowflake table, simply explained Paid Members Public
Adding a column to a table in Snowflake is a common and easy task to undertake by using the alter table command
Drop table in Snowflake (explained with simple examples) Paid Members Public
It is straight forward to execute drop table in Snowflake. In the simplest form all you need to do is run the command drop table table_name.
Delete table in Snowflake (explained with simple examples) Paid Members Public
It is straight forward to delete a table in Snowflake. In the simplest form all you need to do is run the command drop table table_name.