I am currently working on a project with Clickhouse DB and ran into an issue with temporary tables.
In order to use them I need to establish a live session with the database. Is there a way I can achieve that over knime? And if yes - how can I do that?
So I am able to connect to the database and do my normal data extractions etc. but this seems to be not a “live session” as I am not able to create any kind of temp tables, which would require the live session.
Is this a limitation from KNIME by any chance?