Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1562 SQL284
Exploring & curating dataExplores490 Dashboards & looks1355
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration414
Data science & analyticsGot a question?69 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 Why does my Percent of Total (percent_of_total) measure show up as null?

Last tested: Jul 11, 2019 ExplanationA percent_of_total measure is basically a table calculation, which means it's not run on the database. Therefore, if the row limit is hit, the total can't be properly calculated.SolutionIncrease the row limit to the max (5000).If you have more than 5000 rows, the...

Technical Tips & Tricks

Article Weekly Rollup Calculation

Last tested: Mar 17, 2020 Like many people out there, you like to automate processes and cringe at the idea that is "manual." Contrary to popular belief, also like many people out there you like to create weekly rollup ranges in you Explore. Well by golly do I have a solution for you.The Dirty:(${we...

Technical Tips & Tricks

Article How do I make a static PDT?

Last tested; Jul 6, 2017 This is not recommended - if you have static values, they should be a non-persisted derived table or written to your database.That said, you can use sql_trigger_value: SELECT 1 ;;. This value will never change so the PDT will never be rebuilt unless the SQL is changed or som...

Technical Tips & Tricks

Article Error: Misconfigured proxy in front of your Looker server

Last tested: Mar 7, 2018 ErrorThere appears to be a misconfigured proxy in front of your Looker server. HTTP DELETE to Looker are failing.HTTP PATCH to Looker are failing.HTTP PUT to Looker are failing.HTTP POST to Looker are failing. Possible SolutionCheck to see if you have the ublock origin brows...

Technical Tips & Tricks

Article Error Starting Looker

Last tested: Mar 18, 2019 2019-03-18 05:07:25.343 -0400 [ERROR|007d0|main] :: Error starting Looker: Java::JavaSql::SQLTransientException: Could not parse result THIS COULD HAPPEN IF:1. When you try to upgrade Looker to newer version and than try to go back to old oneThere is a version check betwee...

Technical Tips & Tricks

Article Use dimension type: duration to create a filter denominator

Last tested: Nov 29, 2018 If we are looking for a way to take the value of a date filter and use it as the denominator for a profit measure to create a daily profit metric.1. Create a filter only field2. Create a dimension of type duration and use liquid to extract the `date_start` and `date_end` fo...

Technical Tips & Tricks

Article How do I count the number of models or views in a project?

Last tested: Nov 14, 2017 Open the JavaScript console on a project's page, with "Cmd + Option + I" (for Mac) or "Ctrl + Shift + I" (for PC) and navigate to the "console" tab. Then, paste in one of the following commands:Count the number of models:$("#project-sidebar .model-link[href$='model.lkml']")...

Technical Tips & Tricks

Article 3 key considerations for embedded analytics

This content, written by Shohei Narron, was initially posted in Looker Blog on May 24, 2016. This content is subject to limited supportYou’ve built a great product that resonates with the market. Your customers are enthusiastic, and word of mouth is overwhelmingly positive. The in-house picture is c...

Blog Archives

Article Which TLS version and ciphers are supported for Looker hosted customers?

Last tested: Apr 8, 2020 In order to connect to a Looker-hosted instance, the your web browser or API client must support TLS 1.2 with the following ciphers: ECDHE-RSA-AES256-GCM-SHA384 ECDHE-RSA-AES128-GCM-SHA256 ECDSA ciphers are not supported at this time. This content is subject to limited sup...

Technical Tips & Tricks

Article Orphan Groups in LDAP settings

Last tested: Jul 15, 2020 If you have LDAP set up and then delete your old LDAP/AD groups in your IdP, you will still see the old group listed in the Groups page. For example, Viewing Testing (Orphan 123456789) GroupIt should be handled in the same way as SAML shadow groups, where the shadow groups...

Technical Tips & Tricks

Article JGIT FetchCommand failed: https://...git: not authorized

Last tested: Apr 13, 2020 This error can happen when you are using HTTPS connection with user attributes, with separate credentials for Dev and Prod mode, but the credentials for Production mode don't work. The dev user attribute credentials worked, so the git connection test passed, but the credent...

Technical Tips & Tricks

Article Can you add a Look to dashboards-next?

Last tested: Nov 9, 2020 Yes. However, you can only add a Look to dashboards-next through the "Save to Dashboard" option on the Look. Dashboards-next does not have an "Add Look" or Look selection menu like legacy/original dashboards has.Also, notice there are two options. Clicking "Save to dashboard...

Technical Tips & Tricks

Article Example: Changing embedded looks filters with Javascript Events

Last tested: Aug 21, 2019 This is meant for anyone who needs are looking for a working example and an explanation on changing filters of embedded private looks with javascript events. Link here:https://gist.github.com/SidneyJrLooker/47b69a4ffe7cc7ef903765a51a442e6dIf you want to test it, you will ne...

Technical Tips & Tricks

Article How long does a deleted PDT live on the scratch schema for?

Last tested: June 2021The PDT reaper process runs at most every hour (while respecting the PDT maintenance cron string).It will reap all persist_for PDTs whose time has expired, and any sql_trigger_value PDTs for which a new table has already been built.The persist_for clock begins when the PDT is f...

Technical Tips & Tricks

Article Error: Every derived table must have its own alias

Last tested: Aug 17, 2020 This is a MySQL error that gets triggered if two PDTs are named the same.If you've checked no PDTs share a name, check the dt sql for missing parentheses/brackets - not closing the parentheses can also throw this error. This content is subject to limited support. ...

Technical Tips & Tricks

Article How to access a project deploy key after Github setup has finished

Last Tested: March 7, 2021 You can get to this on the command line, if you host your own Looker instance. As of 4.8+, the public and private key live at:~/looker/deploy_keys/<project_name>/id_rsa.pub~/looker/deploy_keys/<project_name>/id_rsaAs of 4.18+, you can also get the project publ...

Technical Tips & Tricks

Article How do I check to see if auto refresh has been enabled/updated on a dashboard in the log files?

Last tested: Apr 11, 2018 A change to a dashboard's auto refresh setting will look something like this in the log files:UPDATE "DASHBOARD" SET "REFRESH_INTERVAL" = '1 hour' WHERE ("ID" = 1) Note: the "ID" refers to the dashboard ID. This content is subject to limited support.

Technical Tips & Tricks

Article How can I have a 'label' field and a 'value' field for suggestions?

Last tested: Jun 1, 2020 This is a feature request: For suggest filters, have a 'label' field and a 'value' field.There is a workaround using sql_always_where and liquid. The example is for Redshift, you should adapt the code below for your use case.explore: accidents {...sql_always_where: 1=1{% if...

Technical Tips & Tricks

Article Lookerbot Error: "s3: access denied"

Last tested: Jan 2019 You'll want to check that all the keys have write access and are set up according to the repo. One useful tidbit is that the access keys need the s3:PutObjectAcl permission. This content is subject to limited support.

Technical Tips & Tricks

Article Does changing a user's groups in SAML/LDAP affect their Looker user?

Last Tested: Jan 21, 2019 This depends on whether you have Group to Role Mapping enabled in Looker:If so, then the changes will affect the user, but only upon their next login. When a user logs in, Looker removes all of their roles and assigns new roles based on SAML/LDAP groups.If not, then changes...

Technical Tips & Tricks

Article Cannot use stable views in schema

Last tested: Apr 14, 2020 This error shows up when we're using the publish_as_db_view parameter and the Looker database user doesn't have the permission to create views on the scratch schema.If the Looker database user doesn't have permission to create views, we will either need to grant them permis...

Technical Tips & Tricks

Article How to migrate/copy schedules using API

Updated July 2021 Challenge: I want to copy the schedule of dashboard 1 and assign to dashboard 2 using API/SDK Solution: Please find an example script here This content is subject to limited support.

Technical Tips & Tricks

Article Can you use the search_dashboards() API endpoint to get information about LookML dashboards?

Last tested: Mar 9, 2020 No. The search_dashboards() endpoint doesn't return LookML dashboards at all, even if we input the space_id of lookml as a parameter. It will return a 200 in the interactive API docs, but the response body is an empty array [].As a workaround, you should be able to use the g...

Technical Tips & Tricks

Article How long must a Looker-hosted instance be unresponsive to trigger an automatic restart?

Last tested: Apr 6, 2020 Short version5 minutesLong VersionLooker sends a request to check for availability every minute, and the request is given 15 seconds to timeout. Once 5 subsequent requests time out or fail, automatic restarts kick off This content is subject to limited support. ...

Technical Tips & Tricks

Article Why do our new account set up/activation emails take new users to a log in page instead of the new account set up page?

Last tested: Sep 30, 2020 This is happening because you likely have SAML/Google OAuth/LDAP/OIDC enabled for your instance. That means Looker expects all users to authenticate through SAML.To get around this, you'll need to enable the alternate login option (Help Center article) and then add the logi...

Technical Tips & Tricks

1
...
39
40
41
42
43
44
45
...
68

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