This example shows the schema for the CREATE storage_format SCHEMA example:
SHOW Avro SCHEMA chemDatasetSchema;
>
CREATE Avro SCHEMA chemDatasetSchema AS
'{
"namespace": "example.avro",
"type": "record",
"name": "User",
"fields": [
{"name": "name", "type": "string"},
{"name": "favorite_number", "type": ["int", "null"]},
{"name": "favorite_color", "type": ["string", "null"]}
]
}';