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

Eric_Lyons
Looker Staff
Eric_LyonsLooker Staff
published in Technical Tips & Tricks

Does Refreshing the Page Stop/Kill LookML Validation aka Linting?Knowledge Drop

Last tested: Jun 16, 2020 Answer: No To double check, open the network panel, click validate and refresh the page. The /lint internal api call should still return a 200. This content is subject to limited support.                  

150
Eric_Lyons
Looker Staff
1 year ago
Dean_Hicks
Looker Staff
Dean_HicksLooker Staff
published in Technical Tips & Tricks

Error: cannot extends [lookml_parameter] due to mis-matched property valuesKnowledge Drop

Last tested: Apr 1, 2020 There are several variations to this error, but one common one is when a user extends viewA in viewB, then extends both viewA and viewB in viewC. In this case, the extends logic seems to conflict. They shouldn't need to extend viewA in viewC in this case because they are already extending viewB (which extends viewA) there. This content is subject to limited support.                  

150
Dean_Hicks
Looker Staff
1 year ago
V
Looker Staff
vishal.dharmadhikariLooker Staff
asked in Technical Tips & Tricks

What does the graph_derived_tables_for_model endpoint do?

You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the PDTs in a specific model in the DOT language. The output can then be rendered into an image by passing the output into a graphviz tool. The rendered image will look something like:  This content is subject to limited support.                

0
V
Looker Staff
1 year ago
Peggy_Beard
Peggy_BeardMember
published in Technical Tips & Tricks

What happens if the master git branch is protected on the git side with 'require pull requests'?Knowledge Drop

Last tested: Dec 11, 2020If the 'include administrators' box is not also checked, then Looker developers are still allowed to deploy changes to production as usual.If the 'include administrators' box is also checked, then an error will occur if developers try to deploy changes to productionThe recommendation is to enable pull requests on the Looker side. This content is subject to limited support.                  

150
Peggy_Beard
1 year ago
Kento_Tomine
Community Admin
Kento_TomineCommunity Admin
published in Technical Tips & Tricks

Can we disable curated search by default?Knowledge Drop

Last tested: Feb 11, 2021 Yes! You can disable it from Admin > General > disable curated searchhttps://docs.looker.com/admin-options/settings/general#curated_search This content is subject to limited support.                  

150
Kento_Tomine
Community Admin
1 year ago
molly.lippsett
Looker Staff
molly.lippsettLooker Staff
published in Technical Tips & Tricks

Does deleting a user affect that user's alerts?Knowledge Drop

Last tested: Apr 28, 2020 Unlike scheduled plans, alerts do not get deleted when a user does.The alert ends up remaining on the /admin/alerts panel with no owner set, and the 'reassign' button works to assign a new owner for that alert. This content is subject to limited support.                  

150
molly.lippsett
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

Why do I see a ridiculously high count of login events while looking at the System Activity event explore?Knowledge Drop

Last tested: Aug 23, 2018When a user logs in using OpenID auth (i.e. Okta, OneLogin, etc.), Looker will authenticate said user once a minute to keep that user logged in. Each authentication event will counted as a login in system activity, which is why a given user might appear to have logged in hundreds of times on a single day. This content is subject to limited support.                  

140
Department of Customer Love
Looker Staff
1 year ago
romain.ducarrouge
Looker Staff
romain.ducarrougeLooker Staff
published in Technical Tips & Tricks

What is the minimum interval (maximum frequency) to rebuild PDTs?Knowledge Drop

Last tested: Sep 6, 2019 5 min is the minimum interval or the maximum frequency, as per our docs, and is also the default frequencyThis interval is set on the database connection panel in the text box labelled PDT and Datagroup Maintenance Schedule as a cron expression  This content is subject to limited support.                  

140
romain.ducarrouge
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

Can I use the mobile app while allowlisting IPs in Looker?Knowledge Drop

Last tested: May 7, 2021 Not natively. If you allowlist specific IPs in Looker, then the IPs of mobile phones won't be able to reach Looker. Mobile IPs are temporary (change every few days) so allowlisting the phone IPs isn't a sustainable workaround.Workaround: Use a VPN on their phone to connect to a static IP that can be allowlisted.Feature Request to comment on: https://portal.feedback.us.pendo.io/app/#/case/60895 This content is subject to limited support.                   

140
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 aren't my logs showing up in the admin/logs window?Knowledge Drop

Last tested: Jan 21, 2019 What to do when admin/logs is showing a blank screen instead of the usual code feed?The first thing to check is whether the logs are being written to the looker/log directory. To check this:cd into the looker/log directory run tail -f looker.logIf logs aren't printed, they are possibly not being written or being redirected to another location. Looker needs the logs to be in the looker/log directory to make the admin/logs window work, so they will need to be both written and stored in that directory. This content is subject to limited support.                  

140
Department of Customer Love
Looker Staff
1 year ago
chris.seymour
Looker Staff
chris.seymourLooker Staff
published in Technical Tips & Tricks

Does the "Send Test" button listen to "Send if there are results"?Knowledge Drop

Last tested: Aug 22, 2018 No. The "Send Test" button will always send the look, whether or not you have "Send if there are results" or "and results have changed since last run" selected.If you want to test whether these options are working as expected, you should save a schedule that runs in the next five minutes. This content is subject to limited support.                  

140
chris.seymour
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

What determines the content in the Popular and Recently Viewed under Browser Menu tab?Knowledge Drop

Last Tested: Jul 3, 2018Both of these pages are populated by thecontent_view table in the internal database, which stores metadata about Looks and Dashboards like last viewed at date and total view count.  This content is subject to limited support.                 

140
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

PDT Logs: Consecutive Trigger ChecksKnowledge Drop

Last tested: Nov 2, 2020 If you happen to come across consecutive trigger datagroup check's equal to true for a given table in the pdt event logs and you have confirmed that the cron job shouldn't be causing this, this is likely because we fire off multiple trigger checks before the regenerator builds a PDT.The first trigger check is sent when the regenerator starts its run, the second when it gets around to actually building the table. Note that there will always be a trigger check of true before the regenerator begins building a pdt and as such the last true trigger check should indicate/match up with the time in which the create begin event is logged for the given PDT. This content is subject to limited support.                  

140
Department of Customer Love
Looker Staff
1 year ago
Vincent
Looker Staff
VincentLooker Staff
published in Technical Tips & Tricks

Can I change the default location of the looker log?Knowledge Drop

Last tested: Sep 6, 2019 The only option is to symlink the log directory somewhere else.By default, Looker will save the logs to looker/log . The docs show this in the directory structure, and there's a feature request for allowing logs to be stored in BigQuery/Stackdriver. This content is subject to limited support.                  

140
Vincent
Looker Staff
1 year ago
Vincent
Looker Staff
VincentLooker Staff
published in Technical Tips & Tricks

How many threads does the regenerator process have by default? Rather how many PDTs can it build at one time?Knowledge Drop

Last tested: Apr 23, 2021 This is controlled by the Max PDT Builder Connections setting in your database connection.Docs This content is subject to limited support.                   

140
Vincent
Looker Staff
1 year ago
quinn.morrison
Looker Staff
quinn.morrisonLooker Staff
published in Technical Tips & Tricks

Do SSO embed PDF/PNG requests count towards the concurrent-render task limit?Knowledge Drop

Last tested: Jan 30, 2018 Yes, it is an instance wide flag, it doesn't care who the user is. This content is subject to limited support.                  

130
quinn.morrison
Looker Staff
1 year ago
mandy.chan
Looker Staff
mandy.chanLooker Staff
published in Technical Tips & Tricks

Why do I see `No Results` after installing a Marketplace block?Knowledge Drop

Last tested: Sep 1, 2020 After a user has added a marketplace block and try to run the query, they may see No Results when querying.One thing to check is to see if the schema name is correct. To find the schema name, you can look under the connection listed in the Update Configurations modal and search for the specific dataset. When you run Select 10 against the table, it should append the schema to the table name and you'll be able to compare schema names. This content is subject to limited support.                   

130
mandy.chan
Looker Staff
1 year ago
Department of Customer Love
Looker Staff
Department of Customer LoveLooker Staff
published in Technical Tips & Tricks

Does running a query from cache produce a new History ID?Knowledge Drop

Last tested: May 13, 2020 Yes.History view entries in system activity have a Result Source field that can either be "cache", "query", or null (for queries that don't return a result, in the case of errors for example).Each new entry has a unique ID, but indicates whether or not it was run from the cache or not. This content is subject to limited support.                  

130
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

Troubleshooting Enabling FoldersKnowledge Drop

Last tested: Nov 27, 2019 If you want to enable folders for your Projects and have a large number of varying lookml files, take the following precautions before you get started.Have all developers check in all changes before anyone enables folders. Identify any files that are using NDTs and flag them as files that need the include statement to be updated. Identify any model files that have include statements. These will need to be translate to the new include syntax post-migration. Check to make sure that connections that do not have PDTs enabled do not have include: /../*.view as this can cause lookml errors. After checking the enable folders box in your project, make sure that no one else is make commits/pushes anywhere else in the project until you have deployed the new folder structure changes. This can blocks commits that prevents you from resolving merge conflicts. If you encounter the issue from #4, revert all uncommitted changes, pull, and push immediately. Fix any issues afte

130
Department of Customer Love
Looker Staff
1 year ago
emma.wang
Looker Staff
emma.wangLooker Staff
published in Technical Tips & Tricks

Can I rename looker_tmp for MySQLKnowledge Drop

Last tested: May 15, 2019 No.looker_tmp is used for creating temp tables for System Activity, and it's hardcoded into the codebase and it can't actually be named differently.Relevant docs: https://docs.looker.com/setup-and-management/on-prem-mgmt/migrating-to-mysql#create_a_database_and_user This content is subject to limited support.                  

130
emma.wang
Looker Staff
1 year ago
A
Looker Staff
adina.katzLooker Staff
published in Technical Tips & Tricks

When "New Account Notifications" is on, will I get notified when new embed users are created?Knowledge Drop

Last tested: Apr 22, 2019Nope! New Account Notifications are only sent for non-embed accounts. This content is subject to limited support.                   

130
A
Looker Staff
1 year ago
W
Looker Staff
wonkyoung.park
published in Technical Tips & Tricks

JS Console: "dashboards cached_results miss for id your_dashboard_id"Knowledge Drop

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 used to accelerate the dashboard load and that endpoint is never used for embedded dashboards.  This content is subject to limited support.                  

130
W
Looker Staff
1 year ago
srinija.godavarthi
Looker Staff
srinija.godavarthiLooker Staff
published in Technical Tips & Tricks

Make Looker automatically restart when server goes downKnowledge Drop

Last tested: Aug 7, 2020 Use the looker_init script in our customer scripts repo https://github.com/looker/customer-scripts/tree/master/startup_scripts . This content is subject to limited support.                  

130
srinija.godavarthi
Looker Staff
1 year ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

Does order_by_field affect suggestions?Knowledge Drop

Last tested: May 2020 Yes! order_by_field works on both the result sets and on suggestions. This content is subject to limited support.                

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

Why aren't my new values for my embed parameters taking effect?Knowledge Drop

Last tested: May 28, 2020 If you’ve changed one of the embed parameters values in your script, in order for these new values to take effect, you would have to start a new embed session. If the user already has an active session it will just use that session instead of re-authenticating as the embed user with the new parameters. Creating a new session can be done by setting the "force_logout_login" parameter to be "true". This content is subject to limited support.                   

120
Department of Customer Love
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