How can I perform CRUD operation on a table present in my Google Bigquery dataset

[#1]

Preface: Using the putbigquery NiFi processor, I am writing the contents of a flowfile to a table in my Google BigQuery.

Current Process:

1. I am using the putbigquery processor to read the content of a flowfile and insert it into a table within a dataset in Google BigQuery.
2. Currently, I am passing the data as a CSV formatted file and using a CSVReader controller service, which is configured in the RecordReader property of the putbigquery processor to parse the incoming data and insert it.

New Objective: I need to find a way to perform Create, Insert, Update, Delete, and Merge operations on the table in BigQuery using Apache NiFi.

If anyone has ideas on how to implement this, please share your approach. Thanks in advance!