View the original community article here
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.
Troubleshooting
Common SQL error troubleshooting tips in Looker
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
Using Postgres and JSON Functions and Operators to Parse JSON Fields
Defining JSON Objects as LookML Dimensions
Query performance
A (Hitchhiker’s) Guide to Query Performance in Looker
SQL in LookML fields
Subqueries
Can I put a subquery in a dimension?
Unnesting data