ALTER SECRET

Altering a secret does not change the secret used in a running job until the job is restarted (e.g., by restarting the cluster).

Syntax

ALTER SECRET secret_name WITH (
    backend = 'meta'
) AS 'your_new_secret';

Parameter or Clause	Description
`secret_name`	The name of the secret to be altered.
`backend`	The backend where the secret is stored. Currently, only the meta backend is supported.
`your_new_secret`	The new secret value that you wish to store securely.

ALTER SECRET mysql_pwd WITH (
    backend = 'meta' 
) AS 'new_password';