ALTER CREDENTIAL Syntax
system_admin or system_user_admin, or users with
credential_admin on the credential, may alter it.
Parameters
<schema name>
<schema name>
Name of the schema containing the credential to alter
<credential name>
<credential name>
Name of the existing credential to alter.
SET PROPERTY
SET PROPERTY
Indicator that a comma-delimited list of property name/value assignments will follow. See
Set Properties and Options for the
complete list of properties.
Examples
To alter a credential,auser_azure_active_dir_creds, updating the secret:
ALTER CREDENTIAL Example
kafka_cred, updating the keystore password:
ALTER CREDENTIAL WITH OPTIONS Example
Set Properties
All credential properties can be altered via ALTER CREDENTIAL. The following are the property names and descriptions to use when performing an alteration.TYPE
TYPE
The type of credential. Supported types include:
| Type | Description |
|---|---|
aws_access_key | Authenticate to Amazon Web Services (AWS) via Access Key |
aws_iam_role | Authenticate to Amazon Web Services (AWS) via IAM Role |
azure_ad | Authenticate to Microsoft Azure via Active Directory |
azure_sas | Authenticate to Microsoft Azure via Shared Access Signature (SAS) |
azure_storage_key | Authenticate to Microsoft Azure via Storage Key |
confluent | Authenticate to a Confluent Kafka cluster or schema registry |
docker | Authenticate to a Docker repository |
gcs_service_account_id | Authenticate to Google Cloud via user ID & private key |
gcs_service_account_keys | Authenticate to Google Cloud via JSON key |
hdfs | Authenticate to HDFS |
jdbc | Authenticate via Java Database Connectivity |
kafka | Authenticate to a Kafka cluster or schema registry |
nvidia_api_key | Authenticate to the Nvidia AI API |
openai_api_key | Authenticate to the OpenAI API |
IDENTITY
IDENTITY
Username to use for authenticating with the credential.
SECRET
SECRET
Password to use for authenticating with the credential.
'<option>'
'<option>'
Any option/value pair from the credential options list.