Google Cloud
-
Looker 101 · Chapter 5
Join tables in Looker
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…
-
Looker 101 · Chapter 4
How to manually add measures and make your own SQL queries in Looker
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…
-
Looker 101 · Chapter 3
Dashboards and Visualizations
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…
-
Looker 101 · Chapter 2
Creating a project and getting to know LookML
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.
-
Looker 101 · Chapter 1
How to connect BigQuery to Looker
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…
-
80% Cost Reduction in Google Cloud BigQuery
Google Cloud BigQuery costs can be reduced by limiting unnecessary data scans, avoiding repeated calculations and setting query quotas to control consumption. At Investing.com, introducing quotas reduced monthly spending from…
