'BigQuery Internal error when running Merge

I am executing a query for merging tables. I execute this same query every week, but this time it throws me an internal error. I waited and tried it again the same day and then the next day. The error didn't go away.

Error:

Error running query
An internal error occurred and the request could not be completed. This is usually caused by a transient issue. Retrying the job with back-off as described in the BigQuery SLA should solve the problem: https://cloud.google.com/bigquery/sla. If the error continues to occur please contact support at https://cloud.google.com/support. Error: 5423415

My code

MERGE TB
        USING TBT
        ON TB.id = TBT.id
        WHEN MATCHED THEN
          UPDATE SET id = TBT.id, col1 = TBT.col1 ....
        WHEN NOT MATCHED THEN
          INSERT (id, col1 ...) VALUES(id, col1 ...)

Do anyone know if something has changed or why is this throwing me an error now.

Update:

The third day the query worked, and a few others also. But then for another table marge (2 different tables) I got the same error.

google-bigquery

Solution 1:^[1]

After some time talking to support via BigQuery component, they implemented a fix in BigQuery that fixed my issue. Thread is private since I had to describe personal information and exact problem.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Klemen Vrhovec

'BigQuery Internal error when running Merge

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]