I'm using Datagrip as Editor from my data sources in Bigquery. Everything is ok when I add a project with a service account into datagrip and make queries only from this project. But when I want to make a query between to different tables from different projects or data sources of Bigquery, Datagrip doesn't allow me.
This is the query running in bigquery editor console
I follow these steps to connect a project from bigquery into a datasource in: https://blog.jetbrains.com/datagrip/2018/07/10/using-bigquery-from-intellij-based-ide/