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 Reputation point
2020-12-11T23:08:22.297+00:00

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

Azure Synapse Analytics
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.
4,696 questions
{count} votes

2 answers

Sort by: Most helpful
  1. David Browne 111 Reputation points Microsoft Employee
    2020-12-14T14:43:03.837+00:00

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

    1 person found this answer helpful.

  2. 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.