Snowflake supports stored procedures. Stored procedures let you write a series of commands and...
Author - Walker Rowe
Creating & Using Snowflake Streams
In this tutorial, we’ll show how to create and use streams in Snowflake. (This article is part of...
User Defined Functions (UDFs) in Snowflake
In this tutorial, we show you how to create user defined functions (UDF) in Snowflake. In...
Snowflake: Using Analytics & Statistical Functions
Snowflake does not do machine learning. It only has simple linear regression and basic statistical...
Loading CSV Files from S3 to Snowflake
In this tutorials, we show how to load a CSV file from Amazon S3 to a Snowflake table. We’ve also...
Snowflake Window Functions: Partition By and Order By
Snowflake supports windows functions. Think of windows functions as running over a subset of rows...
Snowflake Lag Function and Moving Averages
This tutorials shows you how to use the lag function to calculate moving averages in Snowflake. It...
Snowflake SQL Aggregate Functions & Table Joins
In this article, we explain how to use aggregate functions with Snowflake. (This article is part of...
Writing SQL Statements in Amazon Redshift
In this tutorial, we show how to write Amazon Redshift SQL statements. Since this topic is large...
How to Copy JSON Data to an Amazon Redshift Table
Here we show how to load JSON data into Amazon Redshift. In this example, Redshift parses the JSON...