Hi everyone,
Is there a way to validate the sql queries in KNIME?
Best,
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
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:
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
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.