This article introduces you to Pandas, a data analysis library of tools that’s built upon Python...
Author - Walker Rowe
Creating Redshift User Defined Function (UDF) in Python
You can create user defined functions in Amazon Redshift in Python. If you use Amazon Lambda...
Using Stored Procedures in Snowflake
Snowflake supports stored procedures. Stored procedures let you write a series of commands and...
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...