data-models icon indicating copy to clipboard operation
data-models copied to clipboard

Improve performance with MERGE upserts.

Open colmsnowplow opened this issue 4 years ago • 0 comments

Using MERGE instead of DELETE FROM, INSERT INTO might well prove more performant and cost efficient, particularly in the case of BigQuery.

We should test this, and implement MERGE if it proves to be the better option (without affecting logic obviously).

colmsnowplow avatar Mar 18 '21 11:03 colmsnowplow