BigQuery - Project ID in the query should be the one that is used for jobs
I use one connection to query multiple projects but in the configuration we have a field Project ID. I didn't know if that meant billing project id or just a default.
When I make queries, I always specify a project `project-something`.dataset.table but I just realised that DataGrip doesn't use that project from the query to insert the job.
I think that's incorrect. Otherwise I have to have different connections for each project?
Please sign in to leave a comment.
I believe you are referring to connections in the query console where you should be able to select a project from the object path. If so, this is an know issue and we are working on a fix
https://youtrack.jetbrains.com/issue/DBE-19859/Schema-selection-shows-Nothing-to-show-for-BigQuery
However, if you have specified All Available Schemas under SQL in File | Settings | Editor | General | Code Completion, it should give you tables from other projects within your data source.
Please let me know if I missed anything
Hi Aleksandr,
Indeed, I see all projects under one connection but it's the Project ID I specify in configuration that is used for jobs/billing and I'd prefer if I could either choose it from the dropdown in the top right corner, or a configuration saying “use project from FROM statement”
The project selection drop-down issue in query console is currently being fixed. Please follow the issue above to stay updated on the progress