Azure Synapse to expose REST API with no code

Question

Azure Synapse to expose REST API with no code

Rajshekar Mani 6

Hello,

We are looking at creating a datalakehouse and expose data to our consumers.

We will share data via views/data share but we also wanted to expose data via REST API against SQL pools with no-code. Do we have any such option on Azure? We do not want to create REST api and maintain it for rest of the lifetime, hence looking for alternatives if any. Please advice

Thanks in advance.

1 answer

Your answer

Answer 1

Nguyen Yann 26

I had the same request to expose data from SYNAPSE in a REST API. I did not find some direct solution without an azure web app or function app. As I'm not a code developer, The simpliest way for me was to use a function app with this method: https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql?tabs=in-process%2Cextensionv4&pivots=programming-language-csharp

The code generated is minimal and quite readable for a non developer. I agree that this common request should be available by some way in the Synapse sql pool. You need to install a bunch of development software (VS2022, VS code,..) on your machine for a simple use case.

Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator

2023-06-12T23:14:36.63+00:00

Thank you Nguyen Yann

Hello Rajshekar Mani,

I am checking to see if the above answer is helpful.

if this answers your question, please consider accepting the answer by hitting the Accept answer and up-vote as it helps the community look for answers to similar questions.

Share via

Azure Synapse to expose REST API with no code

1 answer

Your answer