7 October 2025

Automatic mapping of JSON data types to compatible targets

Share this message

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

  • If you are using Data Movement gateway to access your data source, version 2024.11.70 or later is required.

  • Supported with a SaaS application Preview connectors only.

Replication tasks: JSON column mapping

Lake landing tasks: JSON column mapping

How can we help?

Barry has over 20 years experience as a Data & Analytics architect, developer, trainer and author. He will gladly help you with any questions you may have.