CREATE SCHEMA_REGISTRY
Syntax
Description
Schema Registries are useful for storing and managing the many schemas that may define a user's data streams. These schemas are necessary for a system to marshal and unmarshal records and make sure the native data format matches the intended format. After creating a Schema Registry, look at how to UPDATE STORE to attach the Schema Registry to a Store. The Schema Registry that is created will be accessible to the user who created it and anyone who has been given permissions.
Schema Registries can only be created by a Role with CREATE_SCHEMA_REGISTRY
privilege.
Schema Registry is required for working with Avro data
Currently supported Schema Registries are Confluent Cloud and Confluent Platform
Arguments
schema_registry_name
Specifies the name of the new Schema Registry. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.
WITH (schema_registry_parameter = value [, … ])
This clause specifies Schema Registry parameters; see Schema Registry Parameters below for more information.
Schema Registry Parameters
Parameter Name | Description |
---|---|
| Type of Schema Registry. Required: Yes
Type: |
| Region the Schema Registry resides in. Required: Yes, unless specified in |
| List of comma separated Required: Yes, unless specified in |
| Optional. The file path to a yaml file containing other Schema Registry parameters. Required: No Default value: None Type: String Valid values: File path in current user's filesystem |
Confluent Cloud Schema Registry Specific Parameters
Parameter Name | Description |
---|---|
| Credentials key for the Confluent Cloud Schema Registry. Required: No Default: None Type: String Valid values: The key corresponding with the credential key pair associated with the Schema Registry. |
| Credentials secret for the Confluent Cloud Schema Registry. Required: No Default: None Type: String Valid values: The secret corresponding with the credential key pair associated with the Schema Registry. |
Confluent Platform Schema Registry Specific Parameters
Parameter Name | Description |
---|---|
| Login username for the Confluent Platform Schema Registry. Required: No Default: None Type: String |
| Login password for the Confluent Platform Schema Registry. Required: No Default: None Type: String |
| File path to client certificate for mutual TLS authentication in PEM format. Required: No Default: None Type: String |
| File path to client certificate key for mutual TLS authentication in PEM format. Required: No Default: None Type: String |
Examples
Create a Confluent Cloud Schema Registry
The following is an example statement that creates a new CONFLUENT_CLOUD
Schema Registry named ConfluentCloudSR
:
Create a Confluent Platform Schema Registry
The following is an example statement that creates a new CONFLUENT
Schema Registry named ConfluentPlatformSR
:
Create a Schema Registry with credentials from a file
The following creates a new CONFLUENT_CLOUD
Schema Registry named ConfluentCloudSR
:
Last updated