17 August 2018 · Atori ·       Add to Favorites   Report

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

select sum(a.is_male)
(select is_male, year from publicdata.samples.natality) a
inner join
(select year from moshap.my_years) b
on a.year = b.year


posted on 17 August 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too