How to generate LookML for all datasets for BigQuery connection

Knowledge Drop

Last tested: Apr 23, 2020
 

The Problem

Looker only generates one view which is specified in connection setting as dataset even we select "All tables".

Screen Shot 2020-04-24 at 2.37.28 PM.png

Screen Shot 2020-04-24 at 11.24.21 AM.png

Screen Shot 2020-04-24 at 2.39.15 PM.png

 

A Solution

Listing all datasets ( comma-separated) in schema section in create project.

This content is subject to limited support.                

Version history
Last update:
‎07-07-2021 01:13 PM
Updated by: