Overview

If you would like to access your Funnel data in a Snowflake data warehouse, you can do so by setting up a new Snowflake Share. This will expose your chosen Funnel data as a "Secure Data Share" in the Snowflake account you provided.

Setup a Share in your Funnel account

1. Go to the Data Warehouse page and click New Share

2. Choose Snowflake as your destination.

3. Provide your Snowflake Account URL

Just copy the URL from the web browser when you're logged into your Snowflake account. It should look something like this: https://xy1234.eu-west-1.snowflakecomputing.com.

4. Choose what data you want to share

5. Select how much historic data you want

Data will be overwritten so include the entire period you want to be visible in Snowflake. If you for example select "Last 6 months" data will not accumulate and you will always have exactly the last 6 months in your Snowflake table.


6. Save and run the Share

Press Save then toggle the Share to enable it.
Then press Run job to run a job right away, bypassing the schedule.

Access the Data Share in your Snowflake account

Once the export have finished, Login to your Snowflake account and navigate to Shares.

Click on the Secure Share from Funnel in the list and then Create Database from Secure Share

Congratulations! You now have a database with your Funnel data ready to be used in Snowflake. The data will automatically refresh several times a day according to the schedule in your Funnel Share.

Did this answer your question?