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? Paid Members Public
Views and tables are foundational objects in a SQL database, but what are the differences between them?
Select a random sample of rows in Snowflake Paid Members Public
Learn how to select a sample of rows randomly from a table or view in Snowflake.
Drop column from a Snowflake table Paid Members Public
Learn how to drop a column from a table using the alter table command in Snowflake.
How to create a temporary table in Snowflake Paid Members Public
Learn how to create a temporary table in Snowflake using both the select as and insert into methods.
Grant role to user in Snowflake Paid Members Public
Learn how to grant a role to a user or a role to another role in Snowflake using simple SQL commands.
How to rename a table in Snowflake Paid Members Public
Learn how to rename a table in Snowflake using the alter table SQL command.
How to rename a column in Snowflake Paid Members Public
Learn how to rename a column in Snowflake by using the alter table SQL command.
How to use Snowflake's IFNULL function Paid Members Public
IFNULL is a helpful function in Snowflake which returns a defined value when the initial expression is NULL.