Fivetran
Fivetran documentation
Search the docs
/
Sign In
  • >
    Getting Started
  • >
    Core Concepts
  • >
    Deployment Models
  • >
    Using Fivetran
  • >
    Usage-Based Pricing
  • >
    Connectors
  • v
    Destinations
    • Connection Options
    • >
      Apache Kafka
    • >
      Azure Data Lake Storage
    • >
      Azure Synapse
    • v
      BigQuery
      • Setup Guide - BigQuery
      • Setup Instructions - Partitioned Tables
      • Setup Instructions - Clustered Tables
      • API Configuration
      • Troubleshooting
        • Cross-Region Table Copy With Append Mode Error
      • Release Notes
    • >
      ClickHouse Cloud
    • >
      Databricks
    • >
      Managed Data Lake Service
    • >
      Materialize
    • >
      Milvus
    • >
      MotherDuck
    • >
      MySQL
    • >
      OneLake
    • >
      Oracle
    • >
      PostgreSQL
    • >
      Redshift
    • >
      S3 Data Lake
    • >
      SingleStore
    • >
      Snowflake
    • >
      SQL Server
    • >
      SurrealDB
    • >
      Teradata Vantage
    • Troubleshooting
  • >
    Connector SDK
  • By Request
  • Partner-Built
  • >
    Transformations
  • >
    Logs
  • Security
  • Privacy
  • >
    REST API
  • >
    Release Notes
  • >
    HVR 6 Documentation
  • >
    HVR 5 Documentation

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.

Thanks for your feedback!
Was this page helpful?
On this page
Loading...
More from Fivetran
Fivetran status
Contact us
Need help?
Contact support
Sign inCreate an account
BlogCase studiesResource center
Fivetran
©2025 Fivetran Inc.