SQL Validation?

Hi everyone,

Is there a way to validate the sql queries in KNIME?

Best,

Hello @KKERROXXX,

DB Query Reader and DB Query nodes have Evaluate button but not sure is that helpful in your case. What kind of sql query validation are you looking for?

Br,
Ivan

3 Likes

Hi @KKERROXXX,

also if you want to check if a sql statement is working without error automatically - then you could use the try/catch nodes to test if a statement leads to an error:

3 Likes

Hi @AnotherFraudUser,

Thanks for the response, but these nodes can be used for a sql query validation?

Best,

Hi @KKERROXXX,

sure - place a

at the beginning of a db-reader/executor with the query you want to test and a

afterwards.
If the Query does not work the error message can be extracted from the catch node.

But this only validates if a query is valid for execution, not if the results of the query is as indended or if the query does something you do not want.

I often use it for error handling for automated sql - e.g. if something failed in a long list of sqls - then perform certain error handling steps - else continue with the process

3 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.