Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring413 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1559 SQL284
Exploring & curating dataExplores490 Dashboards & looks1353
Application developmentEmbedding Looker / Powered by Looker132 Open source projects47 Looker API331
AdministrationUser access & management51 General Looker administration413
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 ${TABLE} is not allowed in the 'X' property.

Last tested: Aug 29, 2019 If you get an e-mail with a schedule error and it says ${TABLE} is not allowed in the 'X' property, this because you are using ${TABLE} outside of a sql parameter.Example of where this would fail:dimension: test {type: stringsql: ${TABLE}.field ;;# The below html references...

Technical Tips & Tricks

Article How to prevent committing changes when there are LookML errors (Code Quality)

Last tested: Apr 10, 2017 If you want to make sure that your production LookML has no errors, you can enable Code Quality in Project Settings.Cite Docs.Starting in 5.22, users have the option to allow committing with warnings but still prevent committing with errors. This content is subject to limit...

Technical Tips & Tricks

Article Do users need "manage_spaces" permission to make new folders in their personal space?

Last tested: Feb 6, 2020Yes! Users will need themanage_spaces permission andManage Access, Edit permissions in a folder in order to create subfolders, even in a personal folder. This content is subject to limited support.

Technical Tips & Tricks

Article Does system activity track changes made to user attribute values?

Last tested: Jan 12, 2021No, it does not. If a user is edited to update the value of a user attribute, there is somewhat generic record added to the 'event' table for the user, and also the user's group being updated, as it appears that all of the user's values are updated in the internal database w...

Technical Tips & Tricks

Article Referencing quarter with parameter after casting quarter into a string

Last tested: Aug 31, 2020 Users typically like to follow this article where they are required to cast the CASE WHEN into the same datatype due to their SQL dialect.When we cast quarter into a type varchar, we'll get 2016-01 returned instead of 2016-Q1. How do we get around this problem?SolutionTo do...

Technical Tips & Tricks

Article Replace commas in a list field with carriage returns using liquid

Last tested: May 26, 2020 Say you have a field that shows up like a, b, c but you want it to display in a single row asa b cYou can use a Liquid for loop with the split function to achieve this!html: {% assign items = your_dimension_here._value | split: ", " %}{% for item in items %}{{ item }}{% end...

Technical Tips & Tricks

Article Startup failed. Unable to load java dependencies.

Last tested: Sep 21, 2020 A self-hosted user may run into this error upon restarting/updating your instance.If the error is prepended by WARN: there must be at least 750MB of free space in the temp directory, then you probably don't have enough free space. Go and run df -h as the Looker user to see...

Technical Tips & Tricks

Article When would I use the | symbol after the sql parameter in old LookML?

Last tested: Feb 20, 2018 The pipe | symbol is only used in old LookML. It tells the validator that multiple lines of code are coming. This has been replaced in New LookML with the ability to use double semicolons to end code blocks like html or SQL. # Example of | used correctly. Without the |, thi...

Technical Tips & Tricks

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 How are Out-of-Date PDTs Managed?

Last tested: May 22, 2018 Persistent Derived Tables are automatically reaped by Looker based on the following rules:If refresh is tied to a particular time (e.g. set via 'persist for'), then the PDT will be reaped from the database 1 hour after the persistence window expires.PDTs in Dev-Mode are tre...

Technical Tips & Tricks

Article Does SQL Runner use cache?

Last Tested: Aug 30, 2018 No, it doesn't. While explores, looks, and dashboards may use cache, SQL Runner executes the query directly against the database.If it looks like SQL Runner is caching, check to make sure that it isn't the database doing that. Some databases such as Redshift may be doing re...

Technical Tips & Tricks

Article Can I merge users into my new [SAML/LDAP/Gauth/OpenID] authentication?

Last Tested: Sep 18, 2019 If you're migrating to Google Auth or LDAP, you can merge from Looker email/password credentials. You cannot merge from any other authentication source. The LDAP setup Docs and Gauth setup docs show the checkbox you need, "merge by email”. If you're migrating to SAML or Op...

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 How do I compare dates in table calcs?

Last tested: June 2020There are two methods for date comparison in table calcs. Use diff_days or any of the other diff_ functions (docs). For example, to say "${date_a} > $[date_b}", just do diff_days(${date_b},${date_a}) > 0. The extract_ familiy of functions can be useful since they let yo...

Technical Tips & Tricks

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 Why would a dashboard filter change to matches(advanced)?

Last tested: Sep 28, 2020 If this is happening for some users only:We have seen this happen when a user doesn't have the model specified in a dashboard's field filter in their model set, or also when the model for that dashboard field filter hasn't been configured. In this case, the dropdown for the...

Technical Tips & Tricks

Article What permission do I need to schedule based on a datagroup?

Last tested: Apr 7, 2020 Besides the general scheduling permissions, you need the develop permission on the model where the datagroup is defined AND see_datagroups. This means that only developers can schedule based on a datagroup.You do NOT need update_datagroups —this permissions is only for seein...

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 How are NDTs built in relation to referenced derived tables?

Last tested: Jan 21, 2019 When you create an NDT (native derived table) that isbased on an explore which is filtered by a field in a joined table from that exploreAND/ORfiltered by a field in a different view than the NDTthe NDT will build as a nested with clause subquery, such as: WITH NDT as (WITH...

Technical Tips & Tricks

Article "Key is already in use" when resetting git connection

Last Tested: Dec 27, 2018 The ProblemWhen you reset a git connection, Looker provides the same deploy key as it did the first time the git connection was set up.The SolutionIf you're not changing remote git repositories, this means you don't need to re-add the key. It's already in your remote git re...

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

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

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