Create table in DB (DB Table creator ERROR)

I’m trying to create a table in redshift using the DB table creator node, and when I do this I get the following error: Execute failed: ERROR: syntax error at or near “user” in context “power_hour varchar, user”, at line 1
Position: 79

I’ve checked that columns have data types integer and varchar which are supported by redshift. So don’t know what is going on, can someone help me?

Hello @AdrianaFerro,

Can you confirm if you are using user as a column name.

If positive, it’s a reserved word, could you try putting it in double quotes ("user") to avoid the syntax error?

Hope this helps.

Best,
Keerthan

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.