Azure Synapse Analytics FAQ

How can I force a JSON (Record) column not to split into several columns?

A. Data Integration automatically splits every JSON column recognized into its underlying columns.

To bypass this functionality, change the mapping of the column from "record" to "variant" in the columns mapping section.