Last updated: November 1, 2021
|Operations Hub Enterprise|
HubSpot's integration with Snowflake allows you to access all your HubSpot data in Snowflake.
Using Snowflake Data Sharing, you can retrieve HubSpot data In Snowflake by running SQL queries. Learn more about querying HubSpot data in Snowflake.
To use this feature, you must have an active Snowflake account. If you do not currently have an account, you can sign up for one on Snowflake's website. You will be responsible for all Snowflake costs incurred while accessing HubSpot’s Data Share. Please see Snowflake’s Terms of Service for more information and pricing details.
HubSpot’s integration with Snowflake Data Sharing is currently available only if your Snowflake account region matches the region of HubSpot’s Snowflake account. For HubSpot accounts in the EU data center, this means EU_CENTRAL_1_AWS. For all other HubSpot accounts, this means US_EAST_1_AWS.
SELECT CURRENT_REGION();. The command will return your account region, such as AWS_US_EAST_1 . Learn more about this command in Snowflake’s documentation.
Once connected, you can create a database in Snowflake for your HubSpot data:
Next, learn how to set up your Snowflake environment and query your HubSpot data.
Create a custom multi-touch revenue attribution report. Multi-touch attribution relates revenue in the form...
Use contact create attribution reports to see which marketing efforts are leading to new contacts. For...
You can create and add funnel reports to your dashboard to monitor your sales and marketing team's progress....