LIST SCHEMA_REGISTRIES

Syntax

[ LIST | SHOW ] SCHEMA_REGISTRIES;

Description

This provides a list of Schema Registries that the user has access to. A Schema registry is required when dealing with data serialized with Avro.

Schema registries will only be listed if the current role has USAGE privileges.

Examples

demodb.public/demostore# LIST SCHEMA_REGISTRIES;
+----------+----------------+--------+------------------------------------------------+----------+-------------------------------+-------------------------------+
|  Name    |  Type          |  State |  Uris                                          |  Owner   |  Created At                   |  Updated At                   |
+==========+================+========+================================================+==========+===============================+===============================+
| sr_local | Confluent      | ready  | https://on-prem-sr.ds:8081                     | sysadmin | 2024-05-14 19:20:15 +0000 UTC | 2024-05-14 19:20:15 +0000 UTC |
+----------+----------------+--------+------------------------------------------------+----------+-------------------------------+-------------------------------+
| cc_reg   | ConfluentCloud | ready  | https://abcdef.us-central1.gcp.confluent.cloud | sysadmin | 2024-06-11 19:43:44 +0000 UTC | 2024-06-11 19:43:44 +0000 UTC |
+----------+----------------+--------+------------------------------------------------+----------+-------------------------------+-------------------------------+