André Falk encountered an issue where querying a column without quotes failed, but querying with quotes succeeded in a Kafka table with schema support. The discussion led to the explanation that the column names are case-sensitive due to the schema definition.
André Falk
Asked on Dec 20, 2023
SELECT "foo" FROM foobar;
, ensures that the query references the correct case-sensitive column name.