list_secrets
table function
Applies to: Databricks SQL preview
Databricks Runtime 11.3 LTS and above
Returns all keys in all scopes or one specific scope the user is authorized to see from Databricks secret service.
Syntax
list_secrets ( [ scopeStr ] )
Arguments
Applies to: Databricks SQL preview
Databricks Runtime 15.3 and above
- scopeStr: The scope within which to search. If not provided, all scopes are returned.
Returns
A table with two columns:
scope STRING NOT NULL
: The namespace of the key.key STRING NOT NULL
: The key itself
To return the secret values for specific keys use secret(scope, key)
.
Error conditions
INVALID_SECRET_LOOKUP.LIST_SECRETS_FAILED
: Databricks secret service is not available.
Examples
> SELECT * FROM list_secrets();
scope key
------------ ---------------
secrets.r.us theAnswerToLife
openSecrets psst
> SELECT * FROM list_secrets('secrets.r.us');
scope key
------------ ---------------
secrets.r.us theAnswerToLife
> SELECT secret('secrets.r.us', 'theAnswerToLife');
fourtyTwo
Related functions
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for