Skip to content
Menu

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 docs

Snowflake

How to send Snowflake data to HubSpot

  1. Share selected Snowflake data. Configure an inbound Amperity Bridge using Snowflake Secure Data Sharing and map shared data to Amperity domain tables.

  2. Build customer context. Apply identity resolution and combine available customer history in Amperity, then select contacts and fields for HubSpot.

  3. Send contacts to HubSpot. Configure the HubSpot destination and a named list, then run an orchestration manually or on a schedule.

HubSpot logo

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.

Amperity setup; Contacts API

Existing contacts

Send selected fields to update existing HubSpot contacts.

Amperity setup; Contacts API

New contacts

Enable Create new contacts? to create contacts missing from HubSpot.

Amperity setup; Contacts API

Contact properties

Map query fields to lowercase contact-property names; format date values in UTC.

Amperity setup; Contacts API

Named contact lists

Set List name to an existing or new HubSpot list.

Amperity setup; Segments API

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

Bring customer context to your HubSpot contacts

Explore a Snowflake to HubSpot workflow with Amperity.

Get a demo