Skip to main content
Skip table of contents

AUTO_ADD_COLUMNS

You are looking at an older version of the documentation. The latest version is found here.

This property serves to automatically check changes in the source metadata and apply them to the target objects. It can have one of the following values:

ValueDescription
FALSENo automatic metadata adjustment; default
TRUEAutomatically add columns to the target table

When this property is enabled, the Web API connectors and certain jobs (e.g. incremental replications) will compare the metadata of the source and target objects on each replication. If new columns have been detected, the engine will automatically build the corresponding ALTER TABLE statement and add new columns to the destination tables. From this point on, the Data Virtuality Server will be able to access the new columns.

Please note that the ALTER TABLE behaviour is currently supported for PostgreSQL, Snowflake, and Big Query destinations only.

AUTO_ADD_COLUMNS option is available since v2.4.9

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.