list_secrets
table function
Applies to: Databricks SQL preview Databricks Runtime 11.3 LTS and above
Returns the keys which the user is authorized to see from Databricks secret service.
Syntax
list_secrets()
Arguments
This function takes no arguments.
Returns
A table with two columns:
scope STRING NOT NULL
: The namespace of the key.key STYRING 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
> 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