Looker tips for users, developers and admins
Substitution and sql_table_name
Requiring Field Usage
A clever way to make sure that users can’t run incorrect Explore queries and get some feedback if they try.
Conditionally Protecting PII
See how you can stop users from using certain fields together in a query which together could personally identify individuals.
Custom Timeframes for Dimension Groups
How to use SQL and LookML to define an arbitrary custom timeframe as part of a LookML dimension group.
Getting Creative with Constants
Some interesting ways to use LookML constants in your projects.
Custom Code Folding
How to fold your LookML and SQL code in arbitrary places to keep your files organised and easy to navigate.
Debugging Deftly
A few tips that will help you debugging various problems when developing LookML
HTML Header Hack
How to build a header for your dashboards with configurable ‘previous’ and ‘next’ links.
Tips for Looker Developers
A few tips that’ll make your like as a Looker developer better
Love Liquid
Some of the many uses for the Liquid templating language within Looker
Adding a hidden field to a query
How to use the ‘Expanded Share URL’ to add a hidden field to your query