I have JSON files that I need to store in Azure Synapse table.
One record looks like this:
{ "type": "Feature", "properties": { "id": 12356}, "geometry": { "type": "LineString", "coordinates": [ [ 35.016271, 31.887695 ], [ 35.016253, 31.887745 ], [ 35.016238, 31.888256 ]]}
In the Synapse documentation I noticed that Synapse does not support geometry or geography types or array type.
Is there any alternative solution to store array in a column?