Skip to main content

Snowflake: access an existing data warehouse

Introduction​

Welcome to the Snowflake on Outerbounds journey!

📈 Learning objectives​

The goal of this self-contained lesson is to configure your Outerbounds account to work with Snowflake. You will learn how to:

  • access your databases, users, and roles in Snowflake, and
  • move data between Snowflake, Outerbounds workstations, and Metaflow tasks.

This lesson assumes you already have a Snowflake database, user, and role set up. If you don't already have a database, user and role, create them now.

Outerbounds and Snowflake integration​

If you are an Outerbounds admin, configure your Snowflake resource integration. If you are not an admin, you can still follow by manually setting your key, or ask an admin to create the resource integration for you. The form will include another query to run on Snowflake to establish the security integration.

Download the content to your workstation​

Once your web IDE opens, open a terminal and run the outerbounds tutorials pull --url https://outerbounds-journeys-content.s3.us-west-2.amazonaws.com/main/journeys.tar.gz --destination-dir ~/learn command from the previous step. This will download the content to your workstation. Click Next once you see Tutorials pulled successfully.

Move data between a notebook and Snowflake​

Open the 01-nb notebook to learn how to create a table in Snowflake and move data between the notebook and Snowflake.

Move data between a workflow and Snowflake​

Open the 02-flow file to learn how to create a table in Snowflake and move data between a Metaflow workflow and Snowflake.

Next steps​

You have completed the primary steps of this journey, showing how you can use Snowflake features from Outerbounds. With these skills, there are many more patterns and integrations you can build on with Snowflake and Outerbounds - you can find more information in this article.