Automatic mapping of JSON data types to compatible targets

Starting today, when using replication or lake landing tasks, JSON data types from SaaS application sources will be automatically mapped to compatible target data types. This functionality is facilitated through the new Map compatible source JSON columns to JSON columns on the target option in the task settings, which is enabled by default for new tasks. For existing tasks, it is disabled by default to preserve backward compatibility with downstream processes that expect the data to be mapped as STRING.

The JSON data type will be mapped as follows:

• VARIANT on Snowflake and Databricks

• JSON on Google BigQuery

Replication tasks: JSON column mapping

Lake landing tasks: JSON column mapping