When using the Add Kafka table wizard on the Streaming SQL Console, you can configure
the schema under the Schema tab.
Schema is defined for a given Kafka source when the source is created. The data contained in
the Kafka topic can either be in JSON or AVRO format.
When specifying a schema you can either paste it to the Schema Definition field or click the
Detect schema button to identify the schema used on the generated data. The Detect Schema
functionality is only available for JSON data.
If the schema of the Kafka table where the output data is queried is not known at the time of
adding the table, you can select the Dynamic Schema option. This is useful when you want to
insert data to the table, and there is no guarantee that the input schema matches with the output
schema. If you select the Dynamic Schema option when adding a table, you can only use that table
as a sink.