SHOW SECRETS

SHOW SECRETS lists the names of the secrets securely stored in Materialize’s secret management system. There is no way to show the contents of an existing secret, though you can override it using the ALTER SECRET statement.

Syntax

SHOW SECRETS FROM schema_name LIKE pattern WHERE expr
Field Use
schema_name The schema to show secrets from. If omitted, secrets from the first schema in the search path are shown. For available schemas, see SHOW SCHEMAS.

Examples

SHOW SECRETS;
         name
-----------------------
 upstash_kafka_ca_cert
 upstash_sasl_password
 upstash_sasl_username
SHOW SECRETS FROM public LIKE '%cert%';
         name
-----------------------
 upstash_kafka_ca_cert
Back to top ↑