Looker Community

SQL   SQL & Derived Tables


Topic Replies Activity
Accessing nth value in templated filtering 8 May 28, 2020
How to avoid order by in Look SQL? 3 May 28, 2020
How to partition by a derived column field 1 May 5, 2020
Adding daily data to PDTs without INSERT 9 April 8, 2020
Calculate sum of column and repeat value across all rows. 5 March 17, 2020
How to execute SQL Server stored procedure from Looker 7 March 4, 2020
How to: Simple incremental PDTs using create_process 5 February 26, 2020
Scheduled task building PDT even though the PDT build trigger conditions were not met. 2 February 26, 2020
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables) 8 February 17, 2020
Totals do not adjust to liquid variables in derived table 1 January 28, 2020
When creating a snapshot table, create_process reruns too frequently 4 January 22, 2020
Percentile as Dynamic User input 6 December 19, 2019
How to count only weekdays between two dates 7 December 12, 2019
“Resources exceeded during query execution” in BigQuery because of cartesian product 3 November 30, 2019
Trying to create mixpanel style customisable funnel visualisation using liquid parameters for defining steps 4 November 7, 2019
Allow ability to add query hints and join hints, e.g. HASH join etc 12 October 31, 2019
SQL Syntax Error on PDT Create: ORA-00907: missing right parenthesis 4 October 17, 2019
Occasionally re-generator could not finish the query 1 October 2, 2019
Aggregate data for dates in range 1 September 26, 2019
Setting mysql session variables 4 September 25, 2019
Get PDT build time out of i__looker/pdt_log explore 2 August 7, 2019
How to Join on distinct dimension 4 August 6, 2019
Using CTEs in a dervied table 2 July 30, 2019
Performance issue due full table scan 1 July 10, 2019
SQL Syntax Error on a PDT Create 11 July 2, 2019
Reusing cascading derived tables (with nested filters) in multiple views 10 May 7, 2019
Can I directly query Looker internal tables such as pdt_event_log? 4 April 25, 2019
Removing PDTs from the scratch Schema 5 April 19, 2019
SubSelect not allowed in SELECT clause - BigQuery Legacy SQL 9 April 4, 2019
Window Functions and Visualizations 12 March 29, 2019