FAQ - Azure Synapse Analytics

Q. How can I force the a JSON (Record) column no to split to several columns?

A. Data Integration automatically splits every JSON column recognized to it's underlying columns.

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