REPLACE Characters in string filters
Knowledge DropLast tested: Jul 30, 2019 If you see odd results in a drill's filter string, it may be that the ...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
PDT trigger value at a specific time and day of week, once a week
Knowledge DropLast Tested: Mar 22, 2021 This trigger changes weekly at 6 am on Monday:MSSQL: SELECT FLOOR((DAT...
What does the MD5 function do?
Knowledge DropLast tested: March 2021MD5 is just a hash that turns strings into hashes.It's useful for making ...
Why isn't my date field being timezone converted in the WHERE clause?
Knowledge DropLast tested: Jan 23, 2018 This question comes up from time to time and the answer is that the pa...
How to sort by rolling month
Knowledge DropLast tested: Oct 4, 2019 To sort their data by current month for ex: October 2019 thru November ...
CSV to SQL Tool
Knowledge DropLast tested: Jun 13, 2020 The ProblemYou have a CSV and you want to explore it in Looker. You kn...
Does calling ${sql_table_name} in SQL Runner use Dev mode PDTs?
Knowledge DropLast tested: Jan 17, 2019 When you call ${sql_table_name} in SQL Runner, if you're in dev mode, ...
How do I make a primary key for my dimension group (timestamp, date)?
Knowledge DropLast tested: May 11, 2020 Since a dimension group is a collection of dimensions, you can't make ...
Why does my tier have an "Undefined" tier?
Knowledge DropLast tested:May 7, 2018 If the value is null if the style is set to integer but continuous value...
How to write a correlated subquery in a measure
Knowledge DropLast tested: Dec 9, 2019 The ProblemI want to write a correlated subquery, but I'd like to do it...
Dealing with reserve Words in Athena
Knowledge DropLast tested: Apr 13, 2020 Scenario:We have a table in that we want to query in Athena, whose col...
Can I use the `value` liquid variable in sql parameters?
Knowledge DropLast tested: Jun 22, 2020 No. You can check the Usage column in the liquid variable reference in...
Query execution failed: - FULL OUTER JOIN cannot be used without a condition that is an equality of fields from both sides of the join
Knowledge DropLast tested: Aug 28, 2020 We see this happen in Standard SQL (BigQuery uses Standard SQL as the ...
Expected \"(\" or keyword SELECT but got keyword WITH at
Knowledge DropLast tested: Jan 17, 2019 This is one example of an error you can get by using a CTE in a derive...
What purpose does the `sql:` clause in a Templated Filter serve?
Knowledge DropLast tested: Nov 23, 2018 The sql: clause in a Templated Filter gets injected directly into the ...
SQL Error: "Syntax error at or near:"
Knowledge Drops Last tested: Feb 2021OverviewThis SQL error generally means that somewhere in the query, there...
SQL Error: relation "schema.table" does not exist"
Knowledge DropLast tested: Feb 2021This error message can appear when a table no longer exists but still shows...
Does Looker account for daylight savings?
Knowledge DropLast tested: Dec 18, 2018 Yes.The timezone rules for the specified timezone will be followed. Th...
Can you save explores created from sql runner as a look or to a dashboard?
Knowledge DropLast tested: Aug 9, 2019 It is not possible to do that in Looker at the moment. You can vote for...
Why is my dimension not getting grouped by?
Knowledge DropLast tested: Sep 15, 2019 By default, Looker will group by all dimensions selected. So it might ...
BIGQUERY (HowTo): BigQuery Cluster and Partition Best Practices
Knowledge DropLast tested: Sep 21, 2018Default to INNER join If LEFT is required, denormalize, nest, or figure...
Selected articles about SQL use cases in Looker
Selected articles about SQL use cases in LookerWe have gathered a list of community and help center articles o...
Can I include an aggregate in a sql_on: clause?
Knowledge DropLast tested: Jul 1, 2020 Nope - in SQL order of operations, joins come before aggregation, there...
No Matching Signature for operator >= for argument types: TYPE, OTHER TYPE
SQL Error Series #1: Type ErrorsPost Context: This content is adapted from our internal SME (Subject Matter Ex...
Can I create view files from db views?
Knowledge DropLast tested: Nov 24, 2020 Yes. However, you may have to do it SQL Runner because the generator w...
How to check the data type of a table's columns [Examples: MYSQL, POSTGRESQL, REDSHIFT, BIGQUERY]
Knowledge DropLast tested: Jan 21, 2019 In SQL Runner, you can use these queries:MySQL:SELECTCOLUMN_NAME, DATA...
Why is SQL Runner not showing all of my tables?
Knowledge DropLast tested: May 2020SQL Runner only shows the first 500 tables that the Looker database user ha...
Can I remove GROUP BY in Looker-generated SQL?
Knowledge DropLast tested: April 2021By default, Looker will group by all dimensions selected. The exception t...
Advanced LookML - Intro Aggregate Awareness
Knowledge DropLast tested: Jun 24, 2019 This is a useful method if you have summary tables defined in your ETL...
Why does the exact same SQL run fine in SQL Runner but errors in Explore?
Knowledge DropLast Tested: Jan 21, 2019In some instances, the same exact SQL will run perfectly fine in SQL Ru...
