Connect HubSpot and Snowflake Data Share

HubSpot's integration with Snowflake allows you to access all your HubSpot data in Snowflake. You can retrieve HubSpot data in Snowflake by running SQL queries. Learn more about querying HubSpot data in Snowflake.

Before you begin

• 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 available to all Snowflake account regions, and will be regularly updated to support newly added regions.
  • To 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.

• You must be a super admin or have App Marketplace permissions in your HubSpot account.
• If you're storing HIPAA-protected Sensitive Data, the Snowflake Data Share integration is only supported for two regions: AWS US_EAST_1 and AWS EU_CENTRAL_1. If your existing account is in a different region, you must create a new account in one of the supported regions to connect and store protected health information.
• If you have the HubSpot Snowflake integration (Snowflake Data Share) and want to use HIPAA, you'll need to reinstall the Snowflake integration to use a Snowflake Business Critical account. 

Connect HubSpot and Snowflake

• In your Snowflake account, navigate to the listing page for CRM Platform Data from HubSpot.
• Click Request, then accept Snowflake's terms. This must be completed before you proceed with the rest of the steps. 

• In your HubSpot account, click the Marketplace icon marketplace in the top navigation bar, then select App Marketplace.
• Click the search bar and enter Snowflake. 
• Click Snowflake from the listing page. 
• 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(); 
• 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());
• If you have not requested the CRM Platform Data from HubSpot product in Snowflake, click the Accept terms button to accept Snowflake's terms for installing the app. You will be redirected to your Snowflake account.
  • In your Snowflake account, click Request. 

• Click Install. 

• In the dialog box, click Allow and install. 

• Once the request has been made, you will receive an email from HubSpot with instructions for installing the app from the HubSpot marketplace. This may take up to 24 hours. The instructions can also be found here. 
  • In your HubSpot account, click the Marketplace icon marketplace in the top navigation bar, then select App Marketplace.
  • Click App Marketplace.
  • Use the search bar to locate and select the Snowflake integration.
  • In the upper right, click Install app.

The integration will then begin processing your HubSpot data. If you have larger amount of data, this process will take longer.

If you encounter the following error Share ‘HUBSPOT_PRODUCT.HUB_12345’ cannot be imported because the terms for the associated listing ‘GZSOZ4LK70’ in data exchange ‘SNOWFLAKE_DATA_MARKETPLACE’ have not been accepted, do the following:

• Navigate to the Snowflake Marketplace listing for HubSpot Data.
• Accept Snowflake's terms. 
• Create a database in Snowflake. 

Once the app has been installed, you will receive an email from Snowflake with the subject line Snowflake Marketplace: Listing Request Approved. The email contains steps on how to create a database in Snowflake. 

Create a database in Snowflake

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

• In Snowflake, navigate to the listing page for CRM Platform Data from HubSpot.
• Click Get to create a database and query your HubSpot data. 

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. The list of supported regions include:

• AWS US_EAST_1
• AWS EU_CENTRAL_1
• AWS US_WEST_2
• AWS AP_SOUTHEAST_2
• AWS EU_WEST_1
• AWS AP_SOUTHEAST_1
• AWS CA_CENTRAL_1
• AWS US_EAST_2
• AWS AP_NORTHEAST_1
• AWS AP_SOUTH_1
• AWS EU_WEST_2
• AWS_EU_WEST_3
• AWS AP_NORTHEAST_2
• AWS_AP_NORTHEAST_3
• AWS_SA_EAST_1
• AWS EU_NORTH_1
• AZURE EASTUS2
• AZURE WESTEUROPE
• AZURE AUSTRALIAEAST
• AZURE CANADACENTRAL
• AZURE SOUTHEASTASIA
• AZURE WESTUS2
• AZURE SWITZERLANDN
• AZURE_CENTRALINDIA
• AZURE CENTRALUS
• AZURE JAPANEAST
• AZURE NORTHEUROPE
• AZURE SOUTHCENTRALUS
• AZURE UAENORTH
• AZURE_UKSOUTH
• GCP US_CENTRAL1
• GCP_US_EAST4
• GCP EUROPE_WEST2
• GCP EUROPE_WEST4
• GCP EUROPE_WEST4