Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started114 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments13 Challenge10
Looker developmentLookML1565 SQL284
Exploring & curating dataExplores491 Dashboards & looks1356
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration415
Data science & analyticsGot a question?69 Share your best practices16
コミュニティフォーラム (Japanese)ニュースと告知43 ヘルプとサポート11 コラム69
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 Blog Archives3 DCL Mic Drops5

Ask question / Create topic
Login

Community
The Kitchen Table
Technical Tips & Tricks

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

1,659 Topics
172 Replies

When you subscribe we will email you when there is a new topic in this category

1659 Topics

Most views

Recently active Most replies Newest first

Article SQL Error: "Syntax error at or near:"

Last tested: Feb 2021 Overview This SQL error generally means that somewhere in the query, there is invalid syntax.Some common examples:Using a database-specific SQL for the wrong database (eg BigQuery supports DATE_ADD, but Redshift supports DATEADD) Typo in the SQL (missing comma, misspelled wor...

Article Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials

Last tested: Jan 20, 2021If you're seeing this error, check to see if the table that is being queried is a google sheet that's stored in Drive.If that's the case, make sure that the Service Account for BQ that Looker is using has access to the Drive. This content is subject to limited support. ...

Article How to check the data type of a table's columns [Examples: MYSQL, POSTGRESQL, REDSHIFT, BIGQUERY]

Last tested: Jan 21, 2019 In SQL Runner, you can use these queries:MySQL:SELECTCOLUMN_NAME, DATA_TYPEFROMINFORMATION_SCHEMA.COLUMNSWHERETABLE_SCHEMA = 'db_name'ANDTABLE_NAME = 'table_name'ANDCOLUMN_NAME = 'column_name PostgreSQL:pg_typeof(col_name) Redshift:SELECT "column", typeFROM PG_TABLE_DEFWHER...

Article Advanced LookML - Liquid Use Cases

Last tested: Aug 28, 2019 Liquid is an open-source, Ruby-based template language created by Shopify It can be used in conjunction with LookML to build a more flexible, dynamic code.Liquid code is denoted by braces { } and falls into 3 different categories:TAG: {% %}used to create logicOBJECT:{{ }},...

User does not have bigquery.jobs.create permission in project error

If we are hitting the error “BigQuery connection is hitting this error User does not have bigquery.jobs.create permission in project `project_name`” for a connection where we have granted the user the BigQuery Data Editor and BigQuery Job User role already then we may need to check our value for th...

Article Refused to display 'https://somedomain.com' in a frame because it set 'X-Frame-Options' to 'sameorigin'

Last tested: Nov 7, 2018 Let's conquer this beast.First things first. What the heck is an origin?It's the combination of protocol, domain, and port:{protocol}://{domain}:{port} --> https://developer.mozilla.org:443 OK, Got it. What about sameorigin?It's a policy designed to prohibit the display o...

Article How do I filter out null in a filtered measure?

Last tested: May 2020Most of these examples can be found in the filter expressions doc.Filter out NULL values for non-number dimensionsThe most common filter syntax to filter out nulls is simply "-NULL" . This works for most data types that aren't numbers, such as strings, dates, etc.measure: count...

Article SQL Pattern: How can I count the number of comma separated values in a string?

Last tested: Aug 16, 2017 This might not be a common request, but the method to do so is below:SELECT (LENGTH(Col2) - LENGTH(REPLACE(Col2,",","")) + 1) AS MyCol2CountFROM MyTable Basically, you replace all occurrences of , with an empty string "", then subtract its LENGTH from the LENGTH of the unad...

Article Parsing JSON data in Looker

Last Tested: Apr 3, 2019 Looker doesn't have a native JSON field type.Workaround 1: SQL OperatorsYou'll want to use JSON parsing functions in SQL, like json_extract_path in Postgres and JSON_EXTRACT in BigQuery to extract the JSON and put it into a type that Looker can accept, like a string.There ar...

No Matching Signature for operator >= for argument types: TYPE, OTHER TYPE

SQL Error Series #1: Type Errors Post Context: This content is adapted from our internal SME (Subject Matter Expert) curricula. Similar to knowledge drops, this content may be highly Looker specific and may become out of date in the future. The goal is to convey a high level understanding of a commo...

Article How do you reference a yesno dimension field value?

Last tested: March 2021Looker’s “yesno” dimensions return boolean values (TRUE or FALSE) rather than a string “yes” or “no”. For this reason, when SQL is involved, you don’t need to write “field == yes”, you can simply write “field”, as this will return TRUE or FALSE by itself. Here are specific exa...

Article Window Functions in Looker

Last tested: April 2021 How do I use window functions in Looker?Window functions are a very powerful tool in SQL because they perform post-aggregation calculations. There are two main ways to implement window functions in Looker:1: Use Table CalculationsCalculating after aggregations is exactly what...

Article How do I get an image or gif on my dashboard's text tile or project readme?

Last Tested: May 15, 2020 Option 1: IF YOU HAVE A PUBLICLY ACCESSIBLE URL TO THE IMAGEYou can do this by using html in the title, subtitle, or body parameter of your text tile. Note, that the image you'd like to display needs to be on the public internet (practically speaking, what this means is tha...

Article Can I filter data using table calculations?

Last Tested: Feb 4, 2019 Indirectly yes, example in Looker Docs here.The trick is to use "hide no's from visualization". This requires you to have your "filter condition" as a boolean table calc.Note that this isn't actually filtering in the SQL clause, and that this will only work on result sets wi...

Article How do I do a ROW_NUMBER OVER (PARTITION BY ...) with a table calc?

Last Tested: Jul 1, 2018 match(${products.brand},${products.brand})if(${partition}=offset(${partition},-1) , 1+row()-${partition} , 1 This content is subject to limited support.

Article Why isn't embed working in Safari? Are there browser settings we need to set for SSO embed content?

Last tested: Jan 21, 2021 Some browsers have their nuances.Safari and firefoxSafari disables third party cookies by default if the user has not previously visited the host of the iframe, so users will have to enable third party cookies in their privacy settings by disabling the setting Prevent Cross...

Article Advanced LookML - Cohort and Retention Analysis

Last tested: Jun 24, 2019 What is a Cohort Analysis?Read this data tutorial here (5 minutes) and check out this introduction video to learn about the fundamentals about cohort analysis: What’s the point of Cohort Analysis?The goal of a cohort analysis is to analyse the performance of cohorts relativ...

Article How to hide/filter certain values from visualization

Last tested: Sep 21, 2020 Certain visualizations, i.e. line, scatterplot, area, have the "Plot Null Values" option in the visualization section. We can leverage this along with table calculations to exclude certain values from a visualization.We can do this by creating a table calculation that uses...

Article Can I group or bucket by table calculations?

Last tested: March 2021 No. Table calculations are computed after SQL grouping, so it's not possible to group by them.Only dimensions can be grouped on. Consider using a custom dimension for quick grouping! https://docs.looker.com/exploring-data/adding-fields/custom-measure#creating_a_custom_dimensi...

Article How to join the same table twice (self-join)

Last Tested: March 22, 2021In a given explore, each join name must be unique. To self-join the same table multiple times you can use the from parameter, as mentioned in the docs, to change the "join" name of the table.In this example, we join in person to order twice, with different names and differ...

Article Show or hide value labels on a specific series

Last tested: Mar 31, 2021 There isn’t a native option in the visualization edit panel to toggle value labels on/off for individual series, but please leave feedback for the Looker product team! After authenticating into the feedback portal, you can click here for the open request!Two other options y...

Article List of workarounds for sorting pivots by measure / sorting by column totals / dynamic top n ranking

Last tested: Jul 13, 2018 The problemSay you want to see some metrics for your top 10 customers by number of users, where the customer dimension is pivoted. Currently there is no easy way from an explore to sort a pivoted dimension based on measure values—you can only sort the pivoted dimension alph...

Article How can I split a string at a certain character with a Table Calculation or Custom Field? (split part a field by delimiter)

Last tested: Jun 1, 2020 You can split a value by a delimiter in Table Calculations and Custom Fields* by using the substring and position functions.In this example:We get the first position of the character b in the name string:position(${name},"b") Then we get everything before that position:subst...

Article Can I change font size in visualizations?

Last Tested: Jul 11, 2019 It is currently not possible in all visualization styles. But this time we have font control over values in the following visualizations - Bar, Column, Scatterplot, Line, Area.We can also create a “single value visualization" out of a scatterplot which allows us to edit the...

Article How can I recover a deleted Look or Dashboard if the trash is emptied?

Last tested: March 2021 As of 4.8+, all deleted content goes to the Trash Folder. It stays there indefinitely until deleted by an admin. Any content can be restored from the Trash Folder by an admin.This card talks about how to find and restore a deleted Look or dashboard with i__looker, in the cas...

1
2
3
4
...
67

Page 1 / 67

Powered by inSided

Sign up

Already have an account? Login

Social Login

or

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

*

Password *

I accept the terms & conditions

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

or

Username or Email

Password

Remember me

Forgot password?

Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.

Username or e-mail

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK

© 2021 Looker Data Sciences, Inc.
community@looker.com
Privacy | Terms | Cookies | Community Guidelines