Access Control

Overview

dbt Cloud administrators can use dbt Cloud's permissioning model to control user-level access in a dbt Cloud account. This access control comes in two flavors: License-based and Role-based.

  • License-based Access Controls: User are configured with account-wide license types. These licenses control the specific parts of the dbt Cloud application that a given user can access.
  • Role-based Access Control (RBAC): Users are assigned to groups that have specific permissions on specific projects or the entire account. A user may be a member of multiple groups, and those groups may have permissions on multiple projects.

License-based access control

Each user on an account is assigned a license type when the user is first invited to a given account. This license type may change over time, but a user can only have one type of license at any given time.

A user's license type controls the features in dbt Cloud that the user is able to access. dbt Cloud's two license types are:

  • Read Only
  • Developer

For more information on these license types, see Seats & Users. At a high-level, Developers may be granted any permissions, whereas Read Only users will have read-only permissions applied to all dbt Cloud resources regardless of the role-based permissions that the user is assigned.

Role-based access control

dbt Cloud Enterprise

Role-based access control is a feature of the dbt Cloud Enterprise plan

Role-based access control allows for fine-grained permissioning in the dbt Cloud application. With role-based access control, users can be assigned varying permissions to different projects within a dbt Cloud account. For teams on the Enterprise tier, role-based permissions can be generated dynamically from configurations in an Identity Provider.

Role-based permissions are applied to groups and pertain to projects. The assignable permissions themselves are granted via permission sets.

Groups

A group is a collection of users. Users may belong to multiple groups. Members of a group inherit any permissions applied to the group itself.

Users can be added to a dbt Cloud group based on their group memberships in the configured Identity Provider for the account. In this way, dbt Cloud administrators can manage access to dbt Cloud resources via identity management software like Azure AD, Okta, or GSuite. See SSO Mappings below for more information.

You can view the groups in your account or create new groups from the Team > Groups page in your Account Settings.

Viewing a list of groups in the Account Settings page.

Viewing a list of groups in the Account Settings page.

SSO Mappings

SSO Mappings connect Identity Provider (IdP) group membership to dbt Cloud group membership. When a user logs into dbt Cloud via a supported identity provider, their IdP group memberships are synced with dbt Cloud. Upon logging in successfully, the user's group memberships (and therefore, permissions) are adjusted accordingly within dbt Cloud automatically.

Creating SSO Mappings

While dbt Cloud supports mapping multiple IdP groups to a single dbt Cloud group, we recommend using a 1:1 mapping to make administration as simple as possible. Consider using the same name for your dbt Cloud groups and your IdP groups.

Users in the 'data-team-dbt-analysts' or 'data-team-dbt-admins' groups will be assigned to the Analysts dbt Cloud group when they log into dbt Cloud

Users in the 'data-team-dbt-analysts' or 'data-team-dbt-admins' groups will be assigned to the Analysts dbt Cloud group when they log into dbt Cloud

Permission Sets

Permission sets are predefined collections of granular permissions. Permission sets combine low-level permission grants into high-level roles that can be assigned to groups. Some examples of existing permission sets are:

  • Account Admin
  • Git Admin
  • Job Admin
  • Job Viewer
  • ...and more

For a full list of enterprise permission sets, see Enterprise Permissions. These permission sets are available for assignment to groups and control the ability for users in these groups to take specific actions in the dbt Cloud application.

In the following example, the Analysts group is configured with the Analyst permission set on All Projects and the Job Admin permission set on the BQ test project.

Configuring permissions for the Analysts group

Configuring permissions for the Analysts group

FAQs

  • When are IdP group memberships updated? Group memberships are updated every time a user logs into dbt Cloud via a supported SSO provider. If you've changed group memberships in your identity provider or dbt Cloud, ask your users to log back into dbt Cloud for these group memberships to be synchronized.