|
Looker Dialect Support
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
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
|
1
|
April 4, 2019
|
|
Our Redshift first-run query performance is terrible
|
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`
|
2
|
March 27, 2019
|
|
How sumarize leave time to max date of order - mysql
|
1
|
March 27, 2019
|
|
How Looker treats weeks (Bigquery, Non-UTC Timezone)
|
6
|
March 25, 2019
|
|
How to sumarize “sickness time” to the end of order - mysql
|
2
|
March 25, 2019
|
|
Two WITHs
|
3
|
March 19, 2019
|
|
Error on outer join: only supported with merge-joinable conditions
|
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?
|
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
|
4
|
September 21, 2018
|
|
Cannot connect: Time zone tables don't appear to be loaded in MySQL
|
6
|
January 9, 2015
|
|
PostgreSQL Timesamp Error
|
3
|
March 13, 2019
|
|
"Order by" hurts redshift performance
|
4
|
October 12, 2016
|
|
Using interval on mysql
|
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
|
8
|
February 6, 2019
|
|
Finding previously run queries in SQL Runner
|
1
|
February 12, 2019
|
|
Snowflake Database Encountered An Error (More Columns Than Defined)
|
1
|
February 8, 2019
|
|
Concatenating Nested Repeated Records
|
3
|
December 20, 2018
|
|
Quote identifiers (table and column names) by default?
|
2
|
December 12, 2016
|
