Legacy Models in Hevo

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

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.

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

• Updating Legacy Models