list_secrets table function

Applies to: check marked yes Databricks SQL preview check marked yes 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