This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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
Hi @Khan, Muhammad Anza ,
Welcome to Microsoft Q&A Platform. Thanks for posting the query.
When I looked and tried the options in synapse documentation, I have observed the same limitation of not able to retrieve data through REST API from Synapse dedicated pools. I will reach out to Product team for more insights on this and will get back to you.
Thanks for your patience!
There is not a REST API for data access to a SQL Pool. Creating a simple Azure Function is the typical approach.
Hi, thank you for the response. So I would have to use a connection string to make the connection to the pool? Also, would it be the same for a serverless pool?
Hi,
Were you able to find a solution for this? I’m curious to know because I have a requirement and looking out for options to achieve this
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.
Hi, thank you for the response. So I would have to use a connection string to make the connection to the pool? Also, would it be the same for a serverless pool?
For both serverless and dedicated SQL Pool you can copy the connection string from the Manage blade under "SQL Pools" in the Synapse Portal.
Or in the Azure Portal you can get the "Dedicated SQL Endpoint", and "Serverless SQL Endpoint" from the Overview blade for the Synapse Workspace.
Thank you so much for the detailed response!
Thank you for your help with this!
Hi @Khan, Muhammad Anza ,
We have not received a response from you. Please suggest if below suggested approaches are helpful. Otherwise, let us know and we will continue to engage with you on the query.
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Hi @Khan, Muhammad Anza ,
We still have not heard back from you. Following up to check if below suggested approaches are helpful. Otherwise, let us know and we will continue to engage with you on the query.
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.
Sign in to comment