Azure Synapse Analytics FAQ

Updated 2 April 2026

How to force a JSON (record) column not to split into different 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.