Sync data from your Snowflake data warehouse to HubSpot CRM objects, such as contacts, companies, deals, and custom objects. With Snowflake Direct Sync, you can connect a Snowflake table or view, map columns to HubSpot properties, and schedule recurring syncs without needing to build datasets in Snowflake first.
For example, you can sync account data from Snowflake to company records in HubSpot by mapping fields such as account_id to Company ID and arr to Annual revenue, to keep those records in sync.
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.
The Snowflake user used by the integration must have the following permissions:
Warehouse access: this allows the integration to execute queries.
Database and schema access: this allows the integration to browse and read data.
Table or view access: this allows the integration to select data.
The Snowflake user used by the integration must have permissions to create or edit properties and records in HubSpot for the object you’re syncing to.
Understand limitations & considerations
Syncs run on a schedule and do not update in real time.
Data syncs one way from Snowflake to HubSpot.
Each sync evaluates all source data, then updates only records with changes.
Filtering during syncs is not supported. To filter data, create a view in Snowflake before syncing.
A single Snowflake table or view can sync to multiple CRM objects.
Associations between objects can be defined during mapping.
A table or view can include up to 10 GB of data.
Each sync run can process up to 30 million records.
A table or view can include up to 200 columns.
Network allowlisting
If your Snowflake environment limits inbound syncs, allowlist HubSpot IP ranges based on your HubSpot data hosting location:
In your HubSpot account, click the Marketplace icon in the top navigation bar, then select HubSpot Marketplace.
Search for Snowflake, then click Install.
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.
Click Connect to Snowflake. You can continue to set up the sync or set it up at a later time.
Configure the sync
To start syncing data from Snowflake to HubSpot, set up the sync.
In your HubSpot account, click the settings icon in the top navigation bar. In the left sidebar menu, navigate to Integrations > Connected Apps.
Click Snowflake.
In the right panel, click Select for the Snowflake account you want to sync data from.
On the Data source page, click the Database dropdown menu and select your Snowflake database.
Select the schema, table, and computing warehouse that you want to sync to HubSpot.
Then click Next.
On the How do you want to use your Snowflake data? dialog box, click Next.
On the Columns page, click the Destination dropdown menu and select the HubSpot object you want to sync to (e.g., contacts, companies, deals, or custom objects). You can sync multiple objects and their associations.
Click the Sync mode dropdown menu and select a sync mode:
Create and update: create new records and update existing ones.
Create only: create new records only; skip existing matches.
Update only: update existing records only; skip non-matches.
In the Match keys section, select a Snowflake column and a HubSpot property. These values are used to match records between Snowflake and HubSpot and avoid duplicates.
In the Mappings section, map Snowflake columns to HubSpot properties.
Review suggested mappings.
Click + Map another column to manually map another column.
Click + Map remaining columns to automatically map all remaining available columns.
To delete a mapping, click the delete icon next to the mapping.
Click Next.
On the Schedule page, click the Sync frequency dropdown menu and select the frequency that you want data to sync from Snowflake to HubSpot.
HubSpot Credits required
