Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started153 News & announcements128 Who's hiring443 Release notes (archive)63 Lesson Comments15 Challenge10
Looker developmentLookML1889 SQL327
Exploring & curating dataExplores579 Dashboards & looks1624
Application developmentEmbedding Looker / Powered by Looker162 Open source projects56 Looker API388
AdministrationUser access & management77 General Looker administration464
Data science & analyticsGot a question?87 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1741 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥4
コミュニティフォーラム (Japanese)ニュースと告知51 ヘルプとサポート14 コラム69

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2111 Topics

Most replies

Recently active Most views Newest first

kevin.dunnLooker Staff

published in Technical Tips & Tricks

Why is the PDT Event Log - Action Data column null?Knowledge Drop

Last tested: Jun 26, 2020 If pdt_event_log.action is like 'trigger%', 'regenerate%', 'reap%', that row is deleted after 5 days. But if the pdt_event_log.action_data contains any data at all after 5 days, action_data is overwritten with NULL for that row. This content is subject to limited support.

120

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

What does a history status of 'hold' mean?Knowledge Drop

Last tested: Dec 18, 2020 It means another query with the same render key (exact same query) is currently running. We use this status to avoid having duplicate queries run against the db, and instead put one on hold so that it can pull from cache after the query successfully runs. This content is subject to limited support.

190

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

Why can't a developer send data from a SQL Runner ExploreKnowledge Drop

Last tested: Jun 25, 2020 The ProblemA developer opened an explore from a SQL Runner query, but they don't see the send option in the explore settings dropdown.The reasonSQL Runner explores are based on a hidden model, and the user will need access to that model in order to send data. Because the model is hidden, only users who have 'All Models' access through their model set will be able to send data from SQL Runner Queries. This content is subject to limited support.

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

Can non-administrators manage content for embed users/groups folders?Knowledge Drop

Last tested: Mar 25, 2020 No, most users end up managing this content in regular shared folders, and give the embed users access to those shared folders. This content is subject to limited support.

140

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

Why am I seeing a Variable not found "value" error in liquid when checking if value == true?Knowledge Drop

Last tested: May 14, 2020 The ProblemYou're trying to check if a boolean is true or false, but you get a variable not found error, if your boolean is false.This happens in some dialects that support booleans as true/false values because a value of false, similar to null/nil, is actually the absence of a value, so liquid has no value to check against.Example LookML that could cause this: dimension: falsey {type: stringsql: false ;;html: {% if value == true %}style{% else %}other style{% endif %};; } A SolutionUse a yesno dimensions instead, or check against the rendered value (or both!)dimension: falsey {type: yesnosql: case when false then no else 'yes' ;;html: {% if rendered_value == 'yes' %}style{% else %}other style{% endif %};; } This content is subject to limited support.

3270

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

How to find a full commit/tag SHAKnowledge Drop

Last tested: Nov 10, 2020 The commit Tag/SHA is accessible inside of Looker's commit history, as well as inside of the remote repo.Inside of Looker's commit history, you can right click on a commit to copy the address - The SHA will be the last portion of the URL:Inside of the remote repository, you can navigate to the commits page and copy the SHA from there (this example is GitHub): This content is subject to limited support.

100

1 year ago

kevin.dunnLooker Staff

published in Technical Tips & Tricks

Why do I see `_1` appended to field name aliases in generated SQLKnowledge Drop

Last tested; Mar 24, 2020 This happens when a field name has upper-case letters. Because LookML is case sensitive, we append a _1 to the field name alias in the generated SQL to avoid any potential collision with a field that has the same name with different case.Generated SQL looks something like: SELECTview.field_name AS view_field_name_1FROM `bigquery-table-stuff` For a field that is simply: dimension: Field_Name {type: stringsql: ${TABLE}.field_name ;;} Example: ### Capital Letters ### explore: NEW_EXPLORE {from: breedsjoin: not_bites {from: bitestype: left_outersql_on: ${not_bites.breed} = ${NEW_EXPLORE.breed_name} ;;relationship: one_to_one}}### GENERATED SQL ###SELECTNEW_EXPLORE.breed_name AS new_explore_breed_name_1,1=1 AS new_explore_dummy_1FROM dogs_of_new_york.breeds AS NEW_EXPLOREGROUP BY 1ORDER BY 1### Lower case ###explore: new_explore {from: breedsjoin: not_bites {from: bitestype: left_outersql_on: ${not_bites.breed} = ${new_explore.breed_name} ;;relationship: one

330

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

Missing values for 'VIEW_NAME.FIELD_NAME' were not filled. It is unclear what values to fill for this field.Knowledge Drop

Last tested: Nov 8, 2020 When you receive a report with an error message like below: One of your tiles are hitting this error:Missing values for 'VIEW_NAME.FIELD_NAME' were not filled. It is unclear what values to fill for this field. We won't be able to see this error message on a dashboard, but when you go to the edit page of the tile, you will see that message there:According to Chris's response in this community post, this error occurs when dimension fill is being applied to a dimension that cannot use dimension fill. Most commonly, the dimension previously defined as a yesno, tier, date, or case type dimension but was later changed to a string or number type, you might encounter this error.SolutionIf dimension fill is turned on, you can turn it off by selecting Remove Filled in Values from the gear menu for that column, which should remove the error message.Find this error message in the edit page of your tile: Missing values for 'VIEW_NAME.FIELD_NAME' were not filled. It is uncl

5930

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

Dynamically change a referenced pivot column based on latest date shown in the data tabKnowledge Drop

Last tested: Nov 30, 2020 GoalWhen we use a pivot table, sometimes we want to display ONLY most recent date/week/year columnChallengeBut Number of pivoted columns are changing based on filter definitions. So we don't want to hard code to define reference column with pivot_index function. How can we dynamically change referenced pivot column based on latest date shown in the data tab?e.g.When I run query without filter(1), I have 5 pivoted columns (year 2013, 2014, 2015, 2016 and 2017). In this case, we want to display user counts only for year 2017. However, if end-user filter out data(2) with the city name River Falls, we see 3 pivoted column in table chart. In this case, we want to display user counts for year 2016.(1) Without Filter value:(2) With filter value:Solutionpivot_where(${users.created_year}= pivot_index(${users.created_year},max(pivot_row(pivot_column()))), ${users.count}) Here is a template!pivot_where(${PUT YOUR TIME/DATE/WEEK/YEAR FILED} # I used YEAR for this sample=

1610

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

What is pdt_build_failure_cleanup ?Knowledge Drop

Last tested: Jan 20, 2021 When a build fails or is detected as being canceled, we drop the table that may have been partially created. We do this to make sure the name is available for a subsequent build attempt. This content is subject to limited support.

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

Custom SMTP: Failed to send mail: 501 Sender syntax errorKnowledge Drop

Last tested: Nov 30, 2020 When we see this error message on SMTP setting page, more likely to be due to incorrectly defined the "from" setting. User should insert an email address for "from" setting.　 ref:Email With Rails 3 and Heroku Net::SMTPSyntaxError: 501 Syntax error "Sender syntax error" in Chilkat4Xojo This content is subject to limited support.

2550

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

Can we automatically select previous year based on user input filter value?Knowledge Drop

Last tested: Jan 28, 2021 Yes! I believe there are other way to do, but I hope it can be useful! ( BigQuery StandardSQL)At high level, we want to use sql_always_where parameter with Liquid Parameter to achieve this:STEP 1Add an unquoted type parameter field in your visualization:view: view_name {...parameter: base_year {type: unquoted}} STEP2Add a sql_always_where parameter in your Explore. In a sql_always_where parameter, we want to use Liquid parameter to define BETWEEN condition based on user input (parameter filter value):explore: explore_name {sql_always_where:cast(${view_name.year_from_dimension_group} as int64) -- target fieldbetween({% parameter view_name.base_year %} - 1) -- filter value - 1and {% parameter view_name.base_year %} -- filter value;;} This content is subject to limited support.

200

1 year ago

Kento_TomineModerator

published in Technical Tips & Tricks

jon.allenLooker Staff

published in Technical Tips & Tricks

Tips For Debugging ActionsKnowledge Drop

Last tested: Jul 6, 2020 Get the webhookIDs of the failing action. Map ID with logs on ActionHub Prod* Is it a streaming action?https://docs.looker.com/admin-options/platform/actions#list_of_integrated_services* If yes, do you use of the action use all_results? This will use more than 5000 results and often results in heavier usage. It will also require a connection from ActionHub to Looker.* Is the action “heavy”? (it will execute on a queue)https://github.com/looker/actions/tree/master/src/actions if the action is “heavy” - it will have executeInOwnProcess = true in its definition* When is the action scheduled? useful for knowing if they schedule during peak times Did the action send the data even if the scheduler say it didn’t? This content is subject to limited support.

710

1 year ago

jon.allenLooker Staff

published in Technical Tips & Tricks

What happens when a node in a cluster fails?Knowledge Drop

Last tested: Jan 10, 2020 Do the other nodes recognize the failed node?Indirectly, yes -- The node's aren't keeping an eye on each other directly (they aren't pinging each other) but the scheduling engine recognizes the node failure based on the internal db's node heartbeat table and will restart/redistribute the schedule jobs accordingly.When one of the looker node fails, do the active looker nodes start accepting requests that were sent to the failed node?The load balancer will stop sending front-end requests to the failed node when it fails to receive a response. The scheduler will pick up on work that has failed due to a node disappearing, and restart that work on an active node. This content is subject to limited support.

220

1 year ago

jon.allenLooker Staff

published in Technical Tips & Tricks

Tracking Schedules with System ActivityKnowledge Drop

Last tested: Jan 27, 2020 The scheduled_plan System Activity explore is a great place to follow the movement of a schedule job through the different stages of a schedule job's lifecycle.You can access the scheduled_plan System Activity explore with the following link (replace company with your hostname): https://company.looker.com/explore/system__activity/scheduled_planAt a high level, the notable views and fields available in that explore are:Scheduled job Created Date Time & Finalized Date Time ID (scheduled job ID) Status & Status Detail Scheduled plan Content Type ID - shows the content type (Dashboard, Look) as well as the ID of the dashboard or look, plus a link to that content Cron Schedule & Datagroup -- this will tell you when the schedule is *supposed* to run. ID (scheduled plan ID) User ID -- the owner (usually creator) of the schedule plan Scheduled plan destination Address - can be an email address, sftp address, S3 bucket, etc. Format - csv, wysiwyg_p

2060

1 year ago

jesse.carahLooker Staff

published in Technical Tips & Tricks

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

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.com/my-company/project-foo - under the branch dev-john-smith-wxyz.When you deploy to production, Looker first checks that all the commits in github.com/my-company/project-foo branch master are reflected in dev-john-smith-wxyx. If they are not, then you will need to pull changes and merge. Once that is done, you can deploy to production again. Looker will push dev-john-smith-wxyx to the master branch on github.com/my-company/project-foo. When that succeeds it will also then pull master from github.com/my-company/project-foo to the master branch in the local repo in looker/models/project-foo.If you have pull requests set up, instead of deploying to production Looker will create a pull request a

310

1 year ago

jamesnestlerLooker Staff

published in Technical Tips & Tricks

How to disable tooltip in chart entirelyKnowledge Drop

Last tested: Apr 13, 2020 This is a feature request you can vote on our feedback system: Turn off tooltip capabilities on a look.Workaround:You are not able to in the measure, use an empty html parameter like so (ex: html: ;; ), because If you use an empty HTML parameter, you will see the IDE error of Must provide HTML for "html"The current workaround for this is to either copy a whitespace character in to the html parameter from a site you can find on line , or to use an empty p tag (<p></p>).This will cause blanks in the data results tab where the values are, as well as in the tooltip when you hover over the values. The underlying data will not change, and the visualization should look the same. This content is subject to limited support.

3190

1 year ago

Page 62 / 85

Badges

sbrylowskihas earned the badge Friendly Face
carriehas earned the badge Helpful
carriehas earned the badge Community Star
carriehas earned the badge Friendly Face
Dawidhas earned the badge Community Star

Show all badges

Sign up

Already have an account? Login

Social Login

Username *

E-mail address *

Company

(Private)

Only you and moderators can see this information

Password *

I accept the Terms of Service.

If you’re an EEA-based consumer of digital content, services, or goods, and you’ve agreed to our Terms of Service, then EEA consumer laws provide you with a legal guarantee. Under this guarantee, we’re liable for any lack of conformity that you discover for the one-time supply of digital content or services at any time during the “continuous” supply of digital content or services.
Your national laws may provide an even longer guarantee. Your rights under these legal guarantees aren’t limited by any other commercial guarantees that we provide. If you want to make a guarantee claim or if you would like to delete your account data, please contact us lookerconnect-help@google.com.

loginBox.register.email_repeat

Login to the community

No account yet? Create an account

Social Login

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.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

The Kitchen Table

Why is the PDT Event Log - Action Data column null?Knowledge Drop

What does a history status of 'hold' mean?Knowledge Drop

Why can't a developer send data from a SQL Runner ExploreKnowledge Drop

Can non-administrators manage content for embed users/groups folders?Knowledge Drop

Why am I seeing a Variable not found "value" error in liquid when checking if value == true?Knowledge Drop

How to find a full commit/tag SHAKnowledge Drop

Why do I see `_1` appended to field name aliases in generated SQLKnowledge Drop

Missing values for 'VIEW_NAME.FIELD_NAME' were not filled. It is unclear what values to fill for this field.Knowledge Drop

Dynamically change a referenced pivot column based on latest date shown in the data tabKnowledge Drop

What is pdt_build_failure_cleanup ?Knowledge Drop

Custom SMTP: Failed to send mail: 501 Sender syntax errorKnowledge Drop

Can we automatically select previous year based on user input filter value?Knowledge Drop

Can we hide schema in SQL Runner?Knowledge Drop

Can we disable curated search by default?Knowledge Drop

Is there a difference between data actions and "action hub"?Knowledge Drop

Can we apply pivot over dimension?Knowledge Drop

Default_locale on localization settingsKnowledge Drop

Does the access_filter get extended when I extend an explore?Knowledge Drop

Can we hide filters in Looks?Knowledge Drop

Modularity: The "Building-Block" Approach to LookML DevelopmentKnowledge Drop

Tips For Debugging ActionsKnowledge Drop

What happens when a node in a cluster fails?Knowledge Drop

Tracking Schedules with System ActivityKnowledge Drop

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

How to disable tooltip in chart entirelyKnowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded