User Guide
Getting Started
Help Center
Documentation
Community
Training
Certification

Getting Started

Community
WelcomeGetting started87 News & announcements110 Who's hiring407 Release notes (archive)63 Lesson Comments11 Challenge10
Looker developmentLookML1488 SQL277
Exploring & curating dataExplores465 Dashboards & looks1298
Application developmentEmbedding Looker / Powered by Looker125 Open source projects46 Looker API321
AdministrationUser access & management39 General Looker administration397
Data science & analyticsGot a question?65 Share your best practices15
コミュニティフォーラム (Japanese)ニュースと告知40 ヘルプとサポート11 コラム58
The Kitchen TableTechnical Tips & Tricks1659 Common Account Questions14 DCL Mic Drops5

Ask question / Create topic
Login

Community
The Kitchen Table

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

1678 Topics

Most views

Recently active Most replies Newest first

Article Schedule Failed to Send (data action) {"webhook_id":null,"success":false,"refresh_query":false,"message":null,"validation_errors":null}

Last tested: Jan 17, 2019 With storage Action Hub integrations, you may run into schedules failing with the {"webhook_id":null,"success":false,"refresh_query":false,"message":null,"validation_errors":null} message in the Admin > Scheduler > History panel.Check to see if you have a file named s...

Technical Tips & Tricks

Article My parameters aren't matching _parameter_value

Last tested: Jul 13, 2018 The field_name._parameter_value syntax brings in single quotes. So to match it, you need to use double quotes to include single quotes. If the parameter value is supposed to be foo , then you'd write something like: sql: {% if test._parameter_value == "'foo'" %} 'SUCCESS' {...

Technical Tips & Tricks

Article Can Looker connect to a git subfolder?

Last tested: Aug 22, 2017 No - it can only connect to a repository.Possible error messages:Internal error 'no such service https/tcp' when running test This content is subject to limited support.

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 Stable PDT name not showing up with publish_as_db_view

Last tested: Mar 23, 2020 Did you add the publish_as_db_view parameter after the table has been built and pushed to production?If so, the stable name will not show up.It'll only show up once the table has been rebuilt, so setting the publish_as_db_view_parameter as yes is not enough. You will either...

Technical Tips & Tricks

Article How to list all the views used in an explore in system activity?

Last tested: Jun 9, 2020 Use this link changing the domain name to your instance one.There are a few caveats though, if you have fields: [] then it won't list this view since there are no fields to list. [DOMAIN_NAME]/explore/system__activity/field_usage?fields=view_name_list,field_usage.explore&...

Technical Tips & Tricks

Article Content Validator for Merged Results

Last tested: Sep 9, 2019 To follow along, think of a situation where you have a merged results tile which is named MR Dash. MR Dash merges the results of two explores(For example, Explore1 and Explore2) which currently belong to one model, named ModelA. Unfortunately, if you try to change the model...

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 Alias in filter suggestions

Last tested: Apr 30, 2020 If you're using an ID, you may want to use a more human-friendly suggestion for that ID for users to select.Unfortunately, we currently can't alias filter suggestions without parametersBut as a workaround, you might suggest creating a concatenated field that uses the human-...

Technical Tips & Tricks

Article Why am I seeing a `SELECT boundary AS boundary FROM (SELECT ...)` query in our DB? Dimension fill!

Last tested: Sep 29, 2020 This query is being generated from Dimension Fill in explores using time based dimensions. The SQL here doesn't show on the SQL tab and gets run separately and added into the results after. This can be disabled on a field by field basis by setting allow_fill: no (documentat...

Technical Tips & Tricks

Article What could cause the "condition" field to be blank in an alert?

Last tested: Jun 12, 2020This can happen when you create an alert on a field in a pivot and the value becomes null - since there isn't a value for the pivot column, Looker treats it as if it never existed. The pivot columns are purely based on data and not defined in LookML or the DB itself, so if i...

Technical Tips & Tricks

Article Can we use Angular for the extension framework?

Last tested: Oct 7, 2020Angular is not supported right now. In theory, any application framework can be used to build an extension, but we highly/strongly recommend React. Potentially, you could use a converter like this, but our engineers suggest it would not be an optimal development process. With...

Technical Tips & Tricks

Article What git commands are executed under the hood when the "Deploy to Production" button is pressed?

Last tested: Oct 15, 2018 You are in dev mode, working on a branch dev-john-smith-wxyz in the local repo in the looker/models-user-123/project-foo directory.When you commit, you commit to the local repo under looker/models-user-123/project-foo and also push your changes to the shared repo - github.c...

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 Online sandboxes and handy testing tools for SQL databases, HTML, Javascript, CSS, ...

Last tested: May 1, 2020 Here is a list of some online Sandboxes and handy testing tools for SQL databases, HTML, Javascript, CSS, and several other programming languages1 RexTester Sandbox online for several programming languages online https://rextester.com/l/postgresql_online_compiler 2...

Technical Tips & Tricks

Article Getting a branch you've created on Github, into Looker

Last tested: Mar 19, 2020 QUESTIONI've created a branch in Github, and am now wondering how I would be able to get that branch into Looker.ANSWEROne possible solution is to merge that branch with a shared branch that was created in Looker and pull from remote. This content is subject to limited supp...

Technical Tips & Tricks

Article Why am I seeing outdated branches when I select them in Git Actions?

Last tested: Jul 28, 2020The Problem:After selecting someone else's personal branch, I'm not seeing the changes they had just committed. But when we sudo as the user, we clearly see the new code!The Fix:When you've selected the branch, On the top right corner, Validate the LookML and Pull Remote Cha...

Technical Tips & Tricks

Article If you have a templated filter in a derived table and you reference that table in another derived table, can you pass the filter value through?

Last tested: Jan 10, 2019 No, you would have to create the templated filter in your new derived table. The DT doesn’t “store” the templated filter, it’s just part of the sql. This content is subject to limited support.

Technical Tips & Tricks

Article Why am I getting a warning for the explore or field parameter in my LookML dashboard filter?

Last Tested: Jan 21, 2019 The explore parameter is a valid parameter only for type: field_filter LookML dashboard filters. Like a UDD field type filter, this is the only filter type that queries a field in an explore to pull suggestions from—all other filter types do not need to query a field.This t...

Technical Tips & Tricks

Article Can I create an Embed user from the API?

Last tested: Jan 1, 2020Yes, as of Looker 6.24, there is a create_sso_embed_url API endpoint. Once the embed URL is created, accessing it will create the embed user. This content is subject to limited support.

Technical Tips & Tricks

Article Can non-admins have certain admin privileges? System Activity, PDT panel, queries, logs, etc.

Last tested: Jan 21, 2019 Currently, the only admin privileges you can give to non-admins are:see_queriessee_logssee_userssudosee_schedulessee_pdtssee_datagroupsupdate_datagroupssee_system_activity (new as of 5.20)(from permissions list)It's not currently possible for non-admins to:manage authentica...

Technical Tips & Tricks

Article In what order are operations based on datagroups performed?

Last tested: Nov 13, 2018 1. Check trigger (if triggered proceed to step 2)2. Rebuild any PDTs which use this datagroup as their datagroup_trigger3. Invalidate any existing cache entries which use this datagoup as their persist_with datagroup4. Run any schedules based on this datagroup This content...

Technical Tips & Tricks

Article How do I use custom filters to get a YoY of the last X complete days within the same month?

Last tested: Apr 23, 2019 Use this awesome filter:(extract_months(${date}) = extract_months(now())) AND extract_days((${date})) <= extract_days(now())-1ANDextract_days((${date})) >= extract_days(now())-xAND(extract_years(${sources.date_date}) = (extract_years(now()))OR extract_years(${sources....

Technical Tips & Tricks

Article How do I apply a filter for a whole view, regardless of what explore it's used in?

Last tested: March 2021 You might want the behavior of sql_always_where to apply the view level rather than the explore level.In that case, you can: Build a derived table with the desired WHERE clause, or use a sql_table_name like: sql_table_name: (SELECT * FROM table WHERE X != 0) ;;It is a feat...

Technical Tips & Tricks

Article What happens when a non-admin user is given `see_users` on a closed system?

Last Tested: Jul 3, 2018 A user granted this permission can see all users in all groups on an instance, even on a closed system. Non-admins with the see_users permission can see ALL users in the system, not just those in their same user group. This content is subject to limited support. ...

Technical Tips & Tricks

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

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