Keboola Connection Support

Empty SQL Statement

Follow

If you got an error message from a SQL transformation saying something like:

SQL error: SQL compilation error: Empty SQL statement.
Query not valid.

It means there are two semicolons in your code next to each other. The query parser then tries to evaluate the empty string between them as a query and eventually fails.

To fix this issue:

  • In the failed job detail click the `Show details` button
  • In the details click the `Open query` link
  • Check the highlighted query
  • Remove the extra semicolon 

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk