YotpoLtd/metorikku

Update SQL on JDBC target

tooptoop4 opened this issue · 0 comments

Docs have below

_JDBC query
JDBC query output allows running a query for each record in the dataframe.

Mandatory parameters:
query - defines the SQL query. In the query you can address the column of the DataFrame by their location using the dollar sign ($) followed by the column index. For example:
INSERT INTO table_name (column1, column2, column3, ...) VALUES ($1, $2, $3, ...);__

but can i run a single update SQL into a jdbc connection?

for example, i have one input that is reading count(1) from csv on s3, then i have another step that is update a single row in postgres table. ie update postgres.meta_table_counts set latest_rowcount = (select count(1) from csvdf) where table_name = 'abc';