Home  /  Reference

CREATE SECRET

A secret securely stores sensitive credentials (like passwords and SSL keys) in Materialize’s secret management system. Optionally, a secret can also be used to store credentials that are generally not sensitive (like usernames and SSL certificates), so that all your credentials are managed uniformly.

Syntax

CREATE SECRET IF NOT EXISTS name AS value
Field Use
name The identifier for the secret.
value The value for the secret. The value expression may not reference any relations, and must be implicitly castable to bytea.

Examples

CREATE SECRET upstash_kafka_ca_cert AS decode('c2VjcmV0Cg==', 'base64');

Privileges

The privileges required to execute this statement are:

  • CREATE privileges on the containing schema.
Back to top ↑