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
Comments