I get following error:
WARN DB Table Selector 0:3 java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
Schema and table name are correct. I can simply enter them in the SQL editor below instead and then it works. Database is oracle.
Just found the fix while writing this point (enabled debug loggging):
KNIME create the query with alias (double-quotes) eg. “myschema”.“mytable” which on oracle means it’s then case-sensitive. So schema and table must be written in CAPITAL letter or else it fails. This isn’t good. ideally this is fixed automatically in code (eg no quotes for oracle connection) or expose an option in interface.