Hightouch is the easiest way to sync data from your warehouse to any downstream marketing or sales tools via SQL, no scripts or APIs.
The Hightouch-mParticle integration enables you to query, map, and forward data from your data warehouse(s) to mParticle via Hightouch’s platform.
You will need to write SQL to query your data warehouse(s) and format the data to meet mParticle’s Events API schema. Hightouch provides a configuration interface that will let you map your query results to mParticle’s API fields as described below.
You should first use this integration with limited data and with the mParticle environment set to “Development” to ensure the data meets your expectations. Use mParticle’s Live Stream to verify sample data is successfully processed.
If there are any questions on how to configure Hightouch models or syncs please reach out to your Hightouch account manager.
SQL competency is required to configure models in Hightouch. To use this integration successfully, you should have a strong foundation in both SQL and the mParticle Events API.
You must maintain and have access to a supported Hightouch Source from which you will send data (e.g. Snowflake or BigQuery).
Hightouch supports sending data as Events or Objects.
User Attribute Data
Note that you cannot map data to mParticle Consent States.
Supported Identity Types
Hightouch supports mapping to all mParticle user and device identity types, including MPID.
Supported mParticle Events API Fields
By formatting SQL query results when you create a Hightouch model in step 2, you can map your query data to mParticle Events API fields. These mappings are defined via Hightouch’s configuration UI. The SQL result must be formatted so that it complies with mParticle’s Events API format for any given field.
Hightouch’s configuration UI supports mapping query results to the following mParticle Events API fields:
mParticle’s Reserved User Attributes
Custom User Attributes
Custom Event Attributes
Hightouch’s configuration UI supports mapping query results to the following additional mParticle Events API fields for Custom Events:
Hightouch’s configuration UI supports mapping query results to the following additional mParticle Events API fields for Commerce Events:
Create a Hightouch model by writing SQL to query the defined source. Your model will transform your data warehouse’s schema to make it mappable to mParticle’s Events API. Note that the SQL syntax is source-dependent, and the SQL results must be formatted to align with mParticle’s Events API (see product_action example below).
Create a Hightouch destination for mParticle using Hightouch Feed credentials from mParticle’s integrations directory.
Create a Hightouch sync to map your model to mParticle Custom Events, Commerce Events, or User Data.