BigQuery

Join four related views under one Looker Explore: set left_outer joins, one_to_many relationships and sql_on conditions, count distinct ponies across joined tables, check fanout, and relabel or hide Explores. Examples…

Add simple aggregate measures as custom fields, write string, sum and ratio measures in LookML, then use SQL Runner to build a ranked derived table and add it to a…

Build a Looker dashboard from the eCommerce sample Explores: add visualization and Markdown tiles, format chart axes, add dashboard filters and set automatic refresh. This chapter uses the classic dashboard…

Create a Looker model and LookML project from an existing BigQuery connection, then read the generated view file: sql_table_name, dimensions, dimension groups and measures, using the original test_table example.

Connect BigQuery to Looker by creating a service account, granting it access to your data, uploading its JSON key in Looker’s connection settings and testing the connection. This chapter covers…