Snowflake to HubSpot
Turn Snowflake customer history into HubSpot contact updates and lists through Amperity, using Snowflake Secure Data Sharing inbound, identity resolution and audience selection in Amperity, and the HubSpot API outbound.
See the HubSpot docsSnowflake Bridge docsHow to send Snowflake data to HubSpot
Share selected Snowflake data. Configure an inbound Amperity Bridge using Snowflake Secure Data Sharing and map shared data to Amperity domain tables.
Build customer context. Apply identity resolution and combine available customer history in Amperity, then select contacts and fields for HubSpot.
Send contacts to HubSpot. Configure the HubSpot destination and a named list, then run an orchestration manually or on a schedule.
Turn Snowflake customer context into HubSpot contact lists
Update existing HubSpot contacts with selected customer attributes.
Create new HubSpot contacts when contact creation is enabled.
Populate named HubSpot contact lists from query results.
Prepare repeat-buyer contact lists from purchase history available in Amperity.
What the Snowflake to HubSpot connection supports
HubSpot object or field | Mapping and behavior | Documentation |
|---|---|---|
Contact identity | Map the query email field to the audience primary key email. | |
Existing contacts | Send selected fields to update existing HubSpot contacts. | |
New contacts | Enable Create new contacts? to create contacts missing from HubSpot. | |
Contact properties | Map query fields to lowercase contact-property names; format date values in UTC. | |
Named contact lists | Set List name to an existing or new HubSpot list. |
Put Snowflake customer history to work in HubSpot
Prepare a repeat-buyer contact list
Use purchase history shared from Snowflake to define repeat buyers in Amperity. Send their email addresses to a named HubSpot contact list so the team can review the audience before using it in its HubSpot marketing workflow.
Add context to existing contacts
Select relevant customer attributes for HubSpot contacts, such as a purchase category already available in Amperity. Map fields to HubSpot contact properties so teams can review relevant purchase context alongside existing CRM records.
Set up Snowflake sharing and the HubSpot destination
Create a Snowflake share with secure views, and use the account locator for your Amperity stack and Snowflake cloud region; contact Support for an unlisted combination. Check supported types: complex types require defined schemas, and VARIANT is unsupported. Follow the Snowflake Bridge setup.
Authorize HubSpot with OAuth, configure the destination and email key, and validate a sample in a sandbox before production. Invalid email can fail the entire import. Review field mapping and contact-creation settings in the HubSpot destination setup.
Snowflake to HubSpot integration FAQs
What is Snowflake?
What is HubSpot?
How can I send Snowflake data to HubSpot?
Does this integration create new HubSpot contacts?
How often does Snowflake data sync to HubSpot?
Bring customer context to your HubSpot contacts
Explore a Snowflake to HubSpot workflow with Amperity.
Get a demo