Is it possible to access data within a table in a dedicated SQL pool in Azure Synapse using REST API endpoints?

Question

Is it possible to access data within a table in a dedicated SQL pool in Azure Synapse using REST API endpoints?

Khan, Muhammad Anza 1

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

HarithaMaddi-MSFT 10,151 Reputation points

2020-12-14T09:19:41.173+00:00

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!
Khan, Muhammad Anza 1 Reputation point

2020-12-14T20:02:16.197+00:00

Thank you for your help with this!
HarithaMaddi-MSFT 10,151 Reputation points

2020-12-22T12:34:44.617+00:00

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.
HarithaMaddi-MSFT 10,151 Reputation points

2020-12-24T08:55:13.72+00:00

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.

2 answers

Your answer

HarithaMaddi-MSFT 10,151 Reputation points

2020-12-14T09:19:41.173+00:00

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!
Khan, Muhammad Anza 1 Reputation point

2020-12-14T20:02:16.197+00:00

Thank you for your help with this!
HarithaMaddi-MSFT 10,151 Reputation points

2020-12-22T12:34:44.617+00:00

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.
HarithaMaddi-MSFT 10,151 Reputation points

2020-12-24T08:55:13.72+00:00

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.

Answer 1

David Browne 111 Microsoft Employee

There is not a REST API for data access to a SQL Pool. Creating a simple Azure Function is the typical approach.

Khan, Muhammad Anza 1 Reputation point

2020-12-14T16:45:16.537+00:00

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?
Vivek Komarla Bhaskar 956 Reputation points

2022-11-28T01:07:53.247+00:00

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

Answer 2

Jaryd 182

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.

Khan, Muhammad Anza 1 Reputation point

2020-12-14T16:45:36.287+00:00

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?
David Browne 111 Reputation points Microsoft Employee

2020-12-14T17:15:55.42+00:00

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.
Khan, Muhammad Anza 1 Reputation point

2020-12-14T20:01:53.233+00:00

Thank you so much for the detailed response!

Share via

Is it possible to access data within a table in a dedicated SQL pool in Azure Synapse using REST API endpoints?

2 answers

Your answer