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