User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started79 News & announcements106 Who's hiring395 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1439 SQL265
Exploring & curating dataExplores447 Dashboards & looks1235
Application developmentEmbedding Looker / Powered by Looker118 Open source projects46 Looker API303
AdministrationUser access & management27 General Looker administration386
Data science & analyticsGot a question?62 Share your best practices13
コミュニティフォーラム (Japanese)ニュースと告知35 ヘルプとサポート11 コラム55
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 DCL Mic Drops5

Ask question / Create topic
Login

The Kitchen Table

Explore the product knowledge we've built up together

1678 Topics

Recently active

Most replies Most views Newest first

Article Does Looker support IAM Roles based authentication for Athena in Looker?

Last tested: Nov 14, 2017 This isn't possible at the moment. User will need to enter the ID and secret for the role in the connection instead. This content is subject to limited support.

Technical Tips & Tricks

Article Query task [hash] results not found in cache

Last tested: Aug 19, 2021 This error will happen on some merged result query runs, usually as a result of the cache being busted for one of the source queries.Merged queries essentially work by running all source queries asynchronously, and then once all queries are marked as complete, the results o...

Technical Tips & Tricks

Article The PDT Regenerator Process

Last Tested: Nov 4, 2020 Purpose:The regenerator's purpose is to manage the building of PDTs on the scratch schema. Its major tasks are to check datagroup triggers, build new PDTs that have been pushed to production and rebuild existing production PDTs whose trigger values have changed.Number of Reg...

Technical Tips & Tricks

How do I get a list of recently viewed dashboards by a user through the Looker API?

1 ) Hit login_user to login as the user (https://docs.looker.com/reference/api-and-integration/api-reference/v3.1/api-auth#login_user)2) Use all_dashboards endpoint to get all the dashboards the user has access to and sort it on the last_viewed_at param

Technical Tips & Tricks

how to return first row of data

The problemLet's say you have a table like so:And you want to return only the first row of data in a single column. The solutionWe can accomplish this by using this function here:pivot_index(index(${number_of_sign_ups.count}, 1), row()) The explanationIndex(orders.count, 1) is specifying to return v...

Technical Tips & Tricks

how to check if every unique value of sql_distinct_key has one corresponding value in sql

The problemIf you are getting Non-Unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum error and you've checked that you have a primary key and are also using a sum_distinct with sql_distinct_key, you should check to make sure your sql_distinct_key only has...

Technical Tips & Tricks

Can we have the same external_user_id for all users logging into embedded content?

Technically, the answer is yes. However, there are potential issues to consider:As noted in docs, this value must be unique for a given set of permissions, user attributes, and models. So, for example, if the different users will have different permissions, they’ll need two different external user I...

Technical Tips & Tricks

Why is it necessary to domain whitelist when user attributes values are set to hidden?

Hidden user attributes tend to be passwords or tokens so allowlisting URLs restricts where those passwords or tokens can be sent. You wouldn't want someone doing something like, I'm going to use this user attribute on a schedule to a random place so that I can see the value of it.

Technical Tips & Tricks

Why does it show the faceted filter icon even though there aren't any faceted filters enabled?

The problem:Sometimes, you can encounter a situation where you see the faceted filters icon even though there aren't any faceted filters enabled on the dashboard and then when you hover over the faceted filter icon, you see this... The explanation:Some ways this can happen is if the you created a Lo...

Technical Tips & Tricks

Why Doesn't My Table Calculation Work in My Visualization?

The ProblemThe data is set up how you would like, but when you select the visualization type, Looker says that the visualization is incompatible with your data (e.g. it requires one dimension and one measure). The ExplanationEven though the “Percent Profit” table calculation is performing a mathema...

Technical Tips & Tricks

How to hide the field label on a pie chart or customize the measure label.

Hi all, A few customers have used the pie chart visualization and wanted to remove the measure label from the Tool Tip or hover state. There is no direct way to do this right now, but we can use a table calculation and a blank space character to hide the label from the visualization. In our example...

Technical Tips & Tricks

Article How do I hide one of my pivot columns?

Last tested: Mar 16, 2020 If you find yourself here, +1 this feature request: https://feedback.us.pendo.io/app/#/case/17612We're here, and we want to hide the "other" column:We can accomplish this with pivot_index or pivot_where.You'll need to create a table calculation for each column you want to s...

Technical Tips & Tricks

Common Questions About GitHub Authentication Changes Made on August 13th

What change was made?GitHub recently announced they will be requiring the use of token-based authentication. You can read more about this change here. Within Looker you’ll need to make sure that you have configured your git connections to use tokens instead of user name and password.How does this af...

Technical Tips & Tricks

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...

Technical Tips & Tricks

Article PDT Naming Convention

Last Tested: Jun 25, 2021 PDT name structure:LR$[connection_key][hash]_[view_name]All PDT names begin with LR, short for Looker Read. The connection_key is a two letter string that is unique for the connection. The PDT hash is an encoding slug that follows the connection_key and precedes view_name i...

Technical Tips & Tricks

3 Methods of Embedding Looker Content

You want to embed your Looker content into another website. How should you do it? There are 3 main methods of Looker embedding. Choose the one that best fits your use case.The easiest type of embedding to set up is Private Embed. The only setup is to insert the URL to your Look or dashboard inside a...

Technical Tips & Tricks

How do I filter results in my visualization, without filtering out rows in the data tab?

The Problem:I have a use case where I need to filter out rows in my visualization, but need all the rows to remain in the data tab. For example, I have a calculation/aggregation that relies on all the rows being in the results, and when I use a regular filter, the results of the calculation/aggregat...

Technical Tips & Tricks

Article What Looker version am I running?

Last Tested: Jun 14, 2019 Here are two different options:Click on the question mark icon in upper-right section of your Looker instance. Your version number will be shown to the right of the Release Notes section. Right click on the Looker login page in chrome and click "View Page Source". You can s...

Technical Tips & Tricks

Article Week-related table calculation functions

Last tested: Dec 2, 2019 Currently, there are no week-related table calculation functions available. Below are feature requests and workarounds for various week-related functions.extract_day_of_week / extract_day_of_week_indexA function to extract the day of the week or day of week index from a date...

Technical Tips & Tricks

Article Dev Mode PDTs

Last tested: Sep 9, 2019 A PDT that has been created/modified in a user's dev mode has the following properties:It behaves as if it has persist_for: 24 hours regardless of what persistence is set. Each one will be its own table in the scratch schema (see "Why are there multiple copies of the same PD...

Technical Tips & Tricks

Article How to sort by rolling month

Last tested: Oct 4, 2019 To sort their data by current month for ex: October 2019 thru November 2018, you can throw this in the lookml (dialect specific may be required): dimension: this_month_num { hidden: yes sql: MONTH(CURDATE());; } dimension: sort_relative_month { type: number sql: C...

Technical Tips & Tricks

Article How to log embed users out of Looker when they log out of the application?

Last tested: May 7, 2020 The ProblemAn application will log embed users into Looker, but when they log out of the application, they will not be logged out of Looker.A SolutionLooker does not use a /logout endpoint for web sessions. Instead, you will need to make calls to Looker's user_sessions endpo...

Technical Tips & Tricks

Article Common SQL error troubleshooting tips in Looker

Overarching themes/questions: Here is a list of common questions our users often need support with, along with troubleshooting steps to try out: 1. Why is my SQL query slow even when there are no queries queued on Looker? Run against database (or SQL Runner): check if that runs fast to see if it is...

Technical Tips & Tricks

Why am I not getting emails about changes to my Looker instance?

Not receiving important update emails about your Looker instance? You might not have designated a technical contact for your account, who is automatically signed up to receive important notifications such as security updates, major bug fixes, and new Looker releases. Designating this role for your a...

Common Account Questions

Article Error: Unknown view. View does not exist in model. Check for typos or missing include statements.

Last tested: March 2021ProblemYou receive a LookML error that complains about an unknown view. The error takes the form:Unknown view “my_view”. View “my_view” does not exist in model “my_model”. Check for typos or missing include statements in “my_model”.Solution 1The most simple reason for this err...

Technical Tips & Tricks

1
2
3
4
5
...
68

Page 2 / 68

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

© 2020 Looker Data Sciences, Inc.
Privacy | Terms | Cookies | Community Guidelines