# UPDATE SCHEMA\_REGISTRY

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
UPDATE SCHEMA_REGISTRY
    schema_registry_name
WITH (schema_registry_parameter = value [, ... ]);
```

### Description

Updates a [schema registry](/overview/core-concepts/store.md#schema-registry) with new parameters.

### Arguments

#### schema\_registry\_name

Specifies the name of the new schema registry. If the name is case-sensitive, you must wrap it in double quotes; otherwise, the system uses the lower case name.

#### WITH (schema\_registry\_parameter = value \[, …​ ])

This clause specifies schema registry parameters; see [schema registry parameters](#schema-registry-parameters) below for more information.

### Schema Registry Parameters

| Parameter Name    | Description                                                                                                                                                                          |
| ----------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| `type`            | <p>Type of schema registry.<br><br>Type: <code>SCHEMA\_REGISTRY\_TYPE</code><br>Valid values: <code>CONFLUENT</code>, <code>CONFLUENT\_CLOUD</code></p>                              |
| `access_region`   | <p>Region in which the schema registry resides.<br><br>Type: String<br>Valid values: See <a href="/pages/dqmTShTXTtD4hHXCMHxo">LIST REGIONS</a></p>                                  |
| `uris`            | <p>List of comma-separated <code>host:port</code> URIs to connect to the schema registry.<br><br>Type: String</p>                                                                    |
| `properties.file` | <p>The file path to a .yaml file containing other schema registry parameters.<br><br>Default value: None<br>Type: String<br>Valid values: File path in current user's filesystem</p> |

### Confluent Cloud Schema Registry Specific Parameters

| Parameter Name           | Description                                                                                             |
| ------------------------ | ------------------------------------------------------------------------------------------------------- |
| `confluent_cloud.key`    | <p>Credentials key for the Confluent Cloud schema registry.<br><br>Default: None<br>Type: String</p>    |
| `confluent_cloud.secret` | <p>Credentials secret for the Confluent Cloud schema registry.<br><br>Default: None<br>Type: String</p> |

### Confluent Platform Schema Registry-Specific Parameters

| Parameter Name         | Description                                                                                                                  |
| ---------------------- | ---------------------------------------------------------------------------------------------------------------------------- |
| `confluent.username`   | <p>Login username for the Confluent Platform schema registry.<br><br>Default: None<br>Type: String</p>                       |
| `confluent.password`   | <p>Login password for the Confluent Platform schema registry.<br><br>Default: None<br>Type: String</p>                       |
| `tls.client.cert_file` | <p>File path to client certificate for mutual TLS authentication in PEM format.<br><br>Default: None<br>Type: String</p>     |
| `tls.client.key_file`  | <p>File path to client certificate key for mutual TLS authentication in PEM format.<br><br>Default: None<br>Type: String</p> |

## Examples

#### Update a Confluent Cloud schema registry with new credentials

The following updates a `CONFLUENT_CLOUD` schema registry named `ConfluentCloudSR` with new credential keys:

```sh
demodb.public/demostore#
UPDATE SCHEMA_REGISTRY "ConfluentCloudSR" WITH (
    'confluent_cloud.key' = 'fake_key',
    'confluent_cloud.secret' = 'fake_secret'
);
+-----------------+------------------+------------+------------------------------------------+
|  Type           |  Name            |  Command   |  Summary                                 |
+=================+==================+============+==========================================+
| schema registry | ConfluentCloudSR | UPDATE     | schema registry "ConfluentCloudSR" was   |
|                 |                  |            | successfully updated                     |
+-----------------+------------------+------------+------------------------------------------+
```

#### Update a Confluent Platform schema registry with new credentials

The following updates a `CONFLUENT` schema registry named `ConfluentPlatformSR` with new credential keys:

```sh
demodb.public/demostore# UPDATE SCHEMA_REGISTRY "ConfluentPlatformSR" WITH (
    'confluent.username' = 'fake_username',
    'confluent.password' = 'fake_password'
);
+-----------------+---------------------+------------+------------------------------------------+
|  Type           |  Name               |  Command   |  Summary                                 |
+=================+=====================+============+==========================================+
| schema registry | ConfluentPlatformSR | UPDATE     | schema registry "ConfluentPlatformSR"    |
|                 |                     |            | was successfully updated                 |
+-----------------+---------------------+------------+------------------------------------------+
```


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.deltastream.io/reference/sql-syntax/ddl/update-schema_registry.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.