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;
db.public/cc_kafka
  Name |      Type      |                       URI                        |  Owner   |      Created at      |      Updated at
-------+----------------+--------------------------------------------------+----------+----------------------+-----------------------
  sr   | ConfluentCloud | https://nnnnn.us-east-1.aws.confluent.cloud | sysadmin | 2023-02-02T23:38:16Z | 2023-02-02T23:38:16Z