How can I implement access control on azure synapse analytics objects(pipeline, notebooks etc)?

Apurva Tiwari 40 Reputation points

Scenario: I have pipelines and Notebooks stored in Azure Synapse Analytics workspace. Now I want to give access to the Synapse workspace to different departments but only to the dedicated pipelines and codes.

As I can only implement access control over the whole workspace but not at the object level I tried to switch to ADF where I controlled table access to implement pipeline access control in ADF but being able to view and access all notebooks from ADF is still a challenge.

Is there any way I can achieve 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.
4,679 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,161 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Nandan Hegde 31,436 Reputation points MVP

    Unfortunately, based on my understanding; providing granular access at pipeline level is possible within ADF but it is not possible in synapse. So in case if you want specific depts to have specific access within some pipelines, you would have to make them within ADF only and not synapse.

    Can you specify what do you mean by view and access all notebooks from ADF is still a challenge??

    1 person found this answer helpful.