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 developmentLookML1562 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
Technical Tips & Tricks

Technical Tips & Tricks

Previously internal product knowledge now available for you to explore!

1,659 Topics
169 Replies

When you subscribe we will email you when there is a new topic in this category

1659 Topics

Recently active

Most replies Most views Newest first

Article Selected articles about Looker API & SDK use cases

We have gathered a list of community and help center articles covering some major API & SDK use cases. We hope this makes it easier for you to browse and navigate. The code examples are for demo purposes only. For any further questions on those use cases please post a comment under those article...

Article Selected articles about LookML

Selected articles about LookML We have gathered some selected community and help center articles and organised them in different topics. Hope this makes it easier for you to search and navigate. General Why do we recommend many_to_one joins over one_to_many joins?How to add a new row of data with Lo...

Article Selected articles about SQL use cases in Looker

Selected articles about SQL use cases in Looker We have gathered a list of community and help center articles organised in different topics. Hope this makes it easier for you to search and navigate. TroubleshootingCommon SQL error troubleshooting tips in Looker Calendar tableHow to combine a retail...

Article Breaking News: Knowledge Drops are LIVE!

Democratizing information has always been a core tenet of Looker’s values. It’s how we all become better thinkers and better doers. This ethos isn’t just a philosophy or a catchy marketing phrase; it’s a practice - and it’s one we’ve always taken to heart. So in true Looker-fashion, we’re excited to...

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...

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...

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...

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...

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...

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...

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...

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...

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. ...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

1
2
3
4
...
67

Page 1 / 67

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