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\nselect sum(a.is_male)\nfrom\n(select is_male, year from publicdata.samples.natality) a\ninner join\n(select year from moshap.my_years) b\non a.year = b.year\n
Atori
posted onEnjoy 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
Post Comment