Do PDTs behave different in Dev Mode?
I was testing a PDT in dev mode that took about an hour to complete, but it seemed to keep getting cancelled b...
Forum Posts
Using a Filter value to execute only part of Derived Query
I have the following derived query:derived_table: { sql:select * from this_yearunion allselect * from last_yea...
There is a way to avoid filtering at the end of the query?
Hi guysI’m starting to use Looker, I want to create a model to be use for multiples user on his dashboards. Wh...
Looker Aggregate query contained the following measures we cannot roll up
Hello Everyone,I am rather new to Looker and am trying to setup an Aggregate Awareness to speed up some of our...
Filtering multiple columns
Hello, I have an issue that I am trying to solve. I have looked at multiple thread on the forum, but I have no...
Database Partitions: Troubleshooting
DB Concepts Series: Troubleshooting PartitionsPost Context: This content is adapted from our internal SME (Sub...
Database Partitions: How they work
DB Concepts Series: What partitions are, and how they're usedPost Context: This content is adapted from our in...
A (Hitchhiker's) Guide to Query Performance in Looker
Problem: You’ve written alot of very nice LookML, but your data is >20TB and queries take forever. This isn’t ...
difference between dates and grouping the results by another dimension
can someone help me with how to find the difference between 2 dates? date_diff() or diff_days() is not working...
How To: Smart Partition Key Filtering with Liquid
Problem: We have multiple partitioned tables, and are joining them into an explore. To improve query performan...
Tile/Explore Performance (Joins, PDTs, NDTs, etc.)
Hi, We currently have an explore which is a combination of multiple views (NDTs, PDTs, etc.) and were wonderin...