BetaConnect HubSpot and Snowflake Data Sync (legacy)

Connect HubSpot and Snowflake (legacy) to sync data from tables in your Snowflake account with HubSpot records. This article should be used as a reference for existing users of the legacy Snowflake data sync integration. If you’re looking to connect Snowflake to HubSpot for the first time, learn more about it here.

Before you get started

• The Snowflake user connecting the integration must have access to at least one Snowflake warehouse and READ access to the database/schema/table/view that you're syncing.

• To prevent sync errors, a Snowflake admin should set PREVENT_UNLOAD_TO_INLINE_URL = FALSE for the Snowflake user used by the integration.

• The level of access HubSpot has to your Snowflake instance depends on the permissions assigned to it. You can choose to use a Snowflake role that lets HubSpot copy the chosen customer data into HubSpot and has a scope you're comfortable with.
• You can create more than one object sync to sync data from different Snowflake tables, but you can only have one sync per Snowflake table. 
• If you need to get the range of IP addresses needed to connect HubSpot to your Snowflake account, contact HubSpot Support. 

Connect the app

1. Make sure your HubSpot account is opted in to this beta: Snowflake Data Ingestion. 
2. Navigate to this link: https://app.hubspot.com/portal-recommend/l?slug=data-sync/app/2963325.
3. Click Install. 
4. In the dialog box, click Next. Then enter your Snowflake Account Identifier, Username, and follow the steps to assign the public key as shown below. 

5. Click Connect to Snowflake. You can continue to set up the sync or set it up at a later time. 

Start a sync

1. In your HubSpot account, click the settings icon in the top navigation bar. In the left sidebar menu, navigate to Integrations > Connected Apps.
2. Click Snowflake. 
3. Click Set up a sync. 
4. On the Select the data that you want to sync page:

• • On the Snowflake card, select which Database, Schema, and Table to sync from. 
  • Choose the direction the data should sync.
  • Choose which HubSpot object the data should sync to. 

5. On the Configure page: 

• • In the Record matching section, select how you want to match records in HubSpot and Snowflake:
    • Choose my own fields to match on: select the Snowflake field and HubSpot property to be used to match records in both apps.
    • Do no matching: this is recommended if you want to move all Snowflake records to HubSpot and don't have any matching records for the object you want. 
    • Learn more about how records are matched in a data sync. 

• • In the Reference fields section:
    • Select the Warehouse field. The warehouse selected should have a size compatible with the number of rows you're syncing to HubSpot. 
    • Select the Record ID field. This field is the unique record ID from the Snowflake table.

• • In the Subscription settings section, click the Sync frequency dropdown menu and select the frequency at which you want to sync the data.
  • In the Mapped fields section, set up any field mappings for each column that you want to sync to HubSpot contact properties. 

6. On the Limit page, click Edit to add any filters to limit which ones will sync from one app to the other. You can add multiple filters with AND or OR conditions. By default, all records are included in the sync. 
7. On the Review page, review your sync configuration and click Save and sync.

Please note: associations are not supported for sync via Snowflake Data Ingestion.

Migrate from the legacy Snowflake data sync integration

HubSpot is sunsetting the legacy Snowflake data sync integration on Oct. 30, 2026. Before then, migrate to the new Snowflake experience.

1. In your HubSpot account, click the settings icon in the top navigation bar. In the left sidebar menu, navigate to Integrations > Connected Apps.
2. Click Snowflake.
3. In the sunset banner, click Set up new sync.

4. You’ll be redirected to the Data Integration page.
5. In the right panel, your existing Snowflake account will auto-populate. Click Select.
6. Select the Snowflake table and warehouse that you want to sync.
7. On the How do you want to use your Snowflake data? dialog box, select one of the following options:

 

• • Connect this app directly to your CRM: sync the selected Snowflake data directly to HubSpot. This option is recommended if you don't need to modify the source data before syncing.
    • You’ll be prompted to select the source columns and map them to the HubSpot object you want to sync to, as well as the sync frequency. Learn more about setting up the sync.
    • Click Sync to HubSpot CRM.
  • Connect this app to Data Hub: connect the source to Data Studio before syncing to HubSpot. This option is recommended if your legacy sync uses filters or if you want to filter records, create formulas, add conditional logic, or combine multiple data sources before syncing.
    • You’ll be prompted to select the source columns and the sync frequency.
    • Click Set up CRM sync.
    • You’ll be redirected to the Dataset builder where you can edit your source data with filters and formulas. Learn more about setting up the sync with Data Studio

After setting up the sync, confirm that it’s importing data as expected.

1. In your HubSpot account, click More, then navigate to Data Management > Data Integration. If More doesn't appear in your account, navigate to Data Management > Data Integration directly.
2. Click the App syncs tab.
3. Verify that the sync is importing data correctly.

After you've verified that the new sync is working correctly, turn off or delete the legacy Snowflake data sync integration.