How to store LineString or Point data type in Azure Synapse?

Question

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?

Answer 1

Hi Ze'ev Shavit,

Thank you for posting query in Microsoft Q&A Platform.

Yes you are right. At this moment synapse does not support geography or geometry types. You can consider using varbinary as workaround.

Below documentation, talks about unsupported datatypes and workarounds for them. Kindly check it once.

https://github.com/MicrosoftDocs/azure-docs/blob/main/articles/synapse-analytics/sql/develop-tables-data-types.md

Hope this helps.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.