Skip to main content

credentials

Operations on a credentials resource.

Overview

Namecredentials
TypeResource
Iddatabricks_account.provisioning.credentials

Fields

NameDatatype
account_idstring
aws_credentialsobject
creation_timeinteger
credentials_idstring
credentials_namestring

Methods

NameAccessible byRequired ParamsDescription
getSELECTaccount_id, credentials_idGets a Databricks credential configuration object for an account, both specified by ID.
listSELECTaccount_idGets all Databricks credential configurations associated with an account specified by ID.
createINSERTaccount_idCreates a Databricks credential configuration that represents cloud cross-account credentials for a specified account. Databricks uses this to set up network infrastructure properly to host Databricks clusters. For your AWS IAM role, you need to trust the External ID (the Databricks Account API account ID) in the returned credential object, and configure the required access policy.
deleteDELETEaccount_id, credentials_idDeletes a Databricks credential configuration object for an account, both specified by ID. You cannot delete a credential that is associated with any workspace.

SELECT examples

SELECT
account_id,
aws_credentials,
creation_time,
credentials_id,
credentials_name
FROM databricks_account.provisioning.credentials
WHERE account_id = '{{ account_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new credentials resource.

/*+ create */
INSERT INTO databricks_account.provisioning.credentials (
account_id,
data__credentials_name,
data__aws_credentials
)
SELECT
'{{ account_id }}',
'{{ credentials_name }}',
'{{ aws_credentials }}'
;

DELETE example

Deletes a credentials resource.

/*+ delete */
DELETE FROM databricks_account.provisioning.credentials
WHERE account_id = '{{ account_id }}' AND
credentials_id = '{{ credentials_id }}';