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

Looker Q&A Looker
1

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

2

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)

1 Like