SQL


SQL & Derived Tables
Looker Dialect Support [SQL] (4)

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…

About the SQL category [SQL] (1)

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.

[Retired] Using Native Derived Tables ( 2 3 ) [SQL & Derived Tables] (46)
Allow ability to add query hints and join hints, e.g. HASH join etc [SQL & Derived Tables] (11)
Looker over presto requires additional queries for totals [SQL] (8)
Finding previously run queries in SQL Runner [SQL] (1)
Snowflake Database Encountered An Error (More Columns Than Defined) [SQL] (1)
Concatenating Nested Repeated Records [SQL] (3)
Window Functions and Visualizations [SQL & Derived Tables] (10)
Quote identifiers (table and column names) by default? [SQL] (2)
Internal SQL Server error when i run the delete query [SQL] (2)
Internal SQL Error - Snowflake - 300002. Only occurs when view is created with a where clause [SQL] (2)
Joins using AND/OR in lookML [SQL & Derived Tables] (4)
[RETIRED] Configuring Looker to use a Teradata driver (Looker 5.16+) [SQL] (4)
Where statement on specific date? [SQL & Derived Tables] (2)
Issue Resolved [SQL] (1)
Sum of Time [SQL & Derived Tables] (3)
Inconsistent date conversions [SQL] (3)
Update(write-back) data on BigQuery from Looks? [SQL] (16)
DATEDIFF in PostgreSQL [SQL] (1)
"Resources exceeded during query execution" when building derived table in BigQuery [SQL] (3)
Join happening when it's not needed [SQL & Derived Tables] (3)
Our Redshift first-run query performance is terrible ( 2 ) [SQL] (21)
[RETIRED] Creating a Connection to Amazon Athena [SQL] (7)
Calculating KPIs with non-existent data for some employees [SQL & Derived Tables] (5)
Impala Broken in 5.20 [SQL] (5)
Repeat buy analysis problem [SQL & Derived Tables] (3)
Percentile as Dynamic User input [SQL & Derived Tables] (5)
Indexes on multiple columns in derived table [SQL & Derived Tables] (11)
[RETIRED] Connecting to Qubole's hosted Presto Service in version v4.8 [SQL] (4)