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).
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.
Stitch Integration
Now we have the Snowflake connection ready, we can add an integration between Stitch and Google Analytics.
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.
Then authorize Stitch to be able to load data from your Google Analytics Account.
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.
Now you should select which tables you want to load from Google Analytics. It makes sense to check the documentation.
Everything is set. You should be able to save the integration.
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.
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,
Originally published at https://daanalytics.nl on June 28, 2019.
