Expose URL to view data of Azure Synapse SQL Pool

Amit Kumar 0 Reputation points

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

  1. I have a data lake.
  2. Created a pipeline that pulls data from the Data lake to the SQL Pool table.
  3. Now I want to provide a report or API access where is user can filter, download the report in Excel, and query over it.
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.
3,563 questions
{count} votes

2 answers

Sort by: Most helpful
  1. SatishBoddu-MSFT 18,611 Reputation points

    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.

    1 person found this answer helpful.

  2. Amit Kumar 0 Reputation points

    sure thank you

    0 comments No comments