Google Big Query doesn't show only project specific datasets

Question

I have three projects on GCP which play the role of three environments (dev, staging, prod. Each of them has a corresponding dataset on Big Query created as follows:

bq --location=${REGION} mk \
--dataset \
${DEVSHELL_PROJECT_ID}:mydataset

bq mk \
--table \
${DEVSHELL_PROJECT_ID}:mydataset.mytable \
schema.json

When executing that in the dev shel on GCP, I have my Dev project selected.

And, when I execute

bq ls

in the shell I can see only this dataset available there which is expected.

After that, after switching to another project and executing

bq ls

Again, only one data set is visible and it is the one dedicated to the staging environment, for example. But when I open the UI of Google Big Query (using the staging project), I can see my Dev environment/project dataset.

I am wondering why is that and is it normal and expected?

Answer 1

It is totally normal behavior. The Resources section contains a list of pinned projects. Expand a project to view datasets and tables that you have access to. You can manually pin/unpin your datasets in each project. A search box is available in the Resources section that allows you to search for resources by name or by label.

Please, refer to official documentation. I hope it helps.