SQL


SQL & Derived Tables
Topic Replies Activity
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 16, 2019
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
SQL Syntax Error on a PDT Create 2 June 17, 2019
Update (write-back) data on Snowflake from Looks
SQL
1 June 13, 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
Dimension SQL: Self-Join
SQL
6 May 7, 2019
Reusing cascading derived tables (with nested filters) in multiple views 10 May 7, 2019
Connecting Looker to Hive with Kerberos Authentication
SQL
2 May 2, 2019
Denodo7 Connection Configuration
SQL
1 April 26, 2019
Can I directly query Looker internal tables such as pdt_event_log? 4 April 25, 2019
Removing PDTs from the scratch Schema 5 April 19, 2019
Finding % of Month completed
SQL
1 April 4, 2019
Our Redshift first-run query performance is terrible
SQL
24 April 4, 2019
SubSelect not allowed in SELECT clause - BigQuery Legacy SQL 9 April 4, 2019
Window Functions and Visualizations 12 March 29, 2019
Joins with `USING` instead of `ON`
SQL
2 March 28, 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 27, 2019
How to sumarize “sickness time” to the end of order - mysql
SQL
2 March 26, 2019
Two WITHs 3 March 24, 2019
Error on outer join: only supported with merge-joinable conditions
SQL
3 March 20, 2019
Adding daily data to PDTs without INSERT 4 March 20, 2019
Volatile Table Availability and Location 3 March 19, 2019
Maximum Character/Row Limit for the actual SQL Code in SQL Runner?
SQL
5 March 18, 2019
How to manually rebuild persistent derived tables 5 March 15, 2019
TinyInt converted to Boolean whether or not it's used as one
SQL
4 March 15, 2019