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.

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

Views and tables are foundational objects in a SQL database, but what are the differences between them?

Stephen Allwright
Stephen Allwright
Snowflake

Select a random sample of rows in Snowflake Members Public

Learn how to select a sample of rows randomly from a table or view in Snowflake.

Stephen Allwright
Stephen Allwright
Snowflake

Drop column from a Snowflake table Members Public

Learn how to drop a column from a table using the alter table command in Snowflake.

Stephen Allwright
Stephen Allwright
Snowflake

How to create a temporary table in Snowflake Members Public

Learn how to create a temporary table in Snowflake using both the select as and insert into methods.

Stephen Allwright
Stephen Allwright
Snowflake

Grant role to user in Snowflake Members Public

Learn how to grant a role to a user or a role to another role in Snowflake using simple SQL commands.

Stephen Allwright
Stephen Allwright
Snowflake

How to rename a table in Snowflake Members Public

Learn how to rename a table in Snowflake using the alter table SQL command.

Stephen Allwright
Stephen Allwright
Snowflake

How to rename a column in Snowflake Members Public

Learn how to rename a column in Snowflake by using the alter table SQL command.

Stephen Allwright
Stephen Allwright
Snowflake

How to use Snowflake's IFNULL function Members Public

IFNULL is a helpful function in Snowflake which returns a defined value when the initial expression is NULL.

Stephen Allwright
Stephen Allwright
Snowflake