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
SQL
> 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