SQL   SQL & Derived Tables


Topic Replies Created
Reusing cascading derived tables (with nested filters) in multiple views 10 January 27, 2017
Can I directly query Looker internal tables such as pdt_event_log? 4 April 24, 2019
Removing PDTs from the scratch Schema 5 March 23, 2015
SubSelect not allowed in SELECT clause - BigQuery Legacy SQL 9 January 26, 2017
Window Functions and Visualizations 12 February 1, 2017
Two WITHs 3 March 19, 2019
Adding daily data to PDTs without INSERT 4 March 18, 2019
Volatile Table Availability and Location 3 March 14, 2019
How to manually rebuild persistent derived tables 5 March 19, 2015
Looker user attributes and `if dev` to auto-switch between dev & prod schemas 5 June 13, 2018
[Retired] Using Native Derived Tables 46 July 14, 2017
Allow ability to add query hints and join hints, e.g. HASH join etc 11 February 4, 2019
Joins using AND/OR in lookML 4 December 27, 2018
Where statement on specific date? 2 December 4, 2018
Sum of Time 3 November 21, 2018
Join happening when it's not needed 3 November 8, 2018
Calculating KPIs with non-existent data for some employees 5 October 28, 2018
Repeat buy analysis problem 3 October 26, 2018
Percentile as Dynamic User input 5 October 18, 2018
Indexes on multiple columns in derived table 11 June 30, 2015
Summarizing over Start and End Dates 3 September 13, 2018
SQL Pattern: Summarizing entities with a start/end date over time 1 April 30, 2017
Changing PDT with templated filter. PDT does not rebuilt? 2 September 7, 2018
How to count only weekdays between two dates 5 September 8, 2016
Horizontal -> Vertical, multiple values? 2 August 24, 2018
Fill forward: Possible? 4 August 17, 2018
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables) 7 August 13, 2018
User attributes and derived tables causes regenerator errors 2 August 3, 2018
Update PDT when both tables are updated 3 July 16, 2018
How to avoid order by in Look SQL? 2 July 12, 2018