mz secret
The mz secret command manages secrets in a region.
create
Create a new secret.
mz secret create <NAME> [options...] The secret’s value is read from the standard input stream.
By default, the command returns an error if a secret with the provided name already exists. Pass --force to instead update the existing secret with the new value, if it exists.
NOTE: Using this command is preferred to executing
CREATE SECRET directly, as it avoids leaving the secret’s value in your shell history. Arguments
| Flag | Environment variables | Description |
|---|---|---|
<NAME> | Required. The name of the secret. | |
--database=<DATABASE> | The database in which to create the secret. Default: materialize. | |
--schema=<SCHEMA> | The schema in which to create the secret. Default: the first schema in the user’s default search_path. | |
--force | Overwrite the existing value of the secret, if it exists. | |
--profile=<PROFILE> | MZ_PROFILE | Use the specified authentication profile. |
Global arguments
| Argument | Environment variables | Description |
|---|---|---|
‑‑config | MZ_CONFIG | Set the configuration file. Default: $HOME/.config/materialize/mz.toml. |
‑f, ‑‑format | MZ_FORMAT | Set the output format: text , json, or csv.Default: text. |
‑‑no‑color | NO_COLOR, MZ_NO_COLOR | Disable color output. |
‑‑help | Display help and exit. | |
‑‑version | Display version and exit. |