AUTO_ADD_COLUMNS

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:

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 CData 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.