Azure Databricks Tables
The Azure Databricks integration uses the following tables
Tables
AzureDatabricksAccountEntitlements
Contains configuration and metadata for Databricks account entitlements.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| EntitlementID | string | Unique entitlement identifier at the account scope. |
| AccountID | string | Databricks account ID associated with the entitlement. |
| Display | string | Friendly display label for the entitlement when present. |
| Primary | boolean | SCIM 'primary' flag when provided. |
| Type | string | SCIM type/category of the entitlement when provided. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksAccountGroups
Contains configuration and metadata for Databricks account groups.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks account group ID. |
| AccountID | string | Databricks account ID. |
| DisplayName | string | Human-readable group name. |
| ExternalID | string | External identifier for the group from the identity/source system (if provided). |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksAccountRoles
Contains configuration and metadata for Databricks account roles.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| RoleID | string | Role identifier for the assigned account-level role. |
| Type | string | Role type/name for the assignment (e.g., admins). |
| AccountID | string | Databricks account ID. |
| Display | string | Display label for the role. |
| Primary | boolean | Whether this role assignment is marked as primary. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksAccountServicePrincipals
Contains configuration and metadata for Databricks account service principals.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks service principal ID. |
| AccountID | string | Databricks account ID. |
| DisplayName | string | Service principal display name. |
| ApplicationID | string | Azure AD application (client) ID for the service principal. |
| ExternalID | string | External identifier for the service principal from the identity/source system (if provided). |
| Active | boolean | Whether the service principal is active. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksAccountUsers
Contains configuration and metadata for Databricks account users.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks user ID. |
| AccountID | string | Databricks account ID. |
| DisplayName | string | User’s display name. |
| UserName | string | User’s login/email (SCIM userName). |
| GivenName | string | User’s given (first) name. |
| FamilyName | string | User’s family (last) name. |
| ExternalID | string | External identifier for the user from the identity/source system (if provided). |
| Active | boolean | Whether the user is active. |
| EmailsJSON | string | Emails array for the user serialized as JSON. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksIntegrations
Stores integration records and configuration details for Databricks accounts and workspaces.
| Name | Type | Description |
|---|---|---|
| ID | integer | Internal integration record identifier. |
| Name | string | Human-readable integration name. |
| IsEnabled | boolean | Whether the integration is enabled. |
| AccountID | string | Databricks account ID associated with the integration. |
| WorkspaceInstance | string | Databricks workspace instance (URL or identifier). |
| ClientID | string | Client/application ID used by the integration. |
| MicrosoftEntraTenantID | string | Microsoft Entra (Azure AD) tenant ID. |
| CreatedDate | datetime | UTC timestamp when the integration was created. |
| ModifiedDate | datetime | UTC timestamp when the integration was last modified. |
| CreatedBy | string | Identifier for who/what created the integration record. |
| ModifiedBy | string | Identifier for who/what last modified the integration record. |
AzureDatabricksWorkspaceGroups
Contains configuration and metadata for Databricks workspace groups.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks workspace group ID. |
| WorkspaceID | string | Databricks workspace ID. |
| DisplayName | string | Human-readable workspace group name. |
| ExternalID | string | External identifier for the workspace group from the identity/source system (if provided). |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksWorkspaceRoles
Contains configuration and metadata for Databricks workspace roles.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| RoleID | string | Role identifier for the assigned workspace-level role. |
| Type | string | Role type/name for the assignment (e.g., admins). |
| WorkspaceID | string | Databricks workspace ID. |
| Display | string | Display label for the role. |
| Primary | boolean | Whether this role assignment is marked as primary. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksWorkspaceServicePrincipals
Contains configuration and metadata for Workspace Service Principals.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks workspace service principal ID. |
| WorkspaceID | string | Databricks workspace ID. |
| DisplayName | string | Service principal display name. |
| ApplicationID | string | Azure AD application (client) ID for the service principal. |
| ExternalID | string | External identifier for the service principal from the identity/source system (if provided). |
| Active | boolean | Whether the service principal is active. |
| BatchDate | datetime | The batch date the data was retrieved on. |
AzureDatabricksWorkspaceUsers
Contains configuration and metadata for Workspace Users.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks workspace user ID. |
| WorkspaceID | string | Databricks workspace ID. |
| DisplayName | string | User’s display name. |
| UserName | string | User’s login/email (SCIM userName). |
| GivenName | string | User’s given (first) name. |
| FamilyName | string | User’s family (last) name. |
| ExternalID | string | External identifier for the user from the identity/source system (if provided). |
| BatchDate | datetime | The batch date the data was retrieved on. |
| Active | boolean | Whether the user is active. |
| EmailsJSON | string | Emails array for the user serialized as JSON. |
AzureDatabricksWorkspaceEntitlements
Contains configuration and metadata for Databricks workspace entitlements.
| Name | Type | Description |
|---|---|---|
| ConfigID | integer | The configuration ID. |
| EntitlementID | string | Unique entitlement identifier at the workspace scope. |
| WorkspaceID | string | Databricks workspace ID associated with the entitlement. |
| Display | string | Friendly display label for the entitlement when present. |
| Primary | boolean | SCIM 'primary' flag when provided. |
| Type | string | SCIM type/category of the entitlement when provided. |
| BatchDate | datetime | The batch date the data was retrieved on. |
Bridge Tables
AzureDatabricksAccountGroups_AzureDatabricksAccountUsers
Maps Databricks account groups to account users.
| Name | Type | Description |
|---|---|---|
| GroupID | string | Databricks account group ID (FK). |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks user ID (FK). |
AzureDatabricksAccountRoles_AzureDatabricksAccountGroups
Maps Databricks account roles to account groups.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks account group ID (FK). |
AzureDatabricksAccountRoles_AzureDatabricksAccountServicePrincipals
Maps Databricks account roles to service principals.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks service principal ID (FK). |
AzureDatabricksAccountRoles_AzureDatabricksAccountUsers
Maps Databricks account roles to users.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks user ID (FK). |
AzureDatabricksWorkspaceGroups_AzureDatabricksWorkspaceUsers
Maps Databricks workspace groups to workspace users.
| Name | Type | Description |
|---|---|---|
| GroupID | string | Databricks workspace group ID (FK). |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks workspace user ID (FK). |
AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceGroups
Maps Databricks workspace roles to workspace groups.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks workspace group ID (FK). |
AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceServicePrincipals
Maps Databricks workspace roles to workspace service principals.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks workspace service principal ID (FK). |
AzureDatabricksWorkspaceRoles_AzureDatabricksWorkspaceUsers
Maps Databricks workspace roles to workspace users.
| Name | Type | Description |
|---|---|---|
| RoleID | string | Role identifier (FK). |
| Type | string | Role type/name for the assignment. |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks workspace user ID (FK). |
AzureDatabricksAccountEntitlements_AzureDatabricksAccountGroups
Maps Databricks account entitlements to account groups.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Account entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks account group ID (FK). |
AzureDatabricksAccountEntitlements_AzureDatabricksAccountServicePrincipals
Maps Databricks account entitlements to account service principals.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Account entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks account service principal ID (FK). |
AzureDatabricksAccountEntitlements_AzureDatabricksAccountUsers
Maps Databricks account entitlements to account users.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Account entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks user ID (FK). |
AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceGroups
Maps Databricks workspace entitlements to workspace groups.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Workspace entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| GroupID | string | Databricks workspace group ID (FK). |
AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceServicePrincipals
Maps Databricks workspace entitlements to workspace service principals.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Workspace entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| ServicePrincipalID | string | Databricks workspace service principal ID (FK). |
AzureDatabricksWorkspaceEntitlements_AzureDatabricksWorkspaceUsers
Maps Databricks workspace entitlements to workspace users.
| Name | Type | Description |
|---|---|---|
| EntitlementID | string | Workspace entitlement ID (FK). |
| ConfigID | integer | The configuration ID. |
| UserID | string | Databricks workspace user ID (FK). |
Updated about 1 year ago