Here we show how to load CSV files and JSON files into a Pandas dataframe using Pandas. (Brand new...
Author - Walker Rowe
Pandas Introduction & Tutorials for Beginners
This article introduces you to Pandas, a data analysis library of tools that’s built upon Python...
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 tutorial 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...