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
How to count only weekdays between two dates 9 November 7, 2019
Trying to create mixpanel style customisable funnel visualisation using liquid parameters for defining steps 4 November 7, 2019
No results in SQL runner query ends up with error "Couldn't run your query due to a server error."
SQL
3 November 5, 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
JOIN 2017- Deep Dive - PDTを利用するかどうか 1 October 23, 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
When creating a snapshot table, create_process reruns too frequently 2 August 18, 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
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
Finding closest matches by name in BigQuery
SQL
4 July 15, 2019
Performance issue due full table scan 1 July 10, 2019
SQL Syntax Error on a PDT Create 11 July 2, 2019
API SQL Access
SQL
2 June 26, 2019
Update (write-back) data on Snowflake from Looks
SQL
2 June 19, 2019
Modeling Nested Data in Snowflake
SQL
3 June 6, 2019
TRUNC_DAYS() in Redshift with and without time zones
SQL
2 June 4, 2019
Word Frequency Analysis / Word Clouds: Analytical Pattern
SQL
2 May 31, 2019
“Resources exceeded during query execution” in BigQuery because of cartesian product 1 May 31, 2019
Modeling nested data in Big Query Standard SQL
SQL
2 May 8, 2019