Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

Community
WelcomeGetting started113 News & announcements112 Who's hiring414 Release notes (archive)63 Lesson Comments12 Challenge10
Looker developmentLookML1561 SQL284
Exploring & curating dataExplores490 Dashboards & looks1355
Application developmentEmbedding Looker / Powered by Looker132 Open source projects48 Looker API331
AdministrationUser access & management52 General Looker administration414
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

Recently active

Most replies Most views Newest first

Article Can an embed user move/copy a dashboard?

Last tested: Dec 14, 2020 An embed user cannot "move" or "copy" a dashboard into another space/folder, since those functions are only available on the folder page in the UI and are not available in the "four squares" embed folder dropdown menu.Therefore, the Manage Access / Edit permission on a fold...

Technical Tips & Tricks

Article Conditional / Dynamic Value Format value_format

Last tested: Jan 21, 2019 We can't do dynamic formatting using the value_format parameter, but we can using the html parameter! Here is an example that looks at a separate "currency" dimension and puts the proper symbol in front of our measure amount. html:{% if currency._value == 'EUR' %}€{{rendere...

Technical Tips & Tricks

Article How does the renderer work?

Last tested: Feb 11, 2020 When a render job starts to generate a PNG or PDF of a look, explore or dashboard, it goes through the following steps:The render job enters the caching queue, waiting until a caching spot is open. By default, there are 2 render threads but this can be changed with a startu...

Technical Tips & Tricks

Article The life of a schedule job

Last tested: Jan 24, 2020 When people talk about schedules, they are generally referring to one of two things: schedule plans and schedule jobs.A schedule plan refers to the configuration of a report: it's format, destination, and the conditions -- time interval or datagroup -- that determine when i...

Technical Tips & Tricks

Article How are files sent to SFTP and S3 buckets named?

Last tested: May 31, 2019 All file names look like scheduleName_timestamp_hash, where hash is a random 6-character identifier and the timestamp follows the pattern YYYY-MM-DDTHHMM (e.g. 2019-05-31T0933).There is a feature request ticket to be able to customize the file name of files sent via schedul...

Technical Tips & Tricks

Article How does "Clear Cache and Refresh" work, what if I close the browser?

Last tested: Jan 21, 2019 Looker only replaces the existing cache key when the query is complete; it does *not* begin processing a “Clear Cache and Refresh” request by actually clearing the cache, just passes a flag to not use what’s already in the cache. When the query completes, the result is plac...

Technical Tips & Tricks

Article How to highlight and count matching patterns in a String or Array using Liquid HTML (Pseudo-Regex)

Last tested: Jun 22, 2020 The ProblemHave you ever wanted to highlight a portion of text in a phrase based on some defined search criteria? Well, one customer needed the same where they needed to highlight a pattern in a list of Epoch times.In a nut-shell, Can I highlight a pattern in a list and fin...

Technical Tips & Tricks

Article Rank across pivots with table calculations

Last tested: Sep 29, 2019 We are able to create Rank across pivots with a number of table calculations.Assuming that we have two dimensions, brand and status, and one measure, let's call it count. We created an explore, in which we have the dimension brand, we pivot on status and have the measure co...

Technical Tips & Tricks

Article Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials

Last tested: Jan 20, 2021If you're seeing this error, check to see if the table that is being queried is a google sheet that's stored in Drive.If that's the case, make sure that the Service Account for BQ that Looker is using has access to the Drive. This content is subject to limited support. ...

Technical Tips & Tricks

Article Load Testing Looker

Last tested: Mar 27, 2019 So you want to load test… why? Common reasons include:Determine cluster sizing (bulk testing against different cluster/node sizes and configurations, behavioral tests) Determine optimal network architecture Determine which database to use, how to structure queries, and sizi...

Technical Tips & Tricks

Article Window Functions in Looker

Last tested: April 2021 How do I use window functions in Looker?Window functions are a very powerful tool in SQL because they perform post-aggregation calculations. There are two main ways to implement window functions in Looker:1: Use Table CalculationsCalculating after aggregations is exactly what...

Technical Tips & Tricks

Article Why are my fields null in the explore but they show up in SQL Runner?

Last tested: May 13, 2020 ExplanationThe explore does some front-end operations that SQL Runner doesn't. For example, it tries to use the type defined in LookML to properly show the field values.SolutionThis is almost always because of a type mismatch. Often there is a string field on the database t...

Technical Tips & Tricks

Article How can I merge user attribute values from multiple groups?

Last tested: March 2021 Background: Groups are given user attribute values. For example, group_USA might be given the value for the “country” user attribute as “USA”. With an access filter, users in that group will get WHERE country = “USA” for their queries.The issue: If a user belongs to two group...

Technical Tips & Tricks

Article How do I render a local image in Looker?

Last tested: March 2021 Looker expects a public URL for your image. So make sure that wherever you store it is publicly accessible. Then, you can call it in LookML like so:view: view_name { dimension: field_name { html: <img src=”http://www.acme.com/product_images/my_image.jpg” /> ;; }}This he...

Technical Tips & Tricks

Article How long do async query results last for?

Last tested: Feb 12, 2018 If Instant Dashboards are enabled, then async query results are kept for 30 days.Otherwise, the default time-to-live (TTL) for an async query result set is 5 minutes. This can be changed by setting the --async-results-cache-time startup flag to the number of seconds that re...

Technical Tips & Tricks

Article How do I hide one of my pivot columns?

Last tested: Mar 16, 2020 If you find yourself here, +1 this feature request: https://feedback.us.pendo.io/app/#/case/17612We're here, and we want to hide the "other" column:We can accomplish this with pivot_index or pivot_where.You'll need to create a table calculation for each column you want to s...

Technical Tips & Tricks

Article Does the embedded domain allowlist admin panel option support wildcards?

Last tested: Mar 30, 2021 Short answer: Looker may allow wildcards in the embed domain list, but browsers generally do not allow wildcards in domain names for browser security contexts.Longer answer: The Looker allowlist will allow wildcards, the browser will not. However, in the context of any give...

Technical Tips & Tricks

User does not have bigquery.jobs.create permission in project error

If we are hitting the error “BigQuery connection is hitting this error User does not have bigquery.jobs.create permission in project `project_name`” for a connection where we have granted the user the BigQuery Data Editor and BigQuery Job User role already then we may need to check our value for th...

Technical Tips & Tricks

Article Amazon Redshift scalar user-defined functions: a how-to

This content, written by Scott Hoover, was initially posted in Looker Blog on Sep 11, 2015. This content is subject to limited supportOverview Amazon Web Services (AWS) recently announced that Redshift, their managed MPP database offering, will support scalar user-defined functions (hereinafter UDFs...

Blog Archives

Article 3 key considerations for embedded analytics

This content, written by Shohei Narron, was initially posted in Looker Blog on May 24, 2016. This content is subject to limited supportYou’ve built a great product that resonates with the market. Your customers are enthusiastic, and word of mouth is overwhelmingly positive. The in-house picture is c...

Blog Archives

Article 2018 marks the debut of Looker in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms

This content, written by Joel McKelvey, was initially posted in Looker Blog on Feb 27, 2018. This content is subject to limited supportAt Looker, we are honored to debut in the 2018 Gartner Magic Quadrant for Analytics and Business Intelligence Platforms. Gartner is a leading IT research and adviso...

Blog Archives

Article Why are my series colors and other visualization settings randomly changing?

Last tested: May 6, 2020 Is it a pivoted query? If so, it could be a case of “When the clock strikes midnight the visualizations come alive with a mind of their own.”The series editor is based around the pivot value of the series, so any visualization settings you have set on the pivoted series (col...

Technical Tips & Tricks

Article Max or Min Date Measure Showing Nulls

Last Tested: March 21, 2021 Why is this happening?Looker's min and max types only allows for numerical values. Everything else will show a null.How do I fix it?Make a measure of type "date" and apply the "max" aggregate in the SQL. This Help Center article article provides the following example on...

Technical Tips & Tricks

Article The PDT Regenerator Process

Last Tested: Nov 4, 2020 Purpose:The regenerator's purpose is to manage the building of PDTs on the scratch schema. Its major tasks are to check datagroup triggers, build new PDTs that have been pushed to production and rebuild existing production PDTs whose trigger values have changed.Number of Reg...

Technical Tips & Tricks

Article CSV downloads with foreign currency renders as Â£ in Excel ( Euros, British Pounds, etc.)

Last tested: Aug 17, 2019This is a bug in how excel handles CSV files. Try downloading the content as XSLX instead! This content is subject to limited support.

Technical Tips & Tricks

1
2
3
4
...
68

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