I have the following stream:
CREATE OR REPLACE STREAM MYSTREAM WITH (KAFKA_TOPIC='my-topic', TIMESTAMP='bookingEndedAt', VALUE_FORMAT='AVRO');
This works. However, for reproducible migrations, I wish to explicitly state the schema ID as follows:
CREATE OR REPLACE STREAM MYSTREAM WITH (KAFKA_TOPIC='my-topic', TIMESTAMP='bookingEndedAt', VALUE_FORMAT='AVRO', VALUE_SCHEMA_ID=1);
However, this gives an error similar to the following:
The TIMESTAMP column set in the WITH clause does not exist in the schema: 'BOOKINGENDEDAT'
Casing seems to have no effect on this.
Practically the same question has been asked over on StackOverflow with no answer.
Is setting a custom timestamp + schema inference by ID not supported?