Modifying the Activation Query

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 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.

Unverified query changes

After you VALIDATE & SAVE QUERY, if there are 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 then click UPDATE MAPPING. For the changes to take effect, Hevo automatically restarts the Activation.

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 MAP NEW FIELDS.

Map New Fields

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


Revision History

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

Date Release Description of Change
Feb-21-2022 NA New document.
Last updated on 29 Apr 2022