Can't Repro
Status Update
No update yet.
Comments
va...@google.com
si...@google.com
Hello,
This issue report has been forwarded to the Cloud BigQuery Product team so that they may investigate it, but there is no ETA for a resolution today. Future updates regarding this issue will be provided here.
si...@google.com
Hi,
To troubleshoot the issue further, I have created a private ticket to provide some information about the issue (for which you should have received a notification). Please provide requested information there. Don't put any personal information, including project identifiers in this public ticket.
ma...@alvin.ai
Hello is it possible to reopen this issue? I didn't see the private thread.
Description
Please provide as much information as possible. At least, this should include a description of your issue and steps to reproduce the problem. If possible please provide a summary of what steps or workarounds you have already tried, and any docs or articles you found (un)helpful.
Problem you have encountered:
When using:
The copy feature works if we are copying tables from a regional local to another regional location, or from a multi-regional location to another multi-regional location
code:
from google.cloud import bigquery
client = bigquery.Client()
table_1 = ...
table_2 = ...
job = client.copy_table(sources=table_1, destination=table_2, project="my_project")
job.result()
works:
table_1: my_project.dt_test_us.employees (dataset location US)
table_2: my_project.dt_test_eu.employees (dataset location EU)
works:
table_1: my_project.dt_test_eu.employees (dataset location EU)
table_2: my_project.dt_test_us.employees (dataset location US)
works:
table_1: my_project.df_test_europe_west_3.employees (dataset location europe-west3)
table_2: my_project.df_test_us_east_5.employees (dataset location us-east5)
works:
table_1: my_project.df_test_us_east_5.employees (dataset location us-east5)
table_2: my_project.df_test_europe_west_3.employees (dataset location europe-west3)
does not work:
table_1: my_project.df_test_us.employees (dataset location US)
table_2: my_project.df_test_us_east_5.employees (dataset location us-east5)
google.api_core.exceptions.NotFound: 404 POST
does not work:
table_1: my_project.dt_test_eu.employees (dataset location EU)
table_2: my_project.df_test_europe_west_3.employees (dataset location europe-west3)
google.api_core.exceptions.NotFound: 404 POST
What you expected to happen:
Table being copied successfully. The documentation does not clarify that multi-regional -> regional copy is not supported.
Steps to reproduce:
1 - create table in a dataset (location EU).
2 - create dataset in location europe-west-3.
3 - run the copy command with sample above.
Other information (workarounds you have tried, documentation consulted, etc):