Service Account for Looker and BigQuery dataset

[LeonChristie]

Hi there,

I'm new to GCP and I need to set up a service account so a specific client can use a dashboard of their data which is stored on BigQuery. I'm not quite sure how I do this to set up the appropriate permissions. I've looked at the documentation but there seems to be a lot of different topics around these areas and its proving hard for me to distinguish the right resources with my current knowledge level, due to the cognitive load required to get a full picture.

I was wondering if anyone could kindly help by providing some of their own knowledge or point me in the in the right direction of documentation?

I've noticed there is also an OAuth option but again it's not clear to me the relevant distinctions between the two approaches. Not sure if this is adding more unnecessary cognitive load to the task or if it is something I should be considering. If the later, would ofcourse welcome any advice here also.

Many thanks!

[lsolatorio]

Hi @LeonChristie, 

Thank you for reaching out to the community. I understand that there is a ton of documentation available for different GCP services and I hope these guides will help you set up your needed dashboard:

• Create service accounts
• Authentication with BigQuery service accounts
• Connect to Google BigQuery

Here are some related guides that can be useful in understanding permissions and roles:

• IAM permissions reference
• IAM basic and predefined roles reference

In case you are working on two different projects for your Looker and BigQuery, here are some good references:

• Data location and transfers
• Manage access to projects, folders, and organizations

I hope these links narrow your search and succeed in setting up your dashboard.