Four Stars

Update or delete data from BigQuery

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

1 REPLY
Moderator

Re: Update or delete data from BigQuery

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.