LookML   SQL & Derived Tables


Summarizing over Start and End Dates (3)
SQL Pattern: Summarizing entities with a start/end date over time (1)
Changing PDT with templated filter. PDT does not rebuilt? (2)
How to count only weekdays between two dates (5)
Horizontal -> Vertical, multiple values? (2)
Fill forward: Possible? (4)
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables) (7)
User attributes and derived tables causes regenerator errors (2)
Update PDT when both tables are updated (3)
How to avoid order by in Look SQL? (2)
Update and insert PDT instead of reload (6)
Dropdown in explore to change column in a derived table (2)
View PDT (Persistent Derived Tables) details (2)
Looker user attributes and `if dev` to auto-switch between dev & prod schemas (4)
Scheduling PDT on day of week at a specific time (3)
Unknown parameter "indexes" in derived table definition (4)
Datagroup on max id from the table and date of the view? (4)
Flag Insert Update and delete source record in target using informatica (1)
PDT Naming: Development vs Production (3)
Uses of if dev (3)
Error: Illegal mix of collations (7)
Join derived table to itself (2)
[Retired] Using Native Derived Tables ( 2 3 ) (44)
Grouping dimension with contains of another dimension (3)
Cumulative Sum in MySQL (6)
Partial PDT Persistence (4)
Context Comments (9)
Daily average - Custom measure (10)
SubSelect not allowed in SELECT clause - BigQuery Legacy SQL (8)
Using Table Value Functions as a derived table with Paramters (2)