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 <condition(s)> ]
| Option | Description |
|---|---|
| FROM <schema_name> | If specified, only show secrets from the specified schema. Defaults to first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS. |
| LIKE <pattern> | If specified, only show secrets whose name matches the pattern. |
| WHERE <condition(s)> | If specified, only show secrets that meet the condition(s). |
Examples
SHOW SECRETS;
name
-----------------------
kafka_ca_cert
kafka_sasl_password
kafka_sasl_username
SHOW SECRETS FROM public LIKE '%cert%';
name
-----------------------
kafka_ca_cert