Error: Cross-Region Table Copy With Append Mode Is Unsupported

Issue

The connector fails with the following error:

Cross-region table copy with append mode (--append_table or WRITE_APPEND) is unsupported. Use copy without the append mode.

Environment

Destination: BigQuery

Resolution

Make sure that the region of the tables are same.

Cause

This issue occurs if your dataset's location has changed.