Partner Enabled Data Loading with Stitch into Snowflake

In a previous blogpost I showed how easy it is to load data using Fivetran. Similarly you can use Stitch. For this blog I will use Partner Enabled Data Loading with Stitch and load a Google Analytics data into Snowflake.

Make sure you are an Account admin. Click on Partner Connect in the Navigation Bar (or Ribbon).

Image for post

Setting up a connection is very easy and straight forward. There are a few steps (review disclaimers, successfully connecting, activating, etc. ) which speaks for itself.

Check Stitch

In the end, you will have a specific database, a virtual warehouse, a user and a role specifically setup for use with the (in this case) Stitch.

In Stitch you can see the Destination to Snowflake is working.

Image for post
Image for post

Stitch Integration

Now we have the Snowflake connection ready, we can add an integration between Stitch and Google Analytics.

Image for post
Image for post

Configure Integration

Now we have added the configuration, we should give it a name. This name will end up in the Snowflake Data Warehouse as a table.

Image for post
Image for post

Then authorize Stitch to be able to load data from your Google Analytics Account.

Image for post
Image for post

If all works like it should, you are authorized to load data from Google Analytics. Now you should specify which profile you want to load the data from.

Image for post
Image for post

Now you should select which tables you want to load from Google Analytics. It makes sense to check the documentation.

Image for post
Image for post

Everything is set. You should be able to save the integration.

Image for post
Image for post

You are all done. The integration is ready to load data from Google Analytics to Snowflake using Stitch.

Check Snowflake result

You should be able to query the Google Analytics from Snowflake.

Image for post
Image for post

The setup was relatively easy. Within a few minutes Stitch helps you setup the necessary objects in Snowflake and loads the data for you from Google Analytics. This blogpost shows how relatively easy it is to setup a modern data pipeline.

Thanks for reading.

Cheers,

Daan Bakboord

Originally published at https://daanalytics.nl on June 28, 2019.

Data & Analytics 📊 Consultant @daanalytics_nl & Partner @pongprof & Board Member @nl_OUG | Modern ☁️ Analytics #Oracle #Snowflake #Looker #Matillion #Fivetran

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store