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.
Note Credential values are never returned, even when has_credentials is true.
Syntax
SELECT * FROM deltastream.sys."schema_registries";Columns
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:
See Also
Last updated