Create and update tables in an connected PostgreSQL data base

How can I create and later update a table in a PostgreSQL data base that is connected to ONE DATA using Conections?

It does not matter how to create the table and how to write the data.

We need to write the data there, because the customer is using the data from the data base to feed other applications.

CC: @alfonso.chacon

Not a nice workaround but it could help. Use processor Database Connection Load. In the processor you can set additional Spark properties for the connection to your database. Make use of sessionInitStatement. See JDBC To Other Databases - Spark 2.4.0 Documentation for documentation.

1 Like

Thank you very much @stefan.ganser
This is how I configured the processor:

1 Like