User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started61 News & announcements103 Who's hiring377 Release notes (archive)63 Lesson Comments10 Challenge8
Looker developmentLookML1309 SQL253
Exploring & curating dataExplores421 Dashboards & looks1142
Application developmentEmbedding Looker / Powered by Looker99 Open source projects44 Looker API281
AdministrationUser access & management19 General Looker administration373
Data science & analyticsGot a question?59 Share your best practices11
コミュニティフォーラム (Japanese)ニュースと告知34 ヘルプとサポート10 コラム54
The Kitchen TableTechnical Tips & Tricks1647 Common Account Questions14 DCL Mic Drops5

Ask question / Create topic
Login

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

1,647 Topics
46 Replies

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

1647 Topics

Recently active

Most replies Most views Newest first

Article Selected articles about Looker API & SDK use cases

We have gathered a list of community and help center articles covering some major API & SDK use cases. We hope this makes it easier for you to browse and navigate. The code examples are for demo purposes only. For any further questions on those use cases please post a comment under those article...

Article Selected articles about LookML

Selected articles about LookML We have gathered some selected community and help center articles and organised them in different topics. Hope this makes it easier for you to search and navigate. General Why do we recommend many_to_one joins over one_to_many joins?How to add a new row of data with Lo...

Article Selected articles about SQL use cases in Looker

Selected articles about SQL use cases in Looker We have gathered a list of community and help center articles organised in different topics. Hope this makes it easier for you to search and navigate. Calendar tableHow to combine a retail calendar with retail sales dataGenerate Date Series/ Create a c...

Article Breaking News: Knowledge Drops are LIVE!

Democratizing information has always been a core tenet of Looker’s values. It’s how we all become better thinkers and better doers. This ethos isn’t just a philosophy or a catchy marketing phrase; it’s a practice - and it’s one we’ve always taken to heart. So in true Looker-fashion, we’re excited to...

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

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

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

Can you add, edit, or update table calculations in Looks via the API?

Yes, you can update the query object associated with a Look. There's a property called dynamic_fields which you can use to add, update, or remove table calculations.To get the logic for the table calcs, you can build a query with table calcs, open up Dev Tools, look at how Looker constructs the quer...

What does the graph_derived_tables_for_model endpoint do?

You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the PDTs in a specific model in the DOT language. The output can then be rendered into an image by passing the output into a graphviz tool. The rendered image will look something like: This cont...

Render job error: `query failed: Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.`

This error message is being returned from the database and is a standard MS SQL error. One of the most common causes for this deadlock error is when a large table scan conflicts with an update.For more information on this error, check out this helpful Stack Overflow post. This content is subject to ...

Article Detailed Steps to "More Powerful Data Drilling" & how to get vis configs for custom drilling

Last tested: Dec 15, 2019Enable the “visual drilling” labs feature. In the `drill_fields` parameter within the definition of a measure we’d like to drill into, we select only the fields we want to see in the drill modal. Go to the explore and drill into the measure. We should be seeing some default...

Article Get changes back after revert to production

Last tested; Jul 7, 2020 Say you accidentally push some changes to production - your coworker reverts those changes, so production is all set, but you wanted some of those changes to continue working on. How can you get them back?In History, from either the git menu in Looker or in the remote provid...

Article 400 Bad Request when downloading dashboard zip csv

Last tested: Mar 31, 2020 Pre 7.2: if a query fails to run for any reason (a DB error, a problem with table calc syntax, etc.), the cache will not be set but the invalid cache entry will still be retrieved, throwing an Error streaming dashboard-my_dashboard/my_tile.csv to out error. Version 7.2+: Th...

Article Should I hide or delete unnecessary LookML fields?

Last tested: Aug 6, 2020 The ProblemI have some LookML fields that I'm not using. They are currently hidden with `hidden: yes`. I'm concerned that it may be a performance cost to keep them. Should I delete them to save database strain?An AnswerWriting a field in LookML does not immediately query the...

Article How to apply access_filters to views

Last tested: May 6, 2020 The ProblemI have an access_filter for one of my explores. But I'd like to use it for a view instead so that it will automatically come through for all explores which use this view.A WorkaroundWe can replicate the functionality of access filters in views by referencing the u...

Article Access to font at ' S3 bucket' from origin 'https://ait.dev.att.com' has been blocked by the CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource

Last tested: May 20, 2020 If you are seeing this error on your JS console for your embed contentThe solution is to set on the S3 bucket settings: https://docs.aws.amazon.com/AmazonS3/latest/dev/cors.html the configurations to accept it.We've had users that confirmed it worked after enabling the Acce...

Article Is model localization also applied to UDD?

Last tested: Feb 12, 2021 When we apply localization on the model level, some elements would be localized on explores, looks and user defined dashboards, as for example labels, group labels and descriptions and even data values. Take a look on the docs for more elements that can be localized on the...

Article Why are my email fields grey?

Last tested: May 10, 2018 There are two different interpretations of this question, with two different answers.1. On the Admin > User page, before editing a user. If an email is grey here, it means the user can't log in with these credentials. In this example, SAML is enabled for the instance. Us...

Article Why isn't my liquid variable passing values into my URL filter correctly?

Last Tested: Jan 29, 2020 There are two main reasons that this happens:The values are not url-encoded (can be solved by using {{value | url_encode}} ) The values have special matches (advanced) filter expression characters in them. In some cases this can be fixed by using filterable_value instead of...

Article How does one resolve an issue with setting up the shared filesystem where the uid and gid are different on the share than they are on the looker server?

Last tested: Aug 21, 2020 The UID and GUID need to match.As root, you can edit /etc/passwd and /etc/group on one host to make it match the other, then do a chown -R looker:looker /path/to/shared/whatever This content is subject to limited support.

Article month_x timeframe

Last tested: Feb 3, 2019 This came from a custom month_18 (group by every 1.5 years) timeframe in redshift. Here is a generalized version for month_x where you can shift the start month by adjusting y: dimension: month_x { type: string sql: TO_CHAR(DATE_TRUNC('month', #Convert...

Article What is LEXP?

Last tested; Jun 4, 2021 LEXP stands for Looker Expressions. It is a special syntax created by Looker that is used for Table Calculations, Custom Fields, and Custom Filters. We have a doc that outlines the general usage of expressions, and another doc that has a list of all functions that it current...

Article Why am I getting `Uh Oh. GATEWAY_TIMEOUT` when downloading a dashboard PDF?

Last tested: Jul 4, 2018 This error implies a network timeout. Check for a load balancer on your end. On Looker nginx servers sample we use a timeout of 3600 seconds, which can be customisable to your environment. This content is subject to limited support.

Article How do we fix a blank timezone in Looker-generated SQL?

Last tested: May 11, 2020 There is a known issue where disabling user-specific timezones can cause this to a Look that was created when user-specific timezones were enabled.Either enabling user specific timezones or creating the look from scratch with user-specific timezones off should solve the pro...

Article Is there a Liquid parameter for the current Looker instance hostname URL?

Last tested: Jan 29, 2020 There is not. This is a feature request: Grab current page URL with liquid.WorkaroundIf you have several different instances but just wants to use a single liquid variable, then you can achieve this with a clever application of User Attributes.On each instance, create a Use...

1
2
3
4
...
66

Page 1 / 66

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

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