If you want to copy data between BigQuery tables, there are many ways to do it depending on whether you want

  • Free
  • Inter-regional
  • Automated
  • Partitioned tables

More at my article here.