When running the transformation script from the docs, it throws me the following error message. Can somebody help?
https://help.keboola.com/tutorial/manipulate/
Also the docs/tutorials are somewhat outdated regarding starting the Sandbox environment etc.
SQL compilation error: syntax error line 2 at position 21 unexpected '"_timestamp"'. syntax error line 2 at position 34 unexpected ','.
@Mark Bitter the docs have been fixed https://help.keboola.com/tutorial/manipulate/#transformation-script thanks for letting us know!
It's a bug or rather a typo. SNFLK does not have EXCEPT in it's dialect if I read the documentation correctly. It should be
SELECT * EXCLUDE "_timestamp".Thanks for letting us know🎖
BTW: Keeping documentation bug-free and up-to-date is an endless struggle, so if you ever find any other issues we'd be very happy if you let us know. There is also a way to provide feedback directly on the docs page. That goes directly to the teams backlog (I already pushed this one there).
Hi Mark, I think there should be something similar to the previous query:
SELECT * EXCEPT ("_timestamp")or specifically select columns needed.
Good catch, I will ask our support to fix this!