Update or delete data from BigQuery

[Anonymous]

Hello,

I have a process that reads from MySQL and uploads the data to BigQuery.

In order to execute this, I'm using tMysqlinput > tmap > tBigQueryInput

In certain conditions, I have to update or delete data from BigQuery.

I found this thread https://community.talend.com/t5/Design-and-Development/tBigQueryInput-DML-Update-BigQuery/m-p/53508#...

But couldn't understand how to specify the data that I want to delete or update.

Do someone know what it the best way to update/ delete data from BigQuery, and how to connect it to tmap's output?

Thanks,

Emma

[Anonymous]

Hello,

Have you already checked these references about:

https://cloud.google.com/bigquery/docs/updating-data
https://cloud.google.com/bigquery/docs/reference/standard-sql/?

This jira issue is still in process.

https://jira.talendforge.org/browse/TBD-5959

Best regards

Sabrina