Model Reset

Hevo provides the option to reset a Model if you need to re-create the output table for any reason. For example, if you execute an incorrect query in the Model and do not find the output table data usable in its current form, you can reset the Model. During a reset, all the existing data in the output table is purged.

Resetting applies only to incremental Models, as in the case of full load or non-incremental Models, the output table is recreated each time the Model runs.

To reset a Model, click the RESET MODEL button above the SQL Query builder in the right pane. Hevo changes the Model’s status to RESETTING.

Once the Model is reset, its status is updated based on the outcome of the previous run:

• If the previous run was unsuccessful, the status is set to the last run’s state.

• If the previous run was successful, the status is set to SCHEDULED or PAUSED.

However, if the reset operation fails for any reason, the Model’s status is updated to RESET FAILED. In this case, you can update the Model or try resetting it again later.

If your Model has templatized queries, the timestamp is reset to 0 and the data is purged during the reset. Therefore, in the next run of the Model, the query fetches all the records from the start. However, if any data was deleted from the Destination table in the past, that data is not recreated in the output table. In subsequent runs, the query fetches incremental data, as usual.

Note: If you are using Legacy Models, you can switch over to the new Models to consume the latest features. Read Updating Legacy Models.