User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started82 News & announcements109 Who's hiring397 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1445 SQL269
Exploring & curating dataExplores453 Dashboards & looks1251
Application developmentEmbedding Looker / Powered by Looker120 Open source projects46 Looker API309
AdministrationUser access & management29 General Looker administration391
Data science & analyticsGot a question?63 Share your best practices14
コミュニティフォーラム (Japanese)ニュースと告知37 ヘルプとサポート11 コラム55
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 DCL Mic Drops5

Ask question / Create topic
Login

The Kitchen Table

Explore the product knowledge we've built up together

1678 Topics

Most replies

Recently active Most views Newest first

Article Do the LookML Validator or Content Validator time out?

Last tested: May 2021 No, they do not. They will go on forever. TroubleshootingThe only known way to kill the LookML Validator or Content Validator process is to restart the instance. How long does the content validator take?This can vary wildly depending on the number of Looks and dashboards on the...

Technical Tips & Tricks

Article Can the PDT scratch schema exist in a different db host than the original tables used to create it?

Last tested: April 2021 No. Even PDT Override doesn't allow for this.The challenge here is that Looker would have to issue a multi part query: first to the database with the PDTs, and then to the database with the actual tables. Writing a coherent query with joins and such that involves two differen...

Technical Tips & Tricks

Article SMTP Error: "Failed to send mail: hostname [hostname] does not match the server certificate."

Last tested: April 2021 Check to see if TSL/SSL is enabled.That error message means that the host you're connecting to, like foo.bar.com, has an SSL cert which is for a different host, like bob.bar.com. So in this case the mail server could have the wrong cert on it (not usually the case) or Looke...

Technical Tips & Tricks

Article What happens when an embed user connects to looker but the user already exists as a regular user in looker?

Last tested: Sep 2020 In this case a new embedded user would be created. There is no way to tie an embed user created from a script to a regular user. For any embedded user that gets created, the primary key/identifier is the external_user_id field that gets passed in.Since the embed user will be...

Technical Tips & Tricks

Article What happens when you push a PDT to production?

Last tested: Sep 2019 1. If there is a previous version of this PDT in production, the existing production table will be dropped by the reaper2. If there is a version of that PDT in dev mode, the dev mode PDT will become the production PDT.3. If there is not a dev mode version of that PDT, a new P...

Technical Tips & Tricks

Article In the `update_datagroup` api call, will: {“stale_before”: now()} bust the cache?

Last tested: Oct 1, 2019 Yes, this will blow the cache for that datagroup regardless of the trigger.It means that any cache entries in that datagroup created in the past are treated as stale so queries after now() will not pull from cache.Please note that we need to put an actual value in for the no...

Technical Tips & Tricks

Article API Call Timeouts

Last tested: Nov 5, 2020 If you are using an SDK and you're hitting timeout errors on your calls, you should be able to adjust the timeout parameter on your call.For example, with the Python SDK if you are running run_inline_query(), you should be able to format it in this manner:run_inline_query({s...

Technical Tips & Tricks

Article What is the matches (advanced) filter expression syntax for not applying a filter at all?

Last tested; May 12, 2020 <=0 OR >0 OR NULL for numbers, %,NULL for strings.To get all non-null values, see How do I filter out null in a filtered measure?Here are expressions that DON'T work:NULL, NOT NULL for numbers and NULL,-NULL for strings generate AND between the two parts, so no values...

Technical Tips & Tricks

Article How are relative URLs in the link/html parameter handled? (url = "/explore...", etc.)

Last tested: Aug 23, 2019 To understand how relative URLs in the link/html parameter are handled, it is helpful to understand how relative URLs work in browsers in general. This stackoverflow post has a detailed description of the different types of relative URLs and how they work, but the basic rul...

Technical Tips & Tricks

Article Can we specify other than port 22 for SFTP?

Last Tested: Nov 27, 2018 Yes, totally. You can send to that server by specifying the port in the URL.e.g. `sftp://sftp.mysite.com:23/Home/user/desktop/`If you do not specify it, the code defaults to default SSH port 22. 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 why can't looker read my topojson?

Last tested: Mar 1, 2018 Quick answer: Upload your topojson file to a gist and put that link into the map_layer_name: map_layer: custom_manhattan_map {url: "https://gist.githubusercontent.com/your_user_name/manhattan_tracts.json"property_key: "ntacode"} Remember property_key is case sensitive. This...

Technical Tips & Tricks

Article A Cure For Merged Results

Last tested: Jan 29, 2021 Let's say that we have the salary table stored in our PostgreSQL database (Payroll) and this table has the following columns: emp_no, salary, from_date, to_date. We've created a connection in Looker that uses the Payroll database.In MySQL, we have the employees_data table t...

Technical Tips & Tricks

Article What is errorsfallback@looker.com?

Last tested: Sep 12, 2019 ProblemUsers will sometimes see the email address errorsfallback@looker.com in their SMTP logs; this is our error server where emails reporting exceptions will fall back to if their custom SMTP settings block our access to sending emails to Sentry.SolutionThe best way to ch...

Technical Tips & Tricks

Article Setting up an access_filter that applies to only specific users

Last tested: Mar 27, 2019 Every user who accesses an Explore that has an access_filter must have a value in the referenced user attribute, including administrators. More information can be found in this Community post.One way we can work around this is by using a CASE WHEN in a sql_always_where of a...

Technical Tips & Tricks

Article Having Default Label Value that's Based off a Parameter

Last tested: Mar 10, 2020 If we're having our label for a field be based off a parameter value, sometimes we might want to have our Label have a Value that's set in the Field Picker that's different from the parameter's actual value. In order to accomplish this, we can use "field._in_query" to have...

Technical Tips & Tricks

Article Hide Filters on Embedded Dashboard

Last tested: Jun 17, 2020 When you hide filters (Un-toggle show filters) on an embedded dashboard -will the dashboard still run the filters?Yes!Hiding of filters just hides them from the UI, so the filters will still be applied (either it is the default filter value in the setting, or if we were to...

Technical Tips & Tricks

Article Can you edit a look's visualization settings using the API?

Last tested: Jun 12, 2018 Yep, you can configure a visualization of a query using the query.vis_config property. First call create_query to create a new query with the desired visualization, then create a new look or update an existing look to assign the id of the query you created to the look's que...

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 Boxplot error message: "Can only combine like series on a single axis."

Last tested: Jul 10, 2019 If you see the above error on a boxplot visualization, change the chart type to line and go to Edit Visualization -> Y. We shouldn't have extra Y-axis in the line visualization configuration. Boxplots can only have a single Y-axis value. The boxplot inherits the config w...

Technical Tips & Tricks

Article Why are my totals not showing up?

Last tested: June 2020 Totals only apply to measures. They won't appear on dimensions, or on table calcs prior to Looker 6.2 (See this Community post: Why don't my table calculations have totals). This is because to run a total, we remove the dimensions and re-run the query, so that any measures are...

Technical Tips & Tricks

Article Why is my alert icon not showing on hover

Last tested: Jun 25, 2020 Check if you have the required permissionshttps://docs.looker.com/admin-options/settings/roles#create_alertsotherwiseYou might be in dev mode!!! This content is subject to limited support.

Technical Tips & Tricks

Article Model Names in the Same Instance

Last tested: Aug 12, 2020 In the same instance, you can't have two models with the same name, even if they are in different projects.But in the case of imported projects, they can have the same name.A user was wondering if you can import the same remote project twice in difference projects on the sa...

Technical Tips & Tricks

Article This "connection" is overridden by a "connection" declared in a file included below

Last tested: Mar 17, 2020 This is a warning from the content validator - and it's pretty straightforward - you can first check if the included view files have a connection parameterBut if not - you can also check if the view files included the model file! This content is subject to limited support. ...

Technical Tips & Tricks

Article Embed Showing Blank Tiles (granting "All" models)

Last tested: Nov 3, 2020 If...the dashboard in the iframe is loading in okay, but the tiles are blank (or have a dash on it) the admin query panel shows that these queries erred out "access denied" in the detailsCheck if your models are right in the embed urlYou can't use "All" to include all models...

Technical Tips & Tricks

1
...
41
42
43
44
45
46
47
...
68

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

© 2020 Looker Data Sciences, Inc.
Privacy | Terms | Cookies | Community Guidelines