Skip to main content

service_principals

Creates, updates, deletes, gets or lists a service_principals resource.

Overview

Nameservice_principals
TypeResource
Iddatabricks_account.iam.service_principals

Fields

The following fields are returned by SELECT queries:

Service principal information was returned successfully.

NameDatatypeDescription
idstring
activeboolean
applicationIdstring
displayNamestring
externalIdstring
rolesarray

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectGets the details for a single service principal define in the Databricks account.
listselectGets the set of service principals associated with a Databricks account.
createinsertCreates a new service principal in the Databricks account.
patchupdatePartially updates the details of a single service principal in the Databricks account.
updatereplaceUpdates the details of a single service principal.
deletedeleteDelete a single service principal in the Databricks account.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription

SELECT examples

Gets the details for a single service principal define in the Databricks account.

SELECT
id,
active,
applicationId,
displayName,
externalId,
roles
FROM databricks_account.iam.service_principals;

INSERT examples

Creates a new service principal in the Databricks account.

INSERT INTO databricks_account.iam.service_principals (
data__id,
data__applicationId,
data__displayName,
data__externalId,
data__active,
data__roles
)
SELECT
{{ id }},
'{{ applicationId }}',
'{{ displayName }}',
'{{ externalId }}',
{{ active }},
'{{ roles }}'
;

UPDATE examples

Partially updates the details of a single service principal in the Databricks account.

UPDATE databricks_account.iam.service_principals
SET
data__schemas = '{{ schemas }}',
data__Operations = '{{ Operations }}'
WHERE
;

REPLACE examples

Updates the details of a single service principal.

REPLACE databricks_account.iam.service_principals
SET
data__id = {{ id }},
data__applicationId = '{{ applicationId }}',
data__displayName = '{{ displayName }}',
data__externalId = '{{ externalId }}',
data__active = {{ active }},
data__roles = '{{ roles }}'
WHERE
;

DELETE examples

Delete a single service principal in the Databricks account.

DELETE FROM databricks_account.iam.service_principals;