How to join two tables in two different projects in Google BigQuery?
For Example, Consider you have two projects having datasets. I want to perform a join of one table from the first project to table in the second project
Yes, you certainly can. You need to qualify the table name with the project name
#StandardSQL select sum(a.is_male) from (select is_male, year from publicdata.samples.natality) a inner join (select year from moshap.my_years) b on a.year = b.year
Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds