How to give access to a single Bigquery Dataset for a user to access the data in Datalooker?

I am able to give access to a single dataset and access only that dataset in the console.

So it's a Bigquery Data Editor and he can create tables, run SQL's and so on.

But I need for this user to also have access only to this Dataset using DataLooker:

What I tried:

• giving bigquery user access to the project (but then it has access to all dataset)
• I tried filtering this access by dataset using IAM condition but doesn't work.
• not having access as Bigquery User he can't see the project in datalooker

Any ideas?

You need to assign roles at two different levels:

1. Assign the BigQuery Data Editor role at the Dataset level

When applied to a dataset, this role provides permissions to:

Read the dataset's metadata and list tables in the dataset. Create, update, get, and delete the dataset's tables.

2. At the project level, you need to assign a role with the resourcemanager.projects.list and resourcemanager.projects.get permissions. While I recommend the Browser role for general browsing access, if you want to run queries and jobs, you should assign the BigQuery Job User role instead. This role provides additional permissions needed for running queries and jobs, effectively replacing the Browser role.

   • Read access to browse the hierarchy for a project, including the folder, organization, and allow policy.
   • This role doesn't include permission to view resources in the project.