Legacy Models in Hevo

Last updated on Dec 14, 2021

Legacy Models are identified by the LEGACY tag next to the Model name.

LEGACY Tag for older Models


Manual Table Column Definition

In legacy Models, if you are creating a new output table for the query results, you need to explicitly select the columns to be included in it. Similarly, if you change the query, you must manually ensure that the correct columns are selected for the output table. The columns must be listed for inclusion in the same order as expected in the SQL query output. This step has been automated in the newer Models.

A snapshot of Legacy Models


Truncate and Load

If the Truncate and load option is enabled, the table and its structure are retained but the data existing in the columns is deleted and recreated each time the Model is run.


See Also

Tell us what went wrong