Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,375 questions
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi @Serverless SQL ,
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 Learn – 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 Learn
- Geospatial big data performance tests with Cosmos DB and data enrichment with Azure Synapse Analytics | by Remko de Lange | Towards Data Science
- 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 answerandup-voteif 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.