Modifying the Activation Query

Last updated on Jul 18, 2023
On This Page

You can modify the SQL query of your current Activation from the QUERY sub-tab in the Activations Detailed View.

Modify the Activation Query

When you make changes to the SQL query, the UNVERIFIED CHANGES label is displayed on the SQL QUERY dialog until you click VALIDATE & SAVE QUERY. The LAST SAVED QUERY is the query in use by the Activation, and any changes made in the SQL query editor are lost if you revert to this query.

Note: Activate saves your modified query only if you have included the query fields that were previously mapped to the identifiers and mandatory fields. Read Map Warehouse fields to Target fields.

Unverified Query Changes

After you validate and save the SQL query, if there are any unmapped columns in your query, the Field Mapping dialog is displayed. Here, you can select the check box next to the fields that you want to map, and click UPDATE MAPPING. For the changes to take effect, Hevo automatically restarts the Activation.

However, if there are no mapping changes required, the Activation query is updated and used immediately. It also becomes the last saved query.

Update Field Mapping

If you close the Field Mapping dialog box without mapping the fields, the query is saved in DRAFT mode. To use this query in the Activation, you must click MAP NEW FIELDS.

Map New Fields

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Jul-17-2023 NA Updated the content to reflect supported functionality.
May-24-2022 1.89 Added a note to inform that the modified query is not saved if the fields required by the Target object are missing.
Feb-21-2022 NA New document.

Tell us what went wrong