Roles and permissions for Azure Data Factory - Azure Data Factory (2024)

  • Article

APPLIES TO: Roles and permissions for Azure Data Factory - Azure Data Factory (1)Azure Data Factory Roles and permissions for Azure Data Factory - Azure Data Factory (2)Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This article describes the roles required to create and manage Azure Data Factory resources, and the permissions granted by those roles.

Roles and requirements

To create Data Factory instances, the user account that you use to sign in to Azure must be a member of the contributor role, the owner role, or an administrator of the Azure subscription. To view the permissions that you have in the subscription, in the Azure portal, select your username in the upper-right corner, and then select My permissions. If you have access to multiple subscriptions, select the appropriate subscription.

To create and manage child resources for Data Factory - including datasets, linked services, pipelines, triggers, and integration runtimes - the following requirements are applicable:

For sample instructions about how to add a user to a role, see the Add roles article.

Set up permissions

After you create a Data Factory, you may want to let other users work with the data factory. To give this access to other users, you have to add them to the built-in Data Factory Contributor role on the Resource Group that contains the Data Factory.

Scope of the Data Factory Contributor role

Membership of the Data Factory Contributor role lets users do the following things:

  • Create, edit, and delete data factories and child resources including datasets, linked services, pipelines, triggers, and integration runtimes.
  • Deploy Resource Manager templates. Resource Manager deployment is the deployment method used by Data Factory in the Azure portal.
  • Manage App Insights alerts for a data factory.
  • Create support tickets.

For more info about this role, see Data Factory Contributor role.

Resource Manager template deployment

The Data Factory Contributor role, at the resource group level or above, lets users deploy Resource Manager templates. As a result, members of the role can use Resource Manager templates to deploy both data factories and their child resources, including datasets, linked services, pipelines, triggers, and integration runtimes. Membership in this role does not let the user create other resources.

Permissions on Azure Repos and GitHub are independent of Data Factory permissions. As a result, a user with repo permissions who is only a member of the Reader role can edit Data Factory child resources and commit changes to the repo, but can't publish these changes.

Important

Resource Manager template deployment with the Data Factory Contributor role does not elevate your permissions. For example, if you deploy a template that creates an Azure virtual machine, and you don't have permission to create virtual machines, the deployment fails with an authorization error.

In publish context, Microsoft.DataFactory/factories/write permission applies to following modes.

  • That permission is only required in Live mode when the customer modifies the global parameters.
  • That permission is always required in Git mode since every time after the customer publishes, the factory object with the last commit ID needs to be updated.

Custom scenarios and custom roles

Sometimes you may need to grant different access levels for different data factory users. For example:

  • You may need a group where users only have permissions on a specific data factory.
  • Or you may need a group where users can only monitor a data factory (or factories) but can't modify it.

You can achieve these custom scenarios by creating custom roles and assigning users to those roles. For more info about custom roles, see Custom roles in Azure.

Here are a few examples that demonstrate what you can achieve with custom roles:

  • Let a user create, edit, or delete any data factory in a resource group from the Azure portal.

    Assign the built-in Data Factory contributor role at the resource group level for the user. If you want to allow access to any data factory in a subscription, assign the role at the subscription level.

  • Let a user view (read) and monitor a data factory, but not edit or change it.

    Assign the built-in reader role on the data factory resource for the user.

  • Let a user edit a single data factory in the Azure portal.

    This scenario requires two role assignments.

    1. Assign the built-in contributor role at the data factory level.
    2. Create a custom role with the permission Microsoft.Resources/deployments/. Assign this custom role to the user at resource group level.
  • Let a user be able to test connection in a linked service or preview data in a dataset

    Create a custom role with permissions for the following actions: Microsoft.DataFactory/factories/getFeatureValue/read and Microsoft.DataFactory/factories/getDataPlaneAccess/action. Assign this custom role on the data factory resource for the user.

  • Let a user update a data factory from PowerShell or the SDK, but not in the Azure portal.

    Assign the built-in contributor role on the data factory resource for the user. This role lets the user see the resources in the Azure portal, but the user can't access the Publish and Publish All buttons.

Related content

  • Learn more about roles in Azure - Understand role definitions

  • Learn more about the Data Factory contributor role - Data Factory Contributor role.

Roles and permissions for Azure Data Factory - Azure Data Factory (2024)

FAQs

What is the role of the Azure Data Factory? ›

Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale.

What permissions are needed to assign roles in Azure? ›

Prerequisites. To assign Azure roles, you must have: Microsoft.Authorization/roleAssignments/write permissions, such as Role Based Access Control Administrator or User Access Administrator.

How do I give Azure Data Factory access? ›

Let a user create, edit, or delete any data factory in a resource group from the Azure portal. Assign the built-in Data Factory contributor role at the resource group level for the user. If you want to allow access to any data factory in a subscription, assign the role at the subscription level.

What is role based access control in ADF? ›

Azure role-based access control (Azure RBAC) helps you manage who has access to Azure resources, what they can do with those resources, and what areas they have access to. Azure RBAC is an authorization system built on Azure Resource Manager that provides fine-grained access management to Azure resources.

What are roles in Azure and why do we use them? ›

A role definition is a collection of permissions that can be performed, such as read, write, and delete. It's typically just called a role. Azure role-based access control (Azure RBAC) has over 120 built-in roles or you can create your own custom roles.

What are the key components of Azure Data Factory? ›

The key components of ADF include pipelines, activities, datasets, linked services, triggers, and integration runtimes, which allow for efficient data integration, transformation, and movement processes.

What is the difference between assigned roles and Azure role assignments? ›

Assigned roles are Azure AD administrator roles, for accessing Azure AD and other Microsoft 365 platforms such as Exchange and SharePoint. Azure role assignments (may also be referred to as Azure RBAC roles) are for accessing Azure resources such as virtual machines, storage accounts, subscriptions, etc.

What is the difference between RBAC and ad roles? ›

RBAC focuses on resource-centric access control within Azure, whereas Azure AD roles are used in the Azure AD tenant for identity and access management tasks.

How do I enable Azure Data Factory? ›

Ensure that Allow access to Azure services is turned ON for your SQL Server so that Data Factory can write data to your SQL Server. To verify and turn on this setting, go to logical SQL server > Overview > Set server firewall> set the Allow access to Azure services option to ON.

How do I assign managed identity to data factory? ›

Select Add > Add role assignment. On the Members tab, select Managed identity, and then select Select members. Select your Azure subscription. Under System-assigned managed identity, select Data Factory, and then select a data factory.

How do I check my Azure Data Factory? ›

You can monitor all of your Data Factory pipeline runs natively in Azure Data Factory Studio. To open the monitoring experience, select Launch Studio from your Data Factory page in the Azure portal, and in Azure Data Factory Studio, select Monitor from the left menu.

What is the primary role of Azure data Factory? ›

Data Factory provides a data integration and transformation layer that works across your digital transformation initiatives. Enable citizen integrators and data engineers to drive business and IT-led Analytics/BI. Prepare data, construct ETL and ELT processes, and orchestrate and monitor pipelines code-free.

What is the difference between RBAC and permissions? ›

Role-based access controls grant access based on an employee's role in a system. On the other hand, permission-based access controls grant access based on each individual employee. While these systems may sound similar, they have key differences, benefits, and drawbacks.

What is a role in role-based access control? ›

Essentially, a role is a collection of permissions that you can apply to users. Using roles makes it easier to add, remove, and adjust permissions than assigning permissions to users individually. As your user base increases in scale and complexity, roles become particularly useful.

Which role is most likely to use Azure Data Factory? ›

Expert-Verified Answer. The role most likely to use Azure Data Factory for defining a data pipeline for an ETL process is: Data Engineer.So option b"data Engineer" is correct.

Why do you need Azure Data Factory? ›

Data Factory provides a data integration and transformation layer that works across your digital transformation initiatives. Enable citizen integrators and data engineers to drive business and IT-led Analytics/BI. Prepare data, construct ETL and ELT processes, and orchestrate and monitor pipelines code-free.

What is Azure function in Azure Data Factory? ›

The Azure Function activity allows you to run Azure Functions in an Azure Data Factory or Synapse pipeline. To run an Azure Function, you must create a linked service connection. Then you can use the linked service with an activity that specifies the Azure Function that you plan to execute.

What does Azure Data Factory include? ›

Azure Data Factory key components
  • Datasets represent data structures within the data stores. An input dataset represents the input for an activity in the pipeline. ...
  • A pipeline is a group of activities. ...
  • Activities define the actions to perform on your data.

Top Articles
Cook to a Safe Minimum Internal Temperature
Top 10 Tips For Solving A Marketing Case Study Case Solution And Analysis, HBR Case Study Solution & Analysis of Harvard Case Studies
Skigebiet Portillo - Skiurlaub - Skifahren - Testberichte
Kostner Wingback Bed
His Lost Lycan Luna Chapter 5
Archived Obituaries
30 Insanely Useful Websites You Probably Don't Know About
Mr Tire Prince Frederick Md 20678
His Lost Lycan Luna Chapter 5
Craigslist Dog Sitter
Osrs But Damage
My.doculivery.com/Crowncork
Student Rating Of Teaching Umn
Planets Visible Tonight Virginia
World Cup Soccer Wiki
Charmeck Arrest Inquiry
Socket Exception Dunkin
Nalley Tartar Sauce
Unlv Mid Semester Classes
History of Osceola County
Napa Autocare Locator
라이키 유출
Ge-Tracker Bond
Why do rebates take so long to process?
1 Filmy4Wap In
Used Patio Furniture - Craigslist
Pioneer Library Overdrive
Wat is een hickmann?
800-695-2780
Table To Formula Calculator
They Cloned Tyrone Showtimes Near Showbiz Cinemas - Kingwood
Craigslist Auburn Al
Possum Exam Fallout 76
Advance Auto Parts Stock Price | AAP Stock Quote, News, and History | Markets Insider
The value of R in SI units is _____?
Gr86 Forums
Truis Bank Near Me
Powerball lottery winning numbers for Saturday, September 7. $112 million jackpot
Mistress Elizabeth Nyc
Bitchinbubba Face
9781644854013
Hingham Police Scanner Wicked Local
Craigslist Com Panama City Fl
Best Restaurants West Bend
Actor and beloved baritone James Earl Jones dies at 93
Tunica Inmate Roster Release
Despacito Justin Bieber Lyrics
Todd Gutner Salary
Alba Baptista Bikini, Ethnicity, Marriage, Wedding, Father, Shower, Nazi
Europa Universalis 4: Army Composition Guide
Definition of WMT
Buildapc Deals
Latest Posts
Article information

Author: Pres. Lawanda Wiegand

Last Updated:

Views: 6167

Rating: 4 / 5 (71 voted)

Reviews: 86% of readers found this page helpful

Author information

Name: Pres. Lawanda Wiegand

Birthday: 1993-01-10

Address: Suite 391 6963 Ullrich Shore, Bellefort, WI 01350-7893

Phone: +6806610432415

Job: Dynamic Manufacturing Assistant

Hobby: amateur radio, Taekwondo, Wood carving, Parkour, Skateboarding, Running, Rafting

Introduction: My name is Pres. Lawanda Wiegand, I am a inquisitive, helpful, glamorous, cheerful, open, clever, innocent person who loves writing and wants to share my knowledge and understanding with you.