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.
Common SQL error troubleshooting tips in Looker
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
CASE in sql_on: Conditional Joins when field = value
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
Using Postgres and JSON Functions and Operators to Parse JSON Fields
Defining JSON Objects as LookML Dimensions
A (Hitchhiker’s) Guide to Query Performance in Looker
SQL in LookML fields
Can I put a subquery in a dimension?