Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Knowledge base
Community ResourcesUsing the Community3 Account Info & Registration4 Community Feedback1
Community
WelcomeGetting started162 News & announcements131 Who's hiring447 Release notes (archive)63 Lesson Comments17 Challenge10
Looker developmentLookML1947 SQL337
Exploring & curating dataExplores593 Dashboards & looks1680
Application developmentEmbedding Looker / Powered by Looker169 Open source projects58 Looker API399
AdministrationUser access & management78 General Looker administration472
Data science & analyticsGot a question?90 Share your best practices16
The Kitchen TableTechnical Tips & Tricks1742 Common Account Questions14 Blog Archives347 DCL Mic Drops5 Video Tutorials 🎥5
コミュニティフォーラム (Japanese)ニュースと告知52 ヘルプとサポート14 コラム70

Ask question / Create topic
Login

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2113 Topics

Recently active

Most replies Most views Newest first

romain.ducarrougeLooker Staff

published in Technical Tips & Tricks

Example Ruby API script to update a LookKnowledge Drop

Last tested: Jun 8, 2018 require 'looker-sdk'LOOKER_ID = ENV['LOOKER_ID'],LOOKER_SECRET = ENV['LOOKER_SECRET']LOOKER_PATH = 'https://company.looker.com:19999/api/3.0'looker = LookerSDK::Client.new(:client_id => LOOKER_ID,:client_secret => LOOKER_SECRET,:api_endpoint => LOOKER_PATH)# get look, here look id 32my_look = looker.look(32)# get query id for lookmy_query = looker.query(my_look.query_id).to_attrs# set new filters, here update the value for order_idmy_query[:filters] = {:"order_items.order_id" => "<567"}# remove the client id!my_query[:client_id] = {}# create a new querymy_new_query = looker.create_query(my_query)puts "New Query ID: " + my_new_query[:id].to_s# update look with new querymy_look = looker.update_look(32, :query_id => my_new_query[:id])puts "Updated Look Query ID: " + my_look[:query_id].to_sif my_new_query[:id] == my_look[:query_id]puts "Success!"elseputs "Fail again, fail better"end This content is subject to limited support.

220

1 year ago

romain.ducarrougeLooker Staff

published in Technical Tips & Tricks

GIT - Find all commits for a day (or date range)Knowledge Drop

Last tested: Oct 27, 2020 If you have access, from a project folder on the Looker instance, you can run the following git command to find all the commits done on 2017-11-12:git log --after="2017-11-12 00:00" --before="2017-11-12 23:59" This content is subject to limited support.

260

1 year ago

ruth.mcelroyLooker Staff

published in Technical Tips & Tricks

Using assign | sql_quote filter value in an if statement in a derived tableKnowledge Drop

Last tested: Dec 22, 2020 The ProblemIf using the liquid assign tag to assign a filters value to a liquid variable, and then using this variable in an if statement in a derived table; the if statement does not seem to be pointing to the correct one based on the filters value.A SolutionYou will need to wrap the value in double quotes, and if it is a string that will result in double and single quotes like so: In the above derived table you can see that we have -- {{is_timezone_filter_quote}} in the top under our assigned. This prints the exact value of our assigned variable from the assign for the filter.You can see here in the explores sql that the assigned fields value is actually 'Yes' , a Yes wrapped in single quote all of which is a string value, so then we need to use "'Yes'" in the if statement to define this as the string value including the single quotes. Just to note: If using the _filter reference directly in the if statement and NOT using assign though, you don’t need to

2290

1 year ago

romain.ducarrougeLooker Staff

published in Technical Tips & Tricks

Why is there 2 / in the SSO embed url? ( like /login/embed//embed OR company.looker.com//login/embed)Knowledge Drop

Last tested: Feb 3, 2021 /login/embed//embedThis is normal!With our scripts we end up with: https://your_company.looker.com/login/embed//embed encoded version:https://your_company.looker.com/login/embed/%2Fembed instead of:https://your_company.looker.com/login/embed/embed The path is /login/embed/ (that is the route that the server is responding to) the first URL parameter for that route is the target_url (which needs to be url encoded).The first slash separates the /login/embed from the target url and the second is part of the target url.So you can think of it like this:/login/embed/<target_url> where the target url is /embed/dashboards (but url encoded)If you omitted the first one, you wouldn’t be able to log in (because the /login/embed%2Fembed%2Fdashboards route doesn’t exist. And if you omitted the second one (`%2F`) you would successfully log in but when you got redirected after login, you’d go to https://your_company.comembed/dashboards which ALSO wouldn’t work (because `

290

1 year ago

ruth.mcelroyLooker Staff

published in Technical Tips & Tricks

How do I escape a string starting with "-" in a Filter Expression?Knowledge Drop

Last tested: May 29, 2019 Filter expressions read in the character "-" to mean NOT, so filtering on a string value starting with a dash will actually return all results EXCEPT the specified string.To get around this we can escape the string with a carat. For example: "-value" will become "^-value". This will then filter correctly for strings with the value "-value". This content is subject to limited support.

590

1 year ago

ryan.dunlavyLooker Staff

published in Technical Tips & Tricks

Render error: RendererAuthenticationHTTPException or LOGIN_HTTP_ERRORKnowledge Drop

Last tested: Mar 27, 2020 For this error type, the RendererAuthenticationHTTPException error will appear in the schedule history or the PDF/PNG download page and LOGIN_HTTP_ERROR will appear in the logs.DescriptionWhen rendering with Chromium, Chromium will first check that the Looker instance is available by navigating to /alive. Then, it will login as the Looker user rendering the content with a one-time login token at /login/ephemeral and then load the dashboard or look to be rendered.This error means that when logging in as the Looker user at /login/ephemeral the page did not redirect to a page with a 200 response. In other words, something went wrong when trying to log the user in.TroubleshootingA couple things to check:What page is the user redirected to if they login for the first time? Is that page valid? Broken homepages or default spaces/boards that return a 404 will cause this error. Are there errors in the JS console on any/all pages for that user, including the homepage? T

3090

1 year ago

ryan.bouquetLooker Staff

published in Technical Tips & Tricks

PDTs not Dropping from Scratch SchemaKnowledge Drop

Last tested: Apr 27, 2020 Check that the cron string for the connection is valid. If it is incorrect, then the reaper and regenerator will not run on scheduled intervals, and the schema will fill up with manually run PDT builds.This will appear in the logs as reap connection [connection name] caught exception Bad Vixie style specification [erroring part of cron string] This content is subject to limited support.

470

1 year ago

ryan.dunlavyLooker Staff

published in Technical Tips & Tricks

What does RendererNoCliprectFoundForElementError mean?Knowledge Drop

Last tested: Jun 24, 2019 The "nocliprect" error means that when Chromium polled the page for the size of the visualization element there was no visualization element present. Also worth pointing out that when we render individual dashboard tiles (AKA the Images of Visualizations option) that we convert each tile into it's own explore and capture the output from that. This error often comes up when there are no results in the rendered content.This error will appear as Uncaught (in promise) Error: Incompatible element passed to getClipRect in the logs. This content is subject to limited support.

1 year ago

ryan.dunlavyLooker Staff

published in Technical Tips & Tricks

Render error: Chromium was not able to render the page to PDF in 300000ms.Knowledge Drop

Last tested: Mar 18, 2020 The ProblemThis error means that after the queries finished running on the page and was ready to render, the process of saving the finished page as a PDF either failed or was still processing after 5 minutes of trying to create the PDF. This will often happen if the dashboard is really large or has a lot of data, and Chromium struggled to save the full page. The SolutionIf you notice slow performance in your browser when viewing the dashboard, it may be that you need to make the dashboard smaller. If you host your looker instance, you may need to allocate more resources to the server so that Chromium has enough memory and CPU time to run without hanging.There is also an experimental feature called Render Long Tables, which can reduces the dashboard PDF rendering times for dashboards containing tables with many rows. This content is subject to limited support.

700

1 year ago

ryan.dunlavyLooker Staff

published in Technical Tips & Tricks

What timezone do alerts send in?Knowledge Drop

Last tested: Jul 2, 2019 Up until 6.18, all alerts would send in the server timezone. For all Looker-hosted customers this will mean the times will be in UTC.After 6.20+, it will send in the users' specific timezone. If they do not have user specific timezones enabled, alerts will use application timezone. This content is subject to limited support.

650

1 year ago

ryland.wolffLooker Staff

published in Technical Tips & Tricks

Why does my Percent of Total (percent_of_total) measure show up as null?Knowledge Drop

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, then this will require a derived table instead. This content is subject to limited support.

860

1 year ago

ryland.wolffLooker Staff

published in Technical Tips & Tricks

How do type: yesno fields work?Knowledge Drop

Last tested: Aug 25, 2020 A yesno field will only evaluate a single thing. If we have a boolean coming in from the database, we can set the yesno field to something like this: dimension: yesno_fieldtype: yesnosql: ${TABLE}.boolean_database_column ;; When that database column is true, we get a "Yes", and when it is no we will get a "No". However, we will also get a "No" if the row is null, since it does not meet the single evaluation of the boolean being true. This can become tricky if we are using this field in a filtered measures. That is, we may get cases where the row does not meet the criteria, but is also not a false value on the DB. A better solution if there are null values is a LookML CASE statement. This content is subject to limited support.

11470

1 year ago

sarah.tayeriLooker Staff

published in Technical Tips & Tricks

Why is my aggregate table not being used?Knowledge Drop

Last tested: Oct 16, 2020 The following needs to be true in order for Looker to use the aggregate table on an explore query:The Explore query’s fields are a subset of the aggregate table’s fields (see: Field Factors). Or, for timeframes, the Explore query’s timeframes can be derived from the timeframes in the aggregate table (see: Timeframe Factors). The Explore query contains measure types supported by aggregate awareness (see: Measure Type Factors), *or* the Explore query has an aggregate table that is an exact match (see: Creating Aggregate Tables That Exactly Match Explore Queries). The Explore query’s time zone matches the time zone used by the aggregate table (see: Time Zone Factors). The Explore query’s filters reference fields that are available as dimensions in the aggregate table, *or* each of the Explore query’s filters matches a filter in the aggregate table (see: Filter Factors).The SQL tab should include a comment explaining why an aggregate table wasn't used. Use the tro

2760

1 year ago

sarah.tayeriLooker Staff

published in Technical Tips & Tricks

Github IPs to allowlistKnowledge Drop

Last tested: Jan 5, 2021 To integrate git pull requests with any LookML projects, you will need to add to the allowlist the range of IP addresses from which your Git provider makes outbound requests.For github we'll use the IPs listed under "hooks" here: https://api.github.com/metaIn the allowlist settings, we should use "both" for the type setting (both UI and API). This content is subject to limited support.

1320

1 year ago

scott.siegelLooker Staff

published in Technical Tips & Tricks

Mixed Content Error TroubleshootingKnowledge Drop

Last tested: Aug 31, 2018 Scenario:If your instance is self-hosted and is embedding Looker in an iFrame, and is receiving the following error:Mixed Content: The page at '' was loaded over HTTPS, but requested an insecure resource ''. This request has been blocked; the content must be served over HTTPS. Possible Causes:You have a load balancer (ex. Nginx) that is managing your SSL certificatesTroubleshooting:Remove the -- no-ssl startup option https://docs.looker.com/setup-and-management/on-prem-install/looker-startup-options Replace the no-ssl startup option with--ssl-provided-externally-by=<s> Replace the <s> with the host and port of their external SSL provider Make sure you have the = sign! Check your nginx settings against what we recommend here: https://docs.looker.com/setup-and-management/on-prem-install/sample-nginx-config. In particular, we have had customers set configured to set request headers that tell Looker what happened when forwarding the request as X-For

790

1 year ago

srinija.godavarthiLooker Staff

published in Technical Tips & Tricks

"There are new commits in at least one of your remote dependencies."Knowledge Drop

Last tested: Jun 3, 2020 if the project manifest has remote dependencies you would need to click update dependencies first. This creates a file that makes sure that the dependencies are up to date.If the remote dependency is updated you will get a new prompt to update your dependencies. This content is subject to limited support.

240

1 year ago

swhiteLooker Staff

published in Technical Tips & Tricks

INFOBRIGHT: Derived Tables in InfobrightKnowledge Drop

Last tested: Dec 5, 2019 Looker doesn't support PDTs in Infobright.If you want to have DTs (ephemeral, not persistent), you will need to use a workaround where the SQL query is written in the sql_table_name parameter:view: derived_table {sql_table_name: ( SELECT * FROM table ) ;;dimension: id {...}...} This content is subject to limited support.

1 year ago

srinija.godavarthiLooker Staff

published in Technical Tips & Tricks

Startup script scheduler flagsKnowledge Drop

Last tested: Jun 18, 2019 Changing --scheduler-threads=<i> is a good idea if you would like to limit the amount of schedules that are processed at one time, and the rest would be queued up. So if you just want to decrease the amount that would execute at one time down from 3 (default threads) that would be a good way to change that.As of version 6.18, the unlimited pool is set separately from the above via the --unlimited-scheduler-threads=<i> flag. In previous versions --unlimited-scheduler-threads was ignored and the pool was set to the same number of threads as --scheduler-threadsscheduler-query-limit=<i> flag (default: 10) : If a dashboard that has 20 tiles on it is scheduled, 10 would be queued.*Note that this limit is PER node, so in the first flags case, if there are 10 nodes, then there would be 30 threads available, etc. This content is subject to limited support.

450

1 year ago

srinija.godavarthiLooker Staff

published in Technical Tips & Tricks

Multiple Embed SessionsKnowledge Drop

Last tested: May 8, 2020 Q: If an embed user uses multiple sso_embed URLs, will we create multiple sessions for them? A: No, only one session at a time. If force_logout_login=true it will start a new session, otherwise it will stay on the existing session.Q: Is it possible to have multiple sessions with different users across multiple tabs in a browser? A: No, because of cookies. This content is subject to limited support.

630

1 year ago

srinija.godavarthiLooker Staff

published in Technical Tips & Tricks

Hiding folders in the IDEKnowledge Drop

Last tested: Mar 17, 2020 There's currently no way to hide folders in the IDE, but a workaround is to "tag" the current version on github, and then delete the files, then if you want to see the old files you could navigate to the tag.https://stackoverflow.com/questions/18216991/create-a-tag-in-a-github-repositoryOnce you have a tag, called for example "last-rev-with-old-lookml" then you can look at the files a https://github.com/ACCOUNT/REPO/tree/last-rev-with-old-lookml so you could bookmark that and keep it as a reference for example. This content is subject to limited support.

310

1 year ago

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

Example Ruby API script to update a LookKnowledge Drop

GIT - Find all commits for a day (or date range)Knowledge Drop

Using assign | sql_quote filter value in an if statement in a derived tableKnowledge Drop

Why is there 2 / in the SSO embed url? ( like /login/embed//embed OR company.looker.com//login/embed)Knowledge Drop

"Model already configured"Knowledge Drop

How to hide explores included from model filesKnowledge Drop

value_format not coming through in exploreKnowledge Drop

How are query limits affected by clusteringKnowledge Drop

How Do I Show Only the Totals Row?Knowledge Drop

How do I escape a string starting with "-" in a Filter Expression?Knowledge Drop

Render error: RendererAuthenticationHTTPException or LOGIN_HTTP_ERRORKnowledge Drop

PDTs not Dropping from Scratch SchemaKnowledge Drop

What does RendererNoCliprectFoundForElementError mean?Knowledge Drop

Render error: Chromium was not able to render the page to PDF in 300000ms.Knowledge Drop

What timezone do alerts send in?Knowledge Drop

Why does my Percent of Total (percent_of_total) measure show up as null?Knowledge Drop

How do type: yesno fields work?Knowledge Drop

Why is my aggregate table not being used?Knowledge Drop

Github IPs to allowlistKnowledge Drop

Mixed Content Error TroubleshootingKnowledge Drop

"There are new commits in at least one of your remote dependencies."Knowledge Drop

INFOBRIGHT: Derived Tables in InfobrightKnowledge Drop

Startup script scheduler flagsKnowledge Drop

Multiple Embed SessionsKnowledge Drop

Hiding folders in the IDEKnowledge Drop

Badges

Sign up

Social Login

Login to the community

Social Login

Scanning file for viruses.

This file cannot be downloaded