Support for JSON-to-JSON column mapping

A new Map compatible source JSON columns to JSON columns on the target option has been added to the task settings’ Metadata tab. With new tasks, this option is selected by default if there are compatible source JSON data types which are also supported by the target. However, before this option was introduced, JSON columns were mapped to STRING on the target. Consequently, for existing tasks, this option will be disabled by default as any downstream processes – such as transformations – will expect the target data to be in STRING format. You can either leave the option disabled or you can edit the downstream processes to be compatible with JSON format and then enable this option.

Metadata