Azure Databricks Tables

The Azure Databricks integration uses the following tables

Tables

AzureDatabricksAccountEntitlements

Contains configuration and metadata for Databricks account entitlements.

NameTypeDescription
ConfigIDintegerThe configuration ID.
EntitlementIDstringUnique entitlement identifier at the account scope.
AccountIDstringDatabricks account ID associated with the entitlement.
DisplaystringFriendly display label for the entitlement when present.
PrimarybooleanSCIM 'primary' flag when provided.
TypestringSCIM type/category of the entitlement when provided.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksAccountGroups

Contains configuration and metadata for Databricks account groups.

NameTypeDescription
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks account group ID.
AccountIDstringDatabricks account ID.
DisplayNamestringHuman-readable group name.
ExternalIDstringExternal identifier for the group from the identity/source system (if provided).
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksAccountRoles

Contains configuration and metadata for Databricks account roles.

NameTypeDescription
ConfigIDintegerThe configuration ID.
RoleIDstringRole identifier for the assigned account-level role.
TypestringRole type/name for the assignment (e.g., admins).
AccountIDstringDatabricks account ID.
DisplaystringDisplay label for the role.
PrimarybooleanWhether this role assignment is marked as primary.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksAccountServicePrincipals

Contains configuration and metadata for Databricks account service principals.

NameTypeDescription
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks service principal ID.
AccountIDstringDatabricks account ID.
DisplayNamestringService principal display name.
ApplicationIDstringAzure AD application (client) ID for the service principal.
ExternalIDstringExternal identifier for the service principal from the identity/source system (if provided).
ActivebooleanWhether the service principal is active.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksAccountUsers

Contains configuration and metadata for Databricks account users.

NameTypeDescription
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks user ID.
AccountIDstringDatabricks account ID.
DisplayNamestringUser’s display name.
UserNamestringUser’s login/email (SCIM userName).
GivenNamestringUser’s given (first) name.
FamilyNamestringUser’s family (last) name.
ExternalIDstringExternal identifier for the user from the identity/source system (if provided).
ActivebooleanWhether the user is active.
EmailsJSONstringEmails array for the user serialized as JSON.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksIntegrations

Stores integration records and configuration details for Databricks accounts and workspaces.

NameTypeDescription
IDintegerInternal integration record identifier.
NamestringHuman-readable integration name.
IsEnabledbooleanWhether the integration is enabled.
AccountIDstringDatabricks account ID associated with the integration.
WorkspaceInstancestringDatabricks workspace instance (URL or identifier).
ClientIDstringClient/application ID used by the integration.
MicrosoftEntraTenantIDstringMicrosoft Entra (Azure AD) tenant ID.
CreatedDatedatetimeUTC timestamp when the integration was created.
ModifiedDatedatetimeUTC timestamp when the integration was last modified.
CreatedBystringIdentifier for who/what created the integration record.
ModifiedBystringIdentifier for who/what last modified the integration record.

AzureDatabricksWorkspaceGroups

Contains configuration and metadata for Databricks workspace groups.

NameTypeDescription
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks workspace group ID.
WorkspaceIDstringDatabricks workspace ID.
DisplayNamestringHuman-readable workspace group name.
ExternalIDstringExternal identifier for the workspace group from the identity/source system (if provided).
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksWorkspaceRoles

Contains configuration and metadata for Databricks workspace roles.

NameTypeDescription
ConfigIDintegerThe configuration ID.
RoleIDstringRole identifier for the assigned workspace-level role.
TypestringRole type/name for the assignment (e.g., admins).
WorkspaceIDstringDatabricks workspace ID.
DisplaystringDisplay label for the role.
PrimarybooleanWhether this role assignment is marked as primary.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksWorkspaceServicePrincipals

Contains configuration and metadata for Workspace Service Principals.

NameTypeDescription
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks workspace service principal ID.
WorkspaceIDstringDatabricks workspace ID.
DisplayNamestringService principal display name.
ApplicationIDstringAzure AD application (client) ID for the service principal.
ExternalIDstringExternal identifier for the service principal from the identity/source system (if provided).
ActivebooleanWhether the service principal is active.
BatchDatedatetimeThe batch date the data was retrieved on.

AzureDatabricksWorkspaceUsers

Contains configuration and metadata for Workspace Users.

NameTypeDescription
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks workspace user ID.
WorkspaceIDstringDatabricks workspace ID.
DisplayNamestringUser’s display name.
UserNamestringUser’s login/email (SCIM userName).
GivenNamestringUser’s given (first) name.
FamilyNamestringUser’s family (last) name.
ExternalIDstringExternal identifier for the user from the identity/source system (if provided).
BatchDatedatetimeThe batch date the data was retrieved on.
ActivebooleanWhether the user is active.
EmailsJSONstringEmails array for the user serialized as JSON.

AzureDatabricksWorkspaceEntitlements

Contains configuration and metadata for Databricks workspace entitlements.

NameTypeDescription
ConfigIDintegerThe configuration ID.
EntitlementIDstringUnique entitlement identifier at the workspace scope.
WorkspaceIDstringDatabricks workspace ID associated with the entitlement.
DisplaystringFriendly display label for the entitlement when present.
PrimarybooleanSCIM 'primary' flag when provided.
TypestringSCIM type/category of the entitlement when provided.
BatchDatedatetimeThe batch date the data was retrieved on.

Bridge Tables

AzureDatabricksAccountGroups_AzureDatabricksAccountUsers

Maps Databricks account groups to account users.

NameTypeDescription
GroupIDstringDatabricks account group ID (FK).
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks user ID (FK).

AzureDatabricksAccountRoles_AzureDatabricksAccountGroups

Maps Databricks account roles to account groups.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks account group ID (FK).

AzureDatabricksAccountRoles_AzureDatabricksAccountServicePrincipals

Maps Databricks account roles to service principals.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks service principal ID (FK).

AzureDatabricksAccountRoles_AzureDatabricksAccountUsers

Maps Databricks account roles to users.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks user ID (FK).

AzureDatabricksWorkspaceGroups_AzureDatabricksWorkspaceUsers

Maps Databricks workspace groups to workspace users.

NameTypeDescription
GroupIDstringDatabricks workspace group ID (FK).
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks workspace user ID (FK).

AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceGroups

Maps Databricks workspace roles to workspace groups.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks workspace group ID (FK).

AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceServicePrincipals

Maps Databricks workspace roles to workspace service principals.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks workspace service principal ID (FK).

AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceUsers

Maps Databricks workspace roles to workspace users.

NameTypeDescription
RoleIDstringRole identifier (FK).
TypestringRole type/name for the assignment.
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks workspace user ID (FK).

AzureDatabricksAccountEntitlements_AzureDatabricksAccountGroups

Maps Databricks account entitlements to account groups.

NameTypeDescription
EntitlementIDstringAccount entitlement ID (FK).
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks account group ID (FK).

AzureDatabricksAccountEntitlements_AzureDatabricksAccountServicePrincipals

Maps Databricks account entitlements to account service principals.

NameTypeDescription
EntitlementIDstringAccount entitlement ID (FK).
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks account service principal ID (FK).

AzureDatabricksAccountEntitlements_AzureDatabricksAccountUsers

Maps Databricks account entitlements to account users.

NameTypeDescription
EntitlementIDstringAccount entitlement ID (FK).
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks user ID (FK).

AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceGroups

Maps Databricks workspace entitlements to workspace groups.

NameTypeDescription
EntitlementIDstringWorkspace entitlement ID (FK).
ConfigIDintegerThe configuration ID.
GroupIDstringDatabricks workspace group ID (FK).

AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceServicePrincipals

Maps Databricks workspace entitlements to workspace service principals.

NameTypeDescription
EntitlementIDstringWorkspace entitlement ID (FK).
ConfigIDintegerThe configuration ID.
ServicePrincipalIDstringDatabricks workspace service principal ID (FK).

AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceUsers

Maps Databricks workspace entitlements to workspace users.

NameTypeDescription
EntitlementIDstringWorkspace entitlement ID (FK).
ConfigIDintegerThe configuration ID.
UserIDstringDatabricks workspace user ID (FK).

Did this page help you?