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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for