Modifying the Activation Query

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

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.

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.

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.

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