|
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 16, 2019
|
|
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
|
|
When creating a snapshot table, create_process reruns too frequently
|
2
|
August 18, 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
|
|
Get PDT build time out of i__looker/pdt_log explore
|
2
|
August 7, 2019
|
|
How to Join on distinct dimension
|
4
|
August 6, 2019
|
|
SQL Syntax Error on PDT Create: ORA-00907: missing right parenthesis
|
2
|
August 5, 2019
|
|
Adding daily data to PDTs without INSERT
|
6
|
August 2, 2019
|
|
Using CTEs in a dervied table
|
2
|
July 30, 2019
|
|
Finding closest matches by name in BigQuery
|
4
|
July 15, 2019
|
|
Performance issue due full table scan
|
1
|
July 10, 2019
|
|
SQL Syntax Error on a PDT Create
|
11
|
July 2, 2019
|
|
API SQL Access
|
2
|
June 26, 2019
|
|
Update (write-back) data on Snowflake from Looks
|
2
|
June 19, 2019
|
|
Modeling Nested Data in Snowflake
|
3
|
June 6, 2019
|
|
TRUNC_DAYS() in Redshift with and without time zones
|
2
|
June 4, 2019
|
|
Word Frequency Analysis / Word Clouds: Analytical Pattern
|
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
|
2
|
May 8, 2019
|
|
Dimension SQL: Self-Join
|
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
|
2
|
May 2, 2019
|
|
Denodo7 Connection Configuration
|
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
|
1
|
April 4, 2019
|
|
Our Redshift first-run query performance is terrible
|
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
|
