Can we perform table joins in two different projects in BigQuery?

Question

I have two projects with data sets. I want to merge one table from the first project into a table in the second project. How can i do this? Request?

Answer 1

Oh sure. You must assign the table name to the project name, i.e. Project name: dataset.table Here is an example of my joining one of my tables against a table in a publicdata project:

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