Hi Tobias,
thanks for the hint! This helped. I can now connect to the database (i.e., the DB Connector turns green). However, when running a query, I get the following error message from Dremio:
ERROR DB Reader 0:3 Execute failed: Can’t turn off auto-committing; transactions are not supported. (Dremio is not transactional.)
From the following Dremio help topic, I gather that a possible reason might be that KNIME disables autocommit in the JDBC connection: https://community.dremio.com/t/exception-during-pool-initialization-cant-turn-off-auto-committing-transactions-are-not-supported-dremio-is-not-transactional/1656/3
Is this the case?
I didn’t find autocommit as a setting in KNIME. Is there a way to enable it for this connection?
KR Andreas