User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started61 News & announcements103 Who's hiring376 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 Questions15 DCL Mic Drops5

Ask question / Create topic
Login

The Kitchen Table

Explore the product knowledge we've built up together

1667 Topics

Recently active

Most replies Most views Newest first

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

Article What happens in Looker when you change a Git Repo name outside of Looker?

Last tested: Jul 5, 2017 If you change the name of your remote repository outside of Looker, Looker will still try to connect to the old repo name.The recommended practice is to reset your git connection to the new repo name.Some providers, like Github, claim that they will just point you to the new...

Technical Tips & Tricks

Article How do I leverage content validator when splitting one model into two?

Last tested: May 18, 2020 You can move the explore into the new model, and those looks will start erroring. Then you can change the model on those looks (since the explore will be erroring, but you can change something besides what is erroring).If a group of looks all have the same error, you can ch...

Technical Tips & Tricks

Article General Code & LookML Troubleshooting Steps

Last tested: Mar 29, 2019 ProblemMy code is throwing an error, and I don't know what part of the code is throwing the error! This can be:LookML An API script Complex Table Calculations Any code at all!Troubleshooting ApproachGenerally speaking, there are some steps you can take to troubleshoot code...

Technical Tips & Tricks

Article Can I schedule to Google Drive?

Last tested: Jul 10, 2017 Yes! We have a Looker Action for Google Drive you can enable on the admin/actions page. You will find more details on this article: Looker Actions – Google Drive. This content is subject to limited support.

Technical Tips & Tricks

Article Can I switch branches via the API?

Last tested: May 29, 2018 Yes, the all_git_branches, git_branch, create_git_branch, update_git_branch, find_git_branch, and delete_git_branch endpoints are available. Check out our API reference doc.You can use update_session to switch from prod to dev, then use update_git_branch to switch to the br...

Technical Tips & Tricks

Article Why does my tier have an "Undefined" tier?

Last tested:May 7, 2018 If the value is null if the style is set to integer but continuous values are used This content is subject to limited support.

Technical Tips & Tricks

1
2
3
4
5
...
67

Page 2 / 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

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