How to share a temporary table across jobs?

[Anonymous]

Hi,

I want to create a temporary table (in Postgres) that I want to share across two jobs (see screenshot). However when I create a database connection, it's not recognized by any of the jobs (see second screenshot) as the component list is empty. In another forum, I found out that you can add the connection in the dynamic settings as an item (see 3rd screenshot), but this still lead to an error (4th screenshot). Anyone have any suggestions?

As an alternative, if it's not possible through a temp table, but rather through a permanent table, how can I drop the table later on as I didn't see any database command components for that either (only create table components)?

Roland

component list emptyadding db connection as itemerror when running job and adding connection as item

[JohnRMK]

In Run View ->Advanced Settings -> Log4j-->trace 

you will have first tDBconnection_1 (parent job) Create a shared connection "name"

then tDBConnection_2 (child job) fin a shared connection with key "name"

If you do not see the de log, it's disable by default, you can enable them in preferences log4j ou project settings (i dont remember lol)

the trace log is only for dev environnement and for prod, you can lunch warn ou error

[Anonymous]

I did a quick search. It appears that the Log4j Logging Option is not available in Talend Open Studio which I'm using. 

[Anonymous]

I did a quick search. It appears that the Log4j Logging Option is not available in Talend Open Studio which I'm using. 

[JohnRMK]

I assure you it's an option of free and payed subscription 

You will fin it in the project management 

Then you can use trace logs 

[JohnRMK]

I assure you it's an option of free and payed subscription 

You will fin it in the project management 

Then you can use trace logs 

[Anonymous]

Thanks. I found it now.

[Anonymous]

Thanks. I found it now.