I’m using n8n to gather data from some tools like Hubspot and Zendesk into Google BigQuery.
For inserting, I use the BigQuery insert node and everything works fine. The problem is when I try to perform an update or a delete operation in the table using a BigQuery executeQuery node. I’m getting the error bellow:
UPDATE or DELETE statement over table DatasetName.TableName would affect rows in the streaming buffer, which is not supported [item 0]
It seems that the insert node affects the destination table, but I’m not sure how to find a workaround. It doesn’t seem exectly a bug on n8n either. Any tips?
I’m using [email protected] cloud hosted.