Connect HubSpot and Snowflake Data Share

HubSpot's integration with Snowflake allows you to access all your HubSpot data directly within Snowflake, where you can then query it using SQL. Learn more about querying HubSpot data in Snowflake. The integration enables you and your team to retrieve valuable insights by combining HubSpot data with other datasets in Snowflake.

• Marketing Teams: they can use the data share to gain a deeper understanding of their campaigns and customer engagement.
• Sales Teams: they can use the data share to get a complete view of their leads and prospects, measuring conversion events and gaining insights into buyer behaviors.
• Service Teams: service and success teams can use the data share to analyze customer relationships, measure success health, and improve service quality.
• Analytics Teams: analytics teams can create powerful cross-departmental reports and insights.
• Content Teams: content teams can use the data share to understand their content engagement and audience preferences. 

Before you get started

• You must have an active Snowflake account. If you don't currently have an account, you can sign up for one on Snowflake's website. You'll 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.
• If your HubSpot account has HIPAA turned on and you want to use the HubSpot Snowflake integration (Snowflake Data Share), you'll need to use a Snowflake Business Critical account. If you're an existing user of the integration and want to turn on HIPAA for your HubSpot account, you'll need to reinstall the Snowflake integration to connect your Snowflake Business Critical account. 

Supported regions

Snowflake Data Share is available for Snowflake accounts in the following regions. To check your Snowflake account's region, run SELECT CURRENT_REGION(); in Snowflake.

Amazon Web Services (AWS)

• North America: US East (N. Virginia) (us-east-1), US East (Ohio) (us-east-2), US West (Oregon) (us-west-2), and Canada (Central) (ca-central-1).
• South America: São Paulo (sa-east-1).
• Europe: Ireland (eu-west-1), London (eu-west-2), Paris (eu-west-3), Frankfurt (eu-central-1), and Stockholm (eu-north-1).
• Asia Pacific: Mumbai (ap-south-1), Singapore (ap-southeast-1), Sydney (ap-southeast-2), Tokyo (ap-northeast-1), Seoul (ap-northeast-2), and Osaka (ap-northeast-3).

Microsoft Azure

• North America: East US 2 (eastus2), Central US (centralus), South Central US (southcentralus), West US 2 (westus2), and Canada Central (canadacentral).
• Europe: North Europe (northeurope), West Europe (westeurope), UK South (uksouth), and Switzerland North (switzerlandnorth).
• Middle East: UAE North (uaenorth).
• Asia Pacific: Central India (centralindia), Southeast Asia (southeastasia), Japan East (japaneast), and Australia East (australiaeast).

Google Cloud Platform (GCP)

• North America: Iowa (us-central1) and N. Virginia (us-east4).
• Europe: London (europe-west2) and Netherlands (europe-west4).

Connect HubSpot and Snowflake

1. In your HubSpot account, click the Marketplace icon in the top navigation bar, then select HubSpot Marketplace.
2. Click the search bar and enter Snowflake Data Share. 

3. Click Snowflake Data Share from the listing page. 
4. Click Install. 
5. Click the Snowflake account region dropdown menu and select your Snowflake account's region (e.g. AWS_US_EAST_1). To find your account region, run: SELECT CURRENT_REGION(); 
6. Enter your Snowflake account name, using the format <org_name>.<account_name>. You can find this by running:
   SELECT CONCAT(CURRENT_ORGANIZATION_NAME(),'.',CURRENT_ACCOUNT_NAME());
7. Click Install. 

8. On the dialog box for HubSpot is requesting permission to share your data with Snowflake, click Allow and install. 

9. Once the app has been installed, you'll receive an email from Snowflake with the subject line "A data product is ready for your Snowflake account!". 

Create a database in Snowflake

Once connected, you can create a database in Snowflake for your HubSpot data.

1. In your Snowflake account, in the left sidebar menu navigate to Data Sharing > External Sharing. 

2. On the Shared with you tab, you'll find your share either in the Privately shared listings section or the Direct shares section. 
3. The available shares will show as follows: 

• • Privately shared listings: <PRIVATE_HUB_PortalID>
  • Direct shares: <HUB_PortalID>

4. Click Get to create a database and query your HubSpot data.

Please note: if you have a large amount of data, this process may take longer. 

Next steps 

Learn how to set up your Snowflake environment and query your HubSpot data in Snowflake.