How to cancel automatically adding "LIMIT 0" to the SQL INJECT node after the SQL statement

How to cancel automatically adding “LIMIT 0” to the SQL INJECT node after the SQL statement

Hi leiyangcd,

KNIME’s DB integration often requires a LIMIT 0 at the end to in order to get the table specifications. If you are receiving an empty table, the issue likely lies somewhere else. If this is the case, maybe you can try enabling the JDBC logger.

Best,
Karen

2 Likes