In the Big Query Data Transfer Service, I have linked Dataset 1 to the Search Ads 360 data transfer. Now I can see 20+ tables in Dataset1. Is it possible to move these 20+ tables to Dataset2 which will be dedicated to Search Ads data.
Asked
Active
Viewed 1,674 times
0
-
recreate the transfer service wth dataset2 – Pentium10 Jul 06 '21 at 10:26
-
Thankyou, but does it will remove the tables created under dataset1 – Awanish Dubey Jul 06 '21 at 10:40
-
transfer service doesn't delete anythig, you need to cleanup – Pentium10 Jul 06 '21 at 13:13
1 Answers
1
No, it is not possible to move the 20+ tables from dataset1 to dataset2 in BigQuery. Instead of moving the tables to dataset2, you can create a one time copy of the dataset in supported regions using the Copy Dataset icon or on a customized recurring schedule using BigQuery Data Transfers with Source Type as Dataset Copy. It does not delete any tables in dataset1. It just creates a copy of dataset1 in dataset2. Then, later delete the unwanted tables from dataset1/dataset2 by using the Delete icon or querying. If you want to copy a single table from dataset1 to dataset2, use the Copy icon from the source table. But, the source and destination datasets must be in the same location. See Supported Regions and Copy Dataset for more information.
Vishal K
- 1,368
- 1
- 7
- 15