BigQuery Updates Rather than Inserts

Questions
1

image
image1265×207 14.2 KB

Hi,
I am trialing n8n for uploading Quickbase Data to Google BigQuery. I would like to update the BigQuery Table nightly.

Questions:
How do I either update or replace the table in Big Query? I just see “Insert” or “Execute Query” under operation. Running the workflow twice with 10 records, I am seeing duplicates rather than updates.

Thank you

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Running version [email protected]

4

Welcome to the community @chrissy :tada:
I think the only available operations available in the Big Query node are the two you mentioned and you’ll have to post in Feature Requests if you think other operations options will be useful too. For now, you’ll have to choose the ‘Execute Query’ option and then write your own query to update/replace the table.

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.