Legacy Models in Hevo

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 include 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 toggle option is enabled, the table and table structure are retained but the data existing in the table columns is deleted and recreated each time the Model is run.

See Also

Updating Legacy Models

Last updated on 31 Jul 2020