topic Re: Not able to insert or create table in redshift cluster using tDBoutput in Talend Studio

Not able to insert or create table in redshift cluster using tDBoutput

vigneshjaisankar96 — Fri, 15 Nov 2024 22:40:20 GMT

Hi,

I am testing a basic read and write operation in redshift database.

The connections are fine, I'm able to test connection successfully and able to read data using tDBinput.

I'm able to read data from redshift database tables. But not able to write back ( insert or update) and not able to create table using tDBoutput activity.

I tried inserting in existing table on which I'm trying with options on Action on table ( none, create table if exists, drop and create table) and Action on data ( Insert, Update, Insert or Update, Update or Insert)

The second thing is I tried with new table name in Table field and Action on table(create table, create table if exists and other options as well) and Action on data

( Insert, Update, Insert or Update, Update or Insert)

Please let me know what I'm doing wrong.

Pipeline flow:

1: Inserting in existing table

2.trying to create table and inserting in that table

Re: Not able to insert or create table in redshift cluster using tDBoutput

vigneshjaisankar96 — Tue, 09 Aug 2022 09:07:40 GMT

Update from my side:

I was using existing connection in tDBoutput. If I don't use existing connection the tDBoutput and put the connection parameters then I can able to write, create in tables

Re: Not able to insert or create table in redshift cluster using tDBoutput

Anonymous — Tue, 09 Aug 2022 09:41:40 GMT

Hello,

From your screenshot, the 11 rows are executed successfully. Is the existing connection tDBConnection working well?

Any error message printed on console when you use existing connection the tDBoutput?

Best regards

Sabrina

Re: Not able to insert or create table in redshift cluster using tDBoutput

vigneshjaisankar96 — Tue, 09 Aug 2022 09:57:27 GMT

Hi,

Yes, the connection working fine.

There is no error message for the existing scenario.

Now I'm not using existing connection option in tDBoutput. Below way I can able to insert or update and create table as well.

I'm using 11 rows for insert and one row for update and working fine in both tDBoutput I'm not using the 'use existing connection' option.

Thanks,

Vignesh

Re: Not able to insert or create table in redshift cluster using tDBoutput

Anonymous — Wed, 10 Aug 2022 08:18:04 GMT

Hello,

Could you please clarify in which Talend version/edition you are?

We are not able to repro this kind of issue on talend V 8.0.

Best regards

Sabrina