Redshift Serverless: "job" behaves like a Reserved word

Question

I`m discovered that the word _job_  behaves like a Reserved word (you need to wrap it in " "  for user) on Redshift Serverless only, but on a regular Redshift as allowed...
this is bug or feature?

Answer

Confirmed the same behavior on my end. Currently JOB is not in the list of reserved words but it seems to be related to COPY JOB syntax which is in preview at the moment.

I think there is no other public information we can provide here, please contact AWS support if you need further investigation. As you mentioned, the workaround is to wrap with "".

I think there is no other public information we can provide here, please contact AWS support if you need further investigation. 
As you mentioned, the workaround is to wrap with "".

Redshift Serverless: "job" behaves like a Reserved word

Contenuto pertinente