User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started77 News & announcements105 Who's hiring390 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1386 SQL260
Exploring & curating dataExplores443 Dashboards & looks1210
Application developmentEmbedding Looker / Powered by Looker112 Open source projects46 Looker API299
AdministrationUser access & management24 General Looker administration380
Data science & analyticsGot a question?62 Share your best practices13
コミュニティフォーラム (Japanese)ニュースと告知35 ヘルプとサポート11 コラム54
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

Newest first

Recently active Most replies Most views

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

Technical Tips & Tricks

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.

Technical Tips & Tricks

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

Technical Tips & Tricks

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

Technical Tips & Tricks

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.

Technical Tips & Tricks

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

Technical Tips & Tricks

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

Technical Tips & Tricks

Article Why aren't logs being written?

Last tested: Jul 23, 2018 When Looker is no longer writing logs, a restart will get the process going again.This can happen if you do anything to the looker.log file, such as:edit looker.log from vi or another text editor delete looker.log move or rename looker.log ziplooker.logTDLR: Always make a c...

Technical Tips & Tricks

Article Can I use a user ID other than email for logging in to Looker?

Last tested: Oct 1, 2019 No, the only user ID you can use in Looker is an email. Logging in will always require an email/password combo.If you want to customize your login experience, consider integrating with LDAP or SAML. This content is subject to limited support.

Technical Tips & Tricks

Article Does Looker use tokens for SAML?

Last tested: Sep 18, 2019 Looker doesn't use tokens at all when authenticating with SAML.In fact, we are 100% decoupled from Okta’s notion of sessions and how they keep users logged in or not.When a user hits the ‘Authenticate’ button, we redirect the user’s browser to the SAML IdP and (implicitly)...

Technical Tips & Tricks

Article Can I log in to Looker with two separate email addresses but keep the same user?

Last tested: Jan 31, 2018 Generally speaking, no. Each Looker user is only allowed one set of credentials for each type. So, you can't connect two email/password combos (or two LDAP logins, SAML logins, etc) to one Looker user.There is a workaround of sorts that takes advantage of Looker's Alternate...

Technical Tips & Tricks

Article My LookML files are disappearing and reappearing in Production mode!

Last tested: Oct 27, 2020 If files are disappearing and reappearing, make sure that nobody's pushing changes from dev mode.This is not something Looker does- if you're hosting your own instance, check to see if there is some process which is messing with the file system running in your environment. ...

Technical Tips & Tricks

Article CSV to SQL Tool

Last tested: Jun 13, 2020 The ProblemYou have a CSV and you want to explore it in Looker. You know you're supposed to use a database, but it's just this one CSV...WorkaroundThis web based tool quickly generates a SQL UNION (ALL) query & LookML from a raw csv snippet.This tool is not supported by...

Technical Tips & Tricks

Article My custom TopoJSON is freezing my browser! What do I do?

Last tested: May 13, 2020Check the filesize of the TopoJSON. We recommend a 2MB or less file. Sites like mapshaper.org can help with cutting filesize, by reducing the number of shapes. This content is subject to limited support.

Technical Tips & Tricks

Article Where do I get LOOKER_WEBHOOK_TOKEN for lookerbot?

Last tested: Jan 21, 2019 The lookerbot setup instructions mentions a webhook token. You can find this at the bottom of the admin panel in your Looker instance. This content is subject to limited support.

Technical Tips & Tricks

Article Can I parameterize the scheduled email subject line?

Last tested: Jan 21, 2019 No, at this time you can only write a static string as the email subject. There is no way to have a dynamic field like a date in there.However, there is a feature request. This content is subject to limited support.

Technical Tips & Tricks

Article Will a user in multiple [SAML/LDAP] Groups Get Associated to Multiple Looker Roles?

Last tested: Sep 18, 2019 They definitely should. If it's not coming through, check the tests in the setup page.This can occur due to a messed up base_dn. This content is subject to limited support.

Technical Tips & Tricks

Article Which table does cached results get stored in the internal database?

Last tested: May 14, 2020 Where can I find my cached results?Within every Looker directory there's a /looker/.cache directory which is where cached objects is actually stored (query results, internal objects, etc.) Check out this post to read more about this.The internal database will have a cache_...

Technical Tips & Tricks

Article Can LDAP allow users to login automatically, without entering username or password?

Last tested: Jun 26, 2021 No, only SAML or Oauth would do that.This has nothing to do with Looker and everything to do with the capabilities of those individual systems. This content is subject to limited support.

Technical Tips & Tricks

Article Does calling ${sql_table_name} in SQL Runner use Dev mode PDTs?

Last tested: Jan 17, 2019 When you call ${sql_table_name} in SQL Runner, if you're in dev mode, this will query your dev version of the PDT.Note that this could be the same as the production version of the PDT. This content is subject to limited support.

Technical Tips & Tricks

Article How do I format a date so that it respects timezones AND can be downloaded as a CSV?

Last tested: Jan 21, 2019 It's convenient to format a date with liquid, but HTML formatting is not respected in CSV downloads.So you might use SQL's to_char on a timestamp, but then your string dimension will not listen to user-specific timezones.To get the best of both worlds, you need to reference...

Technical Tips & Tricks

Article How do I make a primary key for my dimension group (timestamp, date)?

Last tested: May 11, 2020 Since a dimension group is a collection of dimensions, you can't make it a primary key. Instead, make a single dimension with one timeframe, and let that be your primary key.So if you have:dimension_group: created {type: timetimeframes: sql: ${TABLE}.created_at ;;} Then you...

Technical Tips & Tricks

Article Is there any size or character limit on the JSON body for api calls?

Last tested: Oct 1, 2019 Not that we are aware of.The input boxes on the API Docs might have a limit, and run_url_encoded_query could be a problem because URL size is limited. This content is subject to limited support.

Technical Tips & Tricks

Article How do I get looker.pem and looker.key?

Last tested: Jul 4, 2018 You must obtain your own SSL Certificate and name the files looker.pem and looker.key.For production environments, we recommend installing an SSL certificate from a certificate authority such as Verisign (Symantec), GoDaddy, or Thawte.Once you have that, you can proceed with...

Technical Tips & Tricks

Article To use default SMTP, do I need to set up a DKIM and an SPF record?

Last tested: Jun 14, 2017 Nope, just allow traffic to smtp.sendgrid.net on port 587 and allowlist noreply@lookermail.com.cite outbound ports (doc) This content is subject to limited support.

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