# schema\_registries

## Description

Exposes metadata about schema registries connected to the organization. Schema registries are used for Avro serialization. Credential values are never exposed. Only schema registries on which the current role has USAGE privileges are returned.

{% hint style="info" %}
**Note** Credential values are never returned, even when `has_credentials` is `true`.
{% endhint %}

## Syntax

```sql
SELECT * FROM deltastream.sys."schema_registries";
```

## Columns

| Column                    | Type           | Nullable | Description                                                              |
| ------------------------- | -------------- | -------- | ------------------------------------------------------------------------ |
| `name`                    | VARCHAR        | No       | Name of the schema registry.                                             |
| `type`                    | VARCHAR        | No       | Type of the schema registry, e.g. `ConfluentCloud`.                      |
| `uris`                    | VARCHAR        | No       | JSON array of URIs for the schema registry connection.                   |
| `ssl_enabled`             | BOOLEAN        | No       | Whether TLS/SSL is enabled.                                              |
| `hostname_verification`   | BOOLEAN        | No       | Whether server hostname verification is enabled.                         |
| `has_credentials`         | BOOLEAN        | No       | Whether credentials are configured. Credential values are never exposed. |
| `properties`              | VARCHAR        | No       | JSON object of additional properties.                                    |
| `status`                  | VARCHAR        | No       | Current connectivity status. One of `ready`, `error`.                    |
| `status_message`          | VARCHAR        | Yes      | Error message if `status` is `error`.                                    |
| `marked_for_deletion`     | BOOLEAN        | No       | Whether the schema registry is pending deletion.                         |
| `owner`                   | VARCHAR        | No       | The role that owns this resource.                                        |
| `created_by_role`         | VARCHAR        | No       | The role that created this resource.                                     |
| `created_by_role_deleted` | BOOLEAN        | No       | Whether the creating role has since been deleted.                        |
| `created_by`              | VARCHAR        | No       | The user that created this resource.                                     |
| `created_at`              | TIMESTAMP\_LTZ | No       | Timestamp when this resource was created.                                |
| `updated_by_role`         | VARCHAR        | No       | The role that last updated this resource.                                |
| `updated_by_role_deleted` | BOOLEAN        | No       | Whether the last updating role has since been deleted.                   |
| `updated_by`              | VARCHAR        | No       | The user that last updated this resource.                                |
| `updated_at`              | TIMESTAMP\_LTZ | No       | Timestamp when this resource was last updated.                           |
| `organization_id`         | VARCHAR        | No       | The unique identifier of the organization this resource belongs to.      |

## Examples

List all schema registries:

```sql
SELECT * FROM deltastream.sys."schema_registries";
```

```sh
[{"name":"ccsr","type":"ConfluentCloud","uris":"[\"https://psrc-xqq6z.us-central1.gcp.confluent.cloud\"]","ssl_enabled":true,"hostname_verification":true,"has_credentials":true,"properties":"{}","status":"ready","status_message":null,"marked_for_deletion":false,"owner":"sysadmin","created_by_role":"sysadmin","created_by_role_deleted":false,"created_by":"user@example.com","created_at":"2025-08-22T13:13:24.763Z","updated_by_role":"orgadmin","updated_by_role_deleted":false,"updated_by":"user@example.com","updated_at":"2025-08-22T13:13:24.763Z","organization_id":"00000000-0000-0000-0000-000000000001"}]
```

## See Also

* [System Tables Overview](https://docs.deltastream.io/reference/sql-syntax/systables)
* [LIST SCHEMA\_REGISTRIES](https://docs.deltastream.io/reference/sql-syntax/command/list-schema_registries)
* [CREATE SCHEMA\_REGISTRY](https://docs.deltastream.io/reference/sql-syntax/ddl/create-schema_registry)