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

{{% include-syntax file="examples/create_secret" example="syntax" %}}

Examples

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

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/create-secret" %}}

Related pages

• CREATE CONNECTION
• ALTER SECRET
• DROP SECRET
• SHOW SECRETS