Connecting BigQuery to Looker

Question

I am new to Looker and am trying create a report from a dataset from Google BigQuery.

I tried following the Looker doc but this does not seem to work for me perfectly. I followed the steps by first creating a project in BigQuery and then creating a service account and added a key to it. I However skipped the creating PDT part and further created a BigQuery connection in Looker. The connection runs well but I do not see the tables/view in my dataset on Looker end.

Would appreciate any help.

Answer 1

You need to create models and views in Looker using LookML

Here is the next step for you : https://docs.looker.com/data-modeling/getting-started/model-development

With that, you will have explores and you can create your dashboard...

Answer 2

When u have a connection first initialized, u then create your first project inside looker, its a step by step process but it will give u the option to use default views and explore created for you. If you have an existing project then u can create custom views by using sql runner or u can click on the '+' in the file browser > click on "create view from table" > check the tables u would like to make into a view

Here is a link to how model structure is layed out https://drive.google.com/file/d/1OWik44xHMqEbZB2tzwaehMaa1MGJ0dZD/view?usp=drivesdk

Hope this helped!