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”
Tag Archives: Snowflake
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”
Snowflake: Simplify Ranking Syntax with QUALIFY
Common Task: Ranking Data and Selecting Top n Records A common task for database developers is to rank a set of data and return the top n records – the top 5 companies per year by total sales volume, for example. Coming from a SQL Server background, this would typically be handled by a CTEContinue reading “Snowflake: Simplify Ranking Syntax with QUALIFY”
Eric Heilman 