|
About the SQL category
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?
|
1
|
February 15, 2020
|
|
String contains key:value pairs. How to extract value for user-provided key ?
|
1
|
February 7, 2020
|
|
Totals do not adjust to liquid variables in derived table
|
1
|
January 28, 2020
|
|
Proper case for BigQuery
|
3
|
January 30, 2020
|
|
Looker Snowflake session tagging
|
2
|
January 29, 2020
|
|
When creating a snapshot table, create_process reruns too frequently
|
4
|
January 22, 2020
|
|
Cannot connect: connection refused
|
2
|
January 2, 2020
|
|
No results in SQL runner query ends up with error "Couldn't run your query due to a server error."
|
7
|
December 30, 2019
|
|
Percentile as Dynamic User input
|
6
|
December 19, 2019
|
|
Looker is creating a convoluted sql query that is not performant
|
2
|
December 18, 2019
|
|
Difficulty with cancel_grouping_fields - Table of flat numbers doesn't need GROUP BY
|
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
|
3
|
December 11, 2019
|
|
Selecting column dynamically in a dimension
|
5
|
December 10, 2019
|
|
Calculating measures as an "as-at" value
|
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
|
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"
|
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
|
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
|
7
|
August 14, 2019
|
|
How to: Simple incremental PDTs using create_process
|
3
|
August 12, 2019
|
