Author Archives: Eric Heilman

Snowflake: Loading Data from Stage

In the previous articles in this series, we’ve created a named internal stage and connected to an Amazon S3 Bucket as an external stage. So now what? We need to load the data from the staged file to a table so that we can execute SQL Commands against the data as needed. In this postContinue reading “Snowflake: Loading Data from Stage”

Snowflake: Connect to S3 Bucket

Create An Amazon S3 External Stage External stages with cloud providers such as Amazon AWS, Google Cloud Platform or Microsoft Azure can be thought of as “windows” from Snowflake to a set of files in an outside location. Like an internal stage, an external stage can be created with just a few lines of code.Continue reading “Snowflake: Connect to S3 Bucket”

Snowflake: Getting Started with Stages

One of the most fundamental tools in the toolbox for data developers is loading a data file from a staging, or landing, location into a database. From there the possibilities are endless to transform the data through code to fit your needs. For a lot of developers with on-premises solutions, this takes the form ofContinue reading “Snowflake: Getting Started with Stages”