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 feature, change the mapping of the column from record to variant in the columns mapping section.