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.
• HubSpot's integration with Snowflake Data Sharing is available to all Snowflake account regions, and will be regularly updated to support newly added regions.
  • To get your Snowflake account's region, run the following command in Snowflake: 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.
• 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. 

Connect HubSpot and Snowflake

1. In your HubSpot account, click the Marketplace icon marketplace 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. 

Supported regions

HubSpot customers hosting data in all major AWS regions can install the data share integration. In addition, the integration supports Snowflake data with Google Cloud Platform (GCP) and Microsoft Azure. All regions in these cloud providers are supported. 

Next steps 

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