topic Re: Drop table if exists and create table in redshift output component does not work if the table is not present in the database in Talend Studio

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 — Tue, 01 Sep 2020 12:14:49 GMT

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

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

Anjali3 — Thu, 21 Jul 2022 04:55:07 GMT

Can someone answer this. Having the same issue.

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

Anonymous — Thu, 21 Jul 2022 08:05:50 GMT

@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

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

Don-Martin — Mon, 15 May 2023 16:51:55 GMT

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