BigQuery Merge Condition

[bigrogerio]

Hi everyone,

I have a question regarding Incremental datasets with merge conditions.

In the image above, It is clear that if we declare a uniqueKey, we can use the MERGE clause within BigQuery. But my question is: can we use multiple keys to perform the JOIN? In other words, can we declare something like this:

config {

  type: "incremental",

  uniqueKey: ["key_1", "key_2", "key_3"]

}

Could you help with this question?

Thanks for all the help!

Best regards.

[BenBirt]

Assuming you mean that each row should have a unique key whose parts consist of key_1, key_2 and key_3 - yes! This is why uniqueKey is an array.