how do I write an update query in a bigdata job

[TomG1]

I am trying create a big data job in talend 7.3 version which updates a Azure DWH Table.

I need to write a custom query which updates one particular column in the table.

However I don't see an option to write custom query in tJDBC output component.

[Anonymous]

Hello,

Please try to use tJDBCInput or tJDBCRow component to execute a database query.

tJDBCOutput component is used to write, update, make changes or suppresses entries in any type of database connected to a JDBC API.

Best regards

Sabrina