Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm experiencing an issue trying to create a table in a postgres database using the tDBOutput component, where I receive an error that the table does not exist. for reference, I've tried various table actions (drop and create, drop if exists and create, create if does not exist, create, etc.), along with an insert action on data, and every time it tells me that it can't insert data because the table doesn't exist. it seems it's failing to create the table. I have no issues if I create the table myself in the database management tool and then use Talend to insert rows, but I'm looking at doing a mass data transfer for many tables and want to create the tables using Talend so that the table schemas can detect and build themselves. anyone know what the cause of this may be?
Hello @Dan Rosen ,
What's the db Type for the tDBOutput component in your side?
In my side, I test with MySQL db with Action on table "Drop table if exists and create" and Action on data "Insert" for tDBOutput, it's working as expected as the below