Looker Community

SQL


SQL & Derived Tables
Topic Replies Activity
About the SQL category
SQL

For all your SQL errors, troubleshooting questions, and cool queries If you have a question or post about a PDT, please make that in the appropriate subcategory.

1 December 11, 2014
BigQuery UDFs in Derived Tables (or sql_preamble in Native Derived Tables) 8 February 17, 2020
How to Use ThetaSketch for COUNT DISTINCT on Druid?
SQL
1 February 15, 2020
String contains key:value pairs. How to extract value for user-provided key ?
SQL
1 February 7, 2020
Totals do not adjust to liquid variables in derived table 1 January 28, 2020
Proper case for BigQuery
SQL
3 January 30, 2020
Looker Snowflake session tagging
SQL
2 January 29, 2020
When creating a snapshot table, create_process reruns too frequently 4 January 22, 2020
Cannot connect: connection refused
SQL
2 January 2, 2020
No results in SQL runner query ends up with error "Couldn't run your query due to a server error."
SQL
7 December 30, 2019
Percentile as Dynamic User input 6 December 19, 2019
Looker is creating a convoluted sql query that is not performant
SQL
2 December 18, 2019
Difficulty with cancel_grouping_fields - Table of flat numbers doesn't need GROUP BY
SQL
5 December 16, 2019
How to count only weekdays between two dates 7 December 12, 2019
Capturing count of records for a date between two dates
SQL
3 December 11, 2019
Selecting column dynamically in a dimension
SQL
5 December 10, 2019
Calculating measures as an "as-at" value
SQL
3 December 5, 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
Reference View in SQL Runner
SQL
3 November 4, 2019
Allow ability to add query hints and join hints, e.g. HASH join etc 12 October 31, 2019
Error when running a Look: "There was a problem running the query"
SQL
1 October 29, 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
Date handling from LookML to SQL Server, suggestions
SQL
6 September 27, 2019
Aggregate data for dates in range 1 September 26, 2019
Adding daily data to PDTs without INSERT 8 September 25, 2019
Setting mysql session variables 4 September 25, 2019
How to split a number with dots in a column
SQL
7 August 14, 2019
How to: Simple incremental PDTs using create_process 3 August 12, 2019