Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

  • 1,744 Topics
  • 371 Replies

1744 Topics

sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

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

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.                  

40
sam
Looker Staff
1 year ago
Peggy_Beard
Peggy_BeardMember
published in Technical Tips & Tricks

What causes "The requested file failed to load" on a lookML file?Knowledge Drop

Last tested: Nov 1, 2018 One reason could be a non-utf8 character in the file. This would result in a log message similar toJSON::GeneratorError : source sequence is illegal/malformed utf-8 From the Linux command line, this command will show lines containing non-utf8 charactersgrep -axv '.*' file.txt where file.txt is replaced with myview.lkml , for example.Another possible reason you should keep in mind is browser extensions, especially Add blockers like ABP can prevent a file from being loaded. This usually happens if the file contains dimensions/measures related to advertisement or ads. This content is subject to limited support.                   

40
Peggy_Beard
1 year ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

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

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

40
sam
Looker Staff
1 year ago
ryland.wolff
Looker Staff
ryland.wolffLooker Staff
published in Technical Tips & Tricks

Why do I not need to click the Authenticate button after logging out?Knowledge Drop

Last tested: Aug 31, 2020Some SSO providers have settings that do not require a user to click the Authenticate button when logging back into an application. This can create some significant confusion and appear as a security issue, but is most likely caused by an IdP setting. For example, when using OIDC with AuthO there is a setting enabled by default called Enable Seamless SSO that will cause this. This content is subject to limited support.                  

40
ryland.wolff
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

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

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

40
Department of Customer Love
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

Why are my API-accessed JSON objects returning numbers instead of strings?Knowledge Drop

Last tested: Oct 7, 2019There was a legacy feature that allowed JSON numbers to return as strings that was completely removed in 5.4. You can find information about how to solve this problem here: Deprecation Notice: JSON Numbers Can be Returned as Numbers Instead of Strings in API (3.52+). This content is subject to limited support.                  

40
Department of Customer Love
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

Can you use 2FA with OauthKnowledge Drop

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.                  

40
Department of Customer Love
Looker Staff
1 year ago
V
Looker Staff
vitor.leepkalnLooker Staff
published in Technical Tips & Tricks

What file do Developers see first when they access the IDE?Knowledge Drop

Last tested: Aug 12, 2020 The ProblemAn admin would like to select which file their developers see first when they open the project from the Develop tab. Maybe it's a welcome file, or one with instructions. There isn't an option to select this, so how can they do this in practice?A SolutionLooker follows a simple hierarchy when selecting the files to display: A README document file Any other document file Model file Any other fileThe solution for this problem is for them to rename the file they wish to display first as a README.md file, as that will be displayed first, before any other file type. This content is subject to limited support.                  

40
V
Looker Staff
1 year ago
S
Looker Staff
swhiteLooker Staff
published in Technical Tips & Tricks

INFOBRIGHT: Derived Tables in InfobrightKnowledge Drop

Last tested: Dec 5, 2019 Looker doesn't support PDTs in Infobright.If you want to have DTs (ephemeral, not persistent), you will need to use a workaround where the SQL query is written in the sql_table_name parameter:view: derived_table {sql_table_name: ( SELECT * FROM table ) ;;dimension: id {...}...}  This content is subject to limited support.                   

30
S
Looker Staff
1 year ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

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

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.                  

30
sam
Looker Staff
1 year ago
ruth.mcelroy
Looker Staff
ruth.mcelroyLooker Staff
published in Technical Tips & Tricks

Does resetting my git connection cause PDTs to rebuild?Knowledge Drop

Last tested: Sep 20, 2019 No, this doesn't cause PDTs to rebuild. :thumbsup: This content is subject to limited support.                  

30
ruth.mcelroy
Looker Staff
1 year ago
chris.seymour
Looker Staff
chris.seymourLooker Staff
published in Technical Tips & Tricks

What happens to my `models-user-X` directory when I switch branches?Knowledge Drop

Last tested: Aug 28, 2018The models-user-X directory does NOT act as a "pointer" to a permanent local copy of the shared branch's files. Instead, when you create a new shared branch in Looker, a branch on the remote repo is created; this branch contains all of the commit history for the branch. Then when each other user enters the shared branch in dev, they fetch from the one, central remote repo, creating file copies from that repo in theirmodels-user-X directory (and deleting the files for the branch they switched away from). This content is subject to limited support.                   

30
chris.seymour
Looker Staff
1 year ago
Kento_Tomine
Community Admin
Kento_TomineCommunity Admin
published in Technical Tips & Tricks

What is pdt_build_failure_cleanup ?Knowledge Drop

Last tested: Jan 20, 2021 When a build fails or is detected as being canceled, we drop the table that may have been partially created. We do this to make sure the name is available for a subsequent build attempt. This content is subject to limited support.                  

30
Kento_Tomine
Community Admin
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

When are local dev branch project files created?Knowledge Drop

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 generate files for all of the projects.This means that the initial mode-switching process could take quite a while if you've got a ton of LookML files on your instance, even if they're in multiple projects and you're not accessing a project (via the IDE). This content is subject to limited support.                  

30
Department of Customer Love
Looker Staff
1 year ago
srinija.godavarthi
Looker Staff
srinija.godavarthiLooker Staff
published in Technical Tips & Tricks

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

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

30
srinija.godavarthi
Looker Staff
1 year ago
ryan.dunlavy
Looker Staff
ryan.dunlavyLooker Staff
published in Technical Tips & Tricks

What does RendererNoCliprectFoundForElementError mean?Knowledge Drop

Last tested: Jun 24, 2019 The "nocliprect" error means that when Chromium polled the page for the size of the visualization element there was no visualization element present. Also worth pointing out that when we render individual dashboard tiles (AKA the Images of Visualizations option) that we convert each tile into it's own explore and capture the output from that. This error often comes up when there are no results in the rendered content.This error will appear as Uncaught (in promise) Error: Incompatible element passed to getClipRect in the logs. This content is subject to limited support.                   

20
ryan.dunlavy
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

How do you respecify `mount_nfs` options for a clustered instance?Knowledge Drop

Last tested: Jan 21, 2019 In general, these are the steps:stop looker umount <shared-storage-dir> mount_nfs -o vers=4 nolock <shared-storage-dir> start lookerYou should probably make the changes in /etc/fstab so they're permanent. Then, when you go to remount, you can just do mount /lookershare to pick up the changes. This content is subject to limited support.                   

20
Department of Customer Love
Looker Staff
1 year ago
ryan.dunlavy
Looker Staff
ryan.dunlavyLooker Staff
published in Technical Tips & Tricks

What is the custodian? (7.2+)Knowledge Drop

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 every 5 minutes on all nodes and does two things:First, it checks all schedules that are marked as currently executing or delivering in the backend database along with the threads they're marked as running on and checks those threads to make sure those threads current state indicates it's working on that job. Second, it will check for the most recent jobs that started executing over an hour ago, and look for any jobs still in the queue waiting to execute that should have started before that one. If there are ones that are stuck in the queue, it will finalize those with an error message. This content is subject to limited support.                  

20
ryan.dunlavy
Looker Staff
1 year ago
srinija.godavarthi
Looker Staff
srinija.godavarthiLooker Staff
published in Technical Tips & Tricks

Will migrating from legacy --> K8s rebuild PDTs?Knowledge Drop

Last tested: Mar 2, 2021 No, the PDTs shouldn't regenerate. The instance slug that determines the reg key is now persisted in the internal DB for hosted customers for this reason, so when the DB is copied over the slug will be copied over too and the instance will keep using the same reg key. This content is subject to limited support.                  

00
srinija.godavarthi
Looker Staff
1 year ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service