There is not a REST API for data access to a SQL Pool. Creating a simple Azure Function is the typical approach.
Is it possible to access data within a table in a dedicated SQL pool in Azure Synapse using REST API endpoints?
I am trying to see whether it is possible to access some data stored within a table in a dedicated SQL in Azure Synapse using REST API but I have not been able to figure much out. I checked the official docs at Microsoft and at most I have been able to query for a specific column within a table, not much more beyond that. I am wondering whether it is even possible to get data through the Azure Synapse REST API. Also, if that is not currently supported what alternatives that would allow me to access data via REST API that is in Synapse? Would appreciate any help.
Question originally posted to Stackoverflow: https://stackoverflow.com/questions/65254101/is-it-possible-to-access-data-within-a-table-in-a-dedicated-sql-pool-in-azure-sy
2 answers
Sort by: Most helpful
-
David Browne 111 Reputation points Microsoft Employee
2020-12-14T14:43:03.837+00:00 -
Jaryd 177 Reputation points
2020-12-12T05:11:08.3+00:00 Maybe you can create a function app to get the data from the sql pool. HTTPS trigger is essentially acting as an API.
You could connect the function app to API management to take things a step farther.
Just double check on pulling data from the sql pool. I know you can do a cosmosDB really... really easily.