Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
This is the only step I have in a scenario, it is an execute sql step which consist in :
CREATE TABLE IF NOT EXISTS (table name) (
SELECT * FROM (a dataset of my flow)
)
And the error I get while running the scenario :
[Teradata Database] [TeraJDBC 17.00.00.03] [Error 3706] [SQLState 42000] Syntax error: expected something between the 'TABLE' keyword and the 'IF' keyword.
Pls help me 😉
Hello @BlueRabit,
Apparently you have a syntax issue. Could you try using the "CREATE AS" syntax like so:
CREATE TABLE IF NOT EXISTS table_name AS your_query
Hope this helps
Hi !
Tanks for helping, this solution doesn't seems to work neither, it's the same error :
[Error 3706] [SQLState 42000] Syntax error: expected something between the 'TABLE' keyword and the 'IF' keyword.