Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started115 News & announcements114 Who's hiring415 Release notes (archive)63 Lesson Comments13 Challenge10
Looker developmentLookML1571 SQL286
Exploring & curating dataExplores495 Dashboards & looks1359
Application developmentEmbedding Looker / Powered by Looker133 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration415
Data science & analyticsGot a question?70 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

The Kitchen Table

Explore the product knowledge we've built up together

1681 Topics

Most views

Recently active Most replies Newest first

Article Does the `persist_for` clock start when the query begins running, or when it finishes?

Last tested: Sep 12, 2019 Finishes. It's like a time to live when inserting into the cache table. This content is subject to limited support.

Technical Tips & Tricks

Article How can I check to see who created API credentials on the instance?

Last tested: Aug 3, 2018 Creating new API keys on the instance will lead to line like this appearing in the log files, if you have access to see them:[INFO|05ad1|event:users] :: create_api3_credentials_for_user by user 104:, user_id='51' Note that in the example above, user ID 104 created API3 cred...

Technical Tips & Tricks

Article Who ran the lookML validator (logs)

Last tested: Oct 7, 2020 Get the project name Search for (replace MY_PROJECT_NAME with your project) GET /api/3.1/projects/MY_PROJECT_NAME/validate, {} Log lines after will show ID associated with userExample Log-lines: 2020-10-07 19:01:48.697 +0000 [INFO|99e1501dbf617994|http_core] :: Request from...

Technical Tips & Tricks

Article What is the chromium_pid_files directory, and why is it empty?

Last tested: Oct 4, 2019 The chromium_pid_files directory in the looker directory contains any process IDs for actively-running Chromium rendering processes. It is used to kill old processes that were running during a shutdown when Looker is started back up.It's totally fine if this directory is emp...

Technical Tips & Tricks

Article Identify all emails included on a given scheduled plan or job

Last tested: Sep 12, 2019 You can use: /explore/system__activity/scheduled_planScheduled Plan Destination Address field contains the emails. This content is subject to limited support.

Technical Tips & Tricks

Article Will an instance send out tons of schedules if it is started after being stopped for days?

Last tested: Jan 5, 2018 Looker will still only run 3 concurrent scheduled plans, but all schedules will run until they are done. This shouldn't be a problem. Schedules will not send several times if they have missed multiple iterations.This content is subject to limited support.

Technical Tips & Tricks

Article What happens when an actively logged-in user is disabled by a second user? Does the first user's session immediately end?

Last tested: Dec 3, 2020 Yes. They are immediately logged out and see the above screen. This content is subject to limited support.

Technical Tips & Tricks

Article Why is lookVR spinning when I choose a look?

Last tested: Mar 6, 2018 LookVR doesn’t show error messages well at the moment. Ensure the user you are using with LookVR has credentials to see the look you are trying to view in VR. You can test this by sudoing as the user in Looker and opening the look in the native Looker UI.It is also helpful t...

Technical Tips & Tricks

Article Can I set instance-level defaults for the schedule or default download options?

Last tested: Mar 16, 2018Right now, it is not possible to set instance-level defaults for schedule options. If you're interested in this, please share your use case with the product team via Pendo feedback! This content is subject to limited support.

Technical Tips & Tricks

Article Can we have more than one LDAP server hooked up to Looker?

Last tested: Sep 12, 2019 No; we only talk to one configured service endpoint. This content is subject to limited support.

Technical Tips & Tricks

Article How do I get raw/JSON responses from the Ruby SDK?

Last tested: Apr 18, 2018 You can tell the SDK client object to only return raw responses by setting the raw_responses attribute to true when you first set up authentication.This isn't always a good idea, but it can be useful when you don't need to utilize any of the features that come with Sawyer. ...

Technical Tips & Tricks

Article What is the custodian? (7.2+)

Last tested: Feb 4, 2020 The custodian in 7.2+ is meant to automatically find schedules that are stuck in a state that they cannot recover from and mark them as complete with an error message. It will not affect any schedules that are actually executing.The custodian runs as a background process eve...

Technical Tips & Tricks

Article Can you reference environmental variables in Looker DB credential files?

Last tested: Feb 9, 2018 When creating the DB credentials file for a MySQL backend, you cannot reference environmental variables to substitute for the actual credentials.You must type the credentials in the file as they are. This is because the file is not parsed by the shell, it is read directly by...

Technical Tips & Tricks

Article Does looker change the table(html) schedule format to an attachment if the table results are "too big"?

Last tested: Aug 9, 2017 Yes. This content is subject to limited support.

Technical Tips & Tricks

Article max allowed drift time between clusters

Last tested: Feb 28, 2018 Max allowed drift is 20 seconds! If it is more then that, you would need to update your NTP.Note that our install docs specifically state you need to use ntpd, chronyd or similar to keep their time in sync.https://docs.looker.com/setup-and-management/on-prem-install/install...

Technical Tips & Tricks

Article JS Console: "dashboards cached_results miss for id your_dashboard_id"

Last tested: Jul 20, 2020 Problem: You're seeing dashboards cached_results miss for id <your_dashboard_id> in the JS console on an embeeded dashboardExplanation: No need to be alarmed. This message is harmless. It's logged by the front-end code whenever the /cached_results endpoint was not use...

Technical Tips & Tricks

Article Naming Fields as Liquid Variables can give incorrect results when referenced.

Last tested: Jul 9, 2019 If you name a field with the same name as a liquid variable reference such as, dimension: value {} Then reference the liquid variable {{ value }} somewhere like the html parameter of another field, html: {% if value == "&#8377" %} ₹ {% else %} {{value}} {% endif %};; Liq...

Technical Tips & Tricks

Article When are local dev branch project files created?

Last tested: Sep 18, 2020 These are created the first time a user enters dev mode.IMPORTANT NOTE: Entering dev mode will create copies of all project files, regardless of what they're switching modes from. i.e. if you're switching to dev mode for the first time from the Browse page, you'll still gen...

Technical Tips & Tricks

Article Help! SAML overwrote my user names!

Last tested: Apr 30, 2020 This is expected - Looker rechecks the IdP every time a Looker user is authenticated and the first and last names would sync with SAML provider even if you changed them in Looker.Make sure, therefore, to have whatever names you want your users to have configured on the SAML...

Technical Tips & Tricks

Article Can I delete DCL'ers/support off my instance?

Last tested: May 12, 2020Yep! You can delete support users off your instance, we'll just get re-created once we sign into your instance again (with your permission). However, do not meddle with our permissions as that could prevent us from signing in in the future. This content is subject to limited...

Technical Tips & Tricks

Article Table calculation for time difference accounting for negatives

Last tested: June 15, 2020 The general logic here is, if the time diff is negative, then build own results using diff_minutes/diff_seconds, otherwise; do the calculation.if(${history.created_time}<${history.completed_time},concat("-",ceiling(diff_minutes(${history.created_time},${history.complete...

Technical Tips & Tricks

Article What happens if you delete the Looker jar, while it is running?

Last tested: Jun 26, 2020 If on Linux:In layman's terms, you're ok. In Linux, files aren't actually deleted if they're still in use. Keep a backup of the jar, just in case, but you should be fine.Per StackOverflow:a file isn't really deleted until all applications that have it opened close it. The f...

Technical Tips & Tricks

Article How are 2FA enabled/disable events tracked?

Last tested: Jul 13, 2019You can look forupdate_totp_config in the logs and in the System Activity events explore This content is subject to limited support.

Technical Tips & Tricks

Article Can you use 2FA with Oauth

Last tested: Dec 16, 2020 nopeyou can either have 2fa on top of email/pass or google oauth This content is subject to limited support.

Technical Tips & Tricks

Article Does deleting a user affects that users boards?

Last tested: Apr 28, 2020Nope! That board will just be left with no owner. This content is subject to limited support.

Technical Tips & Tricks

1
...
64
65
66
67
68

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

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