Hi Team, I have the below requirement I want to expose the URL of Azure Synapse SQL Pool to users. I dont want to use POWER BI I have a data lake. Created a pipeline that pulls data from the Data lake to the SQL Pool table. Now I want to provide a report or API access where is user can filter, download the report in Excel, and query over it.

Hello @ Amit Kumar Did you try to use Azure Data Studio or any other SQL client tool to connect to the SQL Pool and query the data? Using Azure Data Share you can invite someone to access the data and then they have to load the data to a target database and then again it will be the user's responsibility to build any reporting on top of that Dataset! I am afraid to say that there are no direct methods available to access Synapse SQL Pool, as I have seen REST APIs to manage the Pool. But we might have to create custom application in this scenario.

Expose URL to view data of Azure Synapse SQL Pool

Amit Kumar 0

Hi Team,

I have the below requirement

I want to expose the URL of Azure Synapse SQL Pool to users.

I dont want to use POWER BI

I have a data lake.
Created a pipeline that pulls data from the Data lake to the SQL Pool table.
Now I want to provide a report or API access where is user can filter, download the report in Excel, and query over it.

Amit Kumar 0 Reputation points

2023-09-12T03:29:43.7833333+00:00

No I dont want that, I understand that we can connect to azure data studio or SSMS tool but I want some kind of reporting where in we can expose API(ENDPOINT) to users and user can play around that url like querying their own data, donwload excel etc.
QuantumCache 20,266 Reputation points

2023-09-12T14:19:45.58+00:00

Hello @Amit Kumar,

Did you check the capability of Azure Data Share?
Amit Kumar 0 Reputation points

2023-09-13T10:17:49.12+00:00

Thanks for replying,

could you tell can we expose a public URL with Azure data Share, wherein any user can access the view, Also, can the user query the data ?
QuantumCache 20,266 Reputation points

2023-09-15T04:15:35.1433333+00:00

could you tell can we expose a public URL with Azure data Share, wherein any user can access the view, Also, can the user query the data ?

Using Azure Data Share you can invite someone to access the data and then they have to load the data to a target database and then again it will be the user's responsibility to build any reporting on top of that Dataset!

I am afraid to say that there are no direct methods available to access Synapse SQL Pool, as I have seen REST APIs to manage the Pool. But we might have to create custom application in this scenario.

2 answers

QuantumCache 20,266 Reputation points

2023-09-11T23:35:27.55+00:00

Hello @Amit Kumar

Did you try to use Azure Data Studio or any other SQL client tool to connect to the SQL Pool and query the data?

Using Azure Data Share you can invite someone to access the data and then they have to load the data to a target database and then again it will be the user's responsibility to build any reporting on top of that Dataset!

I am afraid to say that there are no direct methods available to access Synapse SQL Pool, as I have seen REST APIs to manage the Pool. But we might have to create custom application in this scenario.
Please sign in to rate this answer.

1 person found this answer helpful.
QuantumCache 20,266 Reputation points

2023-09-18T18:30:45.46+00:00

Hello @Amit Kumar Just checking if we are still connected on this discussion? Please let me know if we can close this case?
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Amit Kumar 0 Reputation points

2023-09-21T10:00:10.28+00:00

sure thank you
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Expose URL to view data of Azure Synapse SQL Pool

2 answers

Your answer