Azure Synapse Workspace - Role and Permission to see SQL views and execute views

asked 2023-01-19T22:47:52.4933333+00:00
Jaimin Kansara 0 Reputation points

I have data lake storage account which has raw JSON files. I created Synapse Workspace and added SQL serverless database which has 2 different views on top of these JSON files. I as admin can query this views and able to see results in synapse workspace. now I want to add external users in Synapse workspace who are going to use this views and also execute queries to get data set. they will be using the result for further analysis in their domain.
Question is:

  1. which Synapse Role supports only list views and execute query ? FYI: I tried, Synapse User, Synapse Credential User and Synapse Compute Operator role but end user is not able to see SQL database created under Synapse workspace. so far Synapse Admin and Synapse SQL admin works. but in that case user can delete/modify views.
  2. Is synapse workspace is ever built to use like this? do you suggest to build additional interface on top of the views for end users and manage access and permission over there?

Let me know your thoughts..
Regards, Jaimin Kansara

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.
2,599 questions
{count} votes