I have 2 BigQuery Datasets - one based in the US and the other in London.
I want to move the data from the US location table to London location table using the following SQL:
INSERT INTO `London_Dataset.TARGET_TABLE`
SELECT * FROM `US_Dataset.SOURCE_TABLE`
However, the SQL fails as if I process the query in US location then it cannot find the London dataset and vice-versa.
Can anyone please give me ideas to accomplish this?
Thanks a lot, Sri.
