Selected articles about SQL use cases in Looker

We have gathered a list of community and help center articles organised in different topics. Hope this makes it easier for you to search and navigate.

Calendar table

How to combine a retail calendar with retail sales data

Generate Date Series/ Create a calendar view of future dates

Generating a sequence of numbers or dates

How to Set Multiple Week Definitions in Looker

Conditional join

CASE in sql_on: Conditional Joins when field = value

Datagroup

PDT trigger value at a specific time and day of week, once a week

How to trigger datagroup/PDT rebuilds X minutes past each hour between certain hours of the day

Parsing data

Parsing JSON data in Looker

Using Postgres and JSON Functions and Operators to Parse JSON Fields

Defining JSON Objects as LookML Dimensions

Query performance

EXPLAIN function

A (Hitchhiker’s) Guide to Query Performance in Looker

SQL in LookML fields

Case when lookml vs. sql

case when on yes/no fields

Dynamic rolling week buckets

Subqueries

Can I put a subquery in a dimension?

Unnesting data

Unnesting in BQ sql

Unnesting in general

Window functions

Window Functions in Looker

SQL examples for Window Functions