André Falk mentioned the changes needed to update Kafka ingestion and schema registry configuration in version 1.6 based on the discussion thread.
André Falk
Asked on Jan 18, 2024
In version 1.6, the configuration for schema registry username and password has been moved to where schema.registry is configured.
Update the configuration as follows:
Before:
create table answers_to_life with (
connector='kafka',
properties.bootstrap.server='localhost:9092',
properties.sasl.username='xyz',
properties.sasl.password='123',
topic='all-answers',
schema.registry.username='foo',
schema.registry.password='bar',
) FORMAT DEBEZIUM ENCODE AVRO (
schema.registry = '<https://schemaregistry>',
);```
After:
```sql
create table answers_to_life with (
connector='kafka',
properties.bootstrap.server='localhost:9092',
properties.sasl.username='xyz',
properties.sasl.password='123',
topic='all-answers',
) FORMAT DEBEZIUM ENCODE AVRO (
schema.registry = '<https://schemaregistry>',
schema.registry.username='foo',
schema.registry.password='bar'
);```