[ LIST | SHOW ] SCHEMA_REGISTRIES;
This provides a list of schema registries to which the user has access. A is required when dealing with data serialized with Avro.
Schema registries are listed only if the current role has USAGE privileges.
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 |
+----------+----------------+--------+------------------------------------------------+----------+-------------------------------+-------------------------------+