Add another project on the sidebar with single service account

[tim-watcha]

I have one service account connected to default project, but that service account also have permission to another projects too.
It seems like I can only add default project for the service account. please add a functionality to explore another projects on the side bar. thank you for the great project!

[archiewood]

thanks for the suggestion. was not aware this was a possible pattern

[archiewood]

On a bit of research, this is not super easy - BigQuery requires that you specify which project you are connecting to, so we cannot return all the projects using a SQL query (which is how the explorer is populated).

As a workaround if you use a service account, I suspect you could change the project-id in the JSON keyfile if you wanted to access the other project.

[lhz]

Running query jobs in one project that selects data from tables and views in a different project or even multiple projects in the same query is a very common pattern in BigQuery.