Skip to main content

external_service_principals

Creates, updates, deletes, gets or lists an external_service_principals resource.

Overview​

Nameexternal_service_principals
TypeResource
Iddatabricks_account.iamv2.external_service_principals

Fields​

The following fields are returned by SELECT queries:

NameDatatypeDescription
namestringThe resource name of the external service principal. The format depends on the API that returned it: - Account-scoped: accounts/{account_id}/external-service-principals/{external_service_principal_id} - Workspace-scoped: external-service-principals/{external_service_principal_id}
account_idstringThe parent account ID, from Databricks.
application_idstringApplication ID of the service principal, from the customer's IdP.
external_service_principal_idstringThe external ID of the service principal in the customer's IdP.
internal_idstringInternal servicePrincipalId of the service principal in Databricks.
display_namestringDisplay name of the service principal, from the customer's IdP.
account_sp_statusstringThe activity status of the service principal in the Databricks account. (ACTIVE, INACTIVE)

Methods​

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectaccount_id, external_service_principal_id, account_hostRetrieves an external service principal with the given external ID from the customer's IdP. If the

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
account_hoststringThe Databricks account console host. Selected by DATABRICKS_CLOUD (aws, azure or gcp; default aws), or set explicitly with DATABRICKS_ACCOUNT_HOST (bare host, no scheme). (default: accounts.cloud.databricks.com, x-stackQL-envVar: DATABRICKS_ACCOUNT_HOST, x-stackQL-envVarSelector: {"envVar":"DATABRICKS_CLOUD","default":"aws","values":{"aws":"accounts.cloud.databricks.com","azure":"accounts.azuredatabricks.net","gcp":"accounts.gcp.databricks.com"}})
account_idstringThe account_id segment of the name resource name (accounts/{account_id}/external-service-principals/{external_service_principal_id}). Required. The resource name of the external service principal. Format: accounts/{account_id}/external-service-principals/{external_service_principal_id}
external_service_principal_idstringThe external_service_principal_id segment of the name resource name (accounts/{account_id}/external-service-principals/{external_service_principal_id}). Required. The resource name of the external service principal. Format: accounts/{account_id}/external-service-principals/{external_service_principal_id}

SELECT examples​

Retrieves an external service principal with the given external ID from the customer's IdP. If the

SELECT
name,
account_id,
application_id,
external_service_principal_id,
internal_id,
display_name,
account_sp_status
FROM databricks_account.iamv2.external_service_principals
WHERE account_id = '{{ account_id }}' -- required
AND external_service_principal_id = '{{ external_service_principal_id }}' -- required
AND account_host = '{{ account_host }}' -- required
;