Hi,
Is there any indication whether Geo-spatial data types will be supported within Azure Synapse Analytics Dedicated SQL Pools?
Thanks
Hi,
Is there any indication whether Geo-spatial data types will be supported within Azure Synapse Analytics Dedicated SQL Pools?
Thanks
Hi @serverlesssql,
Thanks for using Microsoft Q&A forum and posting your query.
We are reaching out to internal team to get information about the ask and will get back to you as soon as we have an update.
Thank you
Hi @serverlesssql,
As per conversation with internal teams it is not in the short term roadmap but they are still reviewing the feedbacks. If you have any additional suggestions/feedback I would recommend you to please log your feedback as per the guidance provided in this article: How to send ideas and suggestions to the Synapse team - Microsoft Tech Community
But here are few workarounds which you can try:
Setup an Azure SQL Database serverless so you will not get charged for compute except when it runs and then setup elastic queries - Below is an example on how to set it up. Using Elastic Query to Support SQL Spatial in Azure SQL DW – Mr. Fox SQL (wordpress.com)
A second option is to set Azure Cosmos Database Geospatial and GeoJSON location data in Azure Cosmos DB | Microsoft Docs – You can set opt-in for the free tier of cosmos db so you will not get charged for it (it supports up to 1000 RU) which is very good – After you do so you can simply use the synapse link to access the data Azure Synapse Link for Azure Cosmos DB, benefits, and when to use it | Microsoft Docs
A third option is to create an external table in Azure SQL Database serverless and connect to synapse - Here is an example Azure SQL | Read Data Lake files using Synapse SQL external tables (microsoft.com)
A fourth option is using Synapse Spark to read these tables analyze and store it back into ADLS gen2 which is all part of Synapse.
The most popular workarounds are #3 and #4.
Hope this info helps.
Please accept an answer and up-vote if it helps. Original posters help the community find answers faster by identifying the correct answer. Here is how.
Want a reminder to come back and check responses? Here is how to subscribe to a notification.
Hi @serverlesssql,
Just checking in to see if the above suggestion was helpful. If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
Hi @serverlesssql,
We still have not heard back from you. Just wanted to check if the above information was helpful? If it answers your query, please do click “Accept Answer” and/or Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.
6 people are following this question.