Drop table if exists and create table in redshift output component does not work if the table is not present in the database

[TM_Chowdary]

Hi All,

I am facing an issue while trying to create a table using the redshift output component with the option "drop table if exists and create". This fails if the table is not present in the database. But it works fine if the data is already present in the database.

Could you please help me with the solution for the same.

Thanks in advance!

Best Regards,

TM Chowdary

[Anjali3]

Can someone answer this. Having the same issue.

[Anonymous]

@Anjali Ramesh​ what are the exact error messages when the job fails? which version of studio are you using? we need more information to reproduce the issue.

Regards

Shong

[Don-Martin]

We are seeing the same issue on version R2022-12. Is there any resolution to this in any version?