SQL


SQL & Derived Tables
Topic Replies Created
Looker Dialect Support
SQL

About Looker Dialect Support Looker supports a wide range of databases and dialects. Because Looker is committed to supporting cutting-edge technology—and because our product works best with some of the most advanced dia…

5 April 5, 2016
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
Removing PDTs from the scratch Schema 2 March 23, 2015
Finding % of Month completed
SQL
1 April 4, 2019
Our Redshift first-run query performance is terrible
SQL
24 March 29, 2018
SubSelect not allowed in SELECT clause - BigQuery Legacy SQL 9 January 26, 2017
Window Functions and Visualizations 12 February 1, 2017
Joins with `USING` instead of `ON`
SQL
2 March 27, 2019
How sumarize leave time to max date of order - mysql
SQL
1 March 27, 2019
How Looker treats weeks (Bigquery, Non-UTC Timezone)
SQL
6 March 25, 2019
How to sumarize “sickness time” to the end of order - mysql
SQL
2 March 25, 2019
Two WITHs 3 March 19, 2019
Error on outer join: only supported with merge-joinable conditions
SQL
3 March 18, 2019
Adding daily data to PDTs without INSERT 4 March 18, 2019
Volatile Table Availability and Location 3 March 14, 2019
Maximum Character/Row Limit for the actual SQL Code in SQL Runner?
SQL
5 March 16, 2018
How to manually rebuild persistent derived tables 5 March 19, 2015
TinyInt converted to Boolean whether or not it's used as one
SQL
4 September 21, 2018
Cannot connect: Time zone tables don't appear to be loaded in MySQL
SQL
6 January 9, 2015
PostgreSQL Timesamp Error
SQL
3 March 13, 2019
"Order by" hurts redshift performance
SQL
4 October 12, 2016
Using interval on mysql
SQL
2 March 4, 2019
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
Looker over presto requires additional queries for totals
SQL
8 February 6, 2019
Finding previously run queries in SQL Runner
SQL
1 February 12, 2019
Snowflake Database Encountered An Error (More Columns Than Defined)
SQL
1 February 8, 2019
Concatenating Nested Repeated Records
SQL
3 December 20, 2018
Quote identifiers (table and column names) by default?
SQL
2 December 12, 2016