list_secrets table function

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