move-coop / parsons

A python library of connectors for the progressive community.
https://www.parsonsproject.org/
Other
257 stars 125 forks source link

[Feature/Addition] BigQuery copy table between projects #908

Open elyse-weiss opened 8 months ago

elyse-weiss commented 8 months ago

A simple function to move a table between BigQuery projects.

Detailed Description

Context

This is definitely helpful to TMC staff who may be working in Dev or TMC projects, and want to move tables to Prod or Member projects.

Possible Implementation

Google CLI code from @IanRFerguson: bq cp {{ project1 }}:dataset1.table1 {{ project2 }}:dataset2.table2

Priority

Medium