Can the PDT scratch schema exist in a different db host than the original tables used to create it?
Knowledge DropLast tested: April 2021No. Even PDT Override doesn't allow for this.The challenge here is that L...
Technical Tips & Tricks
Explore technical tips and tricks to help you get the most out of Looker.
Knowledge Base Articles
Do the LookML Validator or Content Validator time out?
Knowledge DropLast tested: May 2021No, they do not. They will go on forever.TroubleshootingThe only known way ...
refs/heads/branch REJECTED_OTHER_REASON: pre-receive hook declined
Knowledge DropLast tested: Apr 2, 2020 Some users enforce strict policies on their commits from their remote g...
How do I update LookML via the API?
Knowledge DropLast tested: June 2021This is currently not possible. The lookml-model endpoint does have "explo...
Why are my totals not showing up?
Knowledge DropLast tested: June 2020 Totals only apply to measures. They won't appear on dimensions, or on tab...
How can an admin see what permissions an embed user has?
Knowledge DropsLast tested: Dec 2020Click on the user in Admin > Users. Under “Roles” for that user, click the...
How to check if a Looker instance is up
Knowledge DropLast tested: June 2021If you host your own Looker instance, you may want a way to monitor instan...
Why can't I query my stable view name?
Knowledge DropLast tested: Mar 23, 2020 You will not be able to query the stable view name until the PDT rebui...
Can I use the mobile app while allowlisting IPs in Looker?
Knowledge DropLast tested: May 7, 2021 Not natively. If you allowlist specific IPs in Looker, then the IPs of ...
How do self-hosted users find looker logs?
Knowledge DropLast tested: Jul 11, 2017Step 1: Where to find logsThe standard subdirectories under the Looker ...
tmp directory getting too large
Knowledge DropLast tested: May 10, 2019If your instance is hosted by Looker, the .tmp directory is cleared on ...
Can I remove the from cache/ last run at time from the top of a dashboard?
Knowledge DropLast tested: Jun 25, 2019Nope. You can vote for this feature request here: Hide staleness time i...
extension: required and validation
Knowledge DropLast tested: Apr 30, 2019 The extension: required parameter flags an Explore as requiring extens...
Upload to SFTP host [host] failed due to error: NoMethodError. message: undefined method `write' for nil:NilClass
Knowledge DropLast tested: Oct 18, 2019The Problem:Error: Upload to SFTP host [host] failed due to error: NoMe...
Why don't I see the gear menu next to the Run button or the three dot menu at the top right corner of the tiles in an embed dashboard?
Knowledge DropLast tested: Apr 22, 2019When the embed user has no permissions for anything that would appear i...
error "orphaned job finalized by Scheduler::Custodian"
Knowledge DropLast tested: Mar 25, 2019 The custodian was removed in Looker v6.6, so only older versions of Lo...
Does a change to a parent PDT cause child PDTs to rebuild?
Knowledge DropLast tested: Sep 30, 2019 Yes. When there is a change to the parent PDT, the child PDTs hash cha...
Can I use a Look or Dashboard as my homepage?
Knowledge DropLast tested: Apr 11, 2019 You can use any Looker URL as a homepage. Check it out in docs: https:...
What does `--scheduler-query-timeout` flag control?
Knowledge DropLast tested: Oct 10, 2018 This is NOT a query timeout for when the query is actually executing.W...
How do I edit a dashboard's tiles via the API?
Knowledge DropLast tested: Oct 1, 2019In the update_dashboard call in the 3.0 API, dashboard_elements array is...
How to pull Look ID from Look download slug
Knowledge DropLast tested: Aug 22, 2018 You can find this in System Activity history explore. Assume you have ...
How to test if Fileshare (NFS/EFS/GFS) is correctly mounted and accessible from all nodes in the cluster
Knowledge DropLast tested: Apr 3, 2020 run ps -ef|grep java|grep looker from CL on each node. Verify that --sh...
Chromium rendering under the hood
Knowledge DropLast tested: Feb 13, 2019Run all queries for the dashboard and cache them Take the dash/look URL...
Error starting Looker: Java::JavaLang::ArrayIndexOutOfBoundsException
Knowledge DropLast tested: Mar 28, 2019 The ErrorWhen trying to start up a self-hosted Looker after an update,...
ERROR: SAML login failed
Knowledge DropLast tested: Feb 4, 2019 One of the reasons when users all of the sudden cannot login into Looke...
Can we turn off ERROR reporting mechanism that tries to send information to sentry?
Knowledge DropLast tested: Dec 24, 2018 Yes, if you host your own instance you can turn it off with the --no-r...
How can I set up monitoring of my Looker instance's health via the API?
Knowledge DropLast tested: Oct 5, 2018Looker responds to /alive with an http 200 status code if it is up. This...
Can I enable SSL for a connection to a MySQL internal DB?
Knowledge DropLast tested: Jan 18, 2019If you host your own instance, yes, you can. In the looker-db file that...
How do I calculate the number of digits in a value using table calcs?
Knowledge DropLast tested: May 18, 2020 We can do this using the power of logarithms! Looker's log() function ...
How do I reference SAML groups by their AccountName values when setting up SAML authentication using Azure Active Directory?
Knowledge DropLast tested: Sep 17, 2020 The ProblemBy default, when setting up SAML auth with Azure AD, the SA...
-
sam8Staff
-
Dr__StrangeloveStaff
-
corgi-lookerStaff
-
chrissieaStaff
-
LookerExpertsStaff
-
veronica_philliStaff
-
Erin_DocsStaff
-
Emma_DocsStaff
-
kendocsStaff
