Can Looker connect to different Big Query Datasets that lies in the same Big Query Project?

[redbarchetta]

Hi everybody

When setting up a Connection (Big Query Standard SQL Dialect) in my Looker Instance, I’m asked to provide a Project ID and a Dataset name (that must be located within the Project).

The BQ views and tables I’d like to “connect” with are located in 2 different BQ  Datasets (within the same BQ Project).

Is there a way to set my Looker Connection so that views and tables from both Dataset 1 and Dataset 2 are available? 

Thank’s for helping

[hgoscar · Accepted solution]

You are good as long as the BQ service account has access to the project and datasets .  

Dataset* : 
(If you do not use fully qualified table names in your LookML views, this is the dataset where BigQuery will look for your tables)