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

Newest first

Recently active Most replies Most views

Article How do I add Custom Visualizations to Looker?

Last tested: Aug 13, 2020 More Reading:Visualization LookML object syntax: https://app.getguru.com/card/cpM55dxi/Custom-Visualizations-in-LookML\Network Requirements for On-Prem Instances Connecting to Marketplace: https://app.getguru.com/card/i8gzyyeT/Network-Requirements-for-OnPrem-Instances-Con...

Technical Tips & Tricks

Article Network Requirements for Instances Connecting to Marketplace

Last tested: Apr 22, 2020 These are our network requirements for instances connecting to our Marketplace backend:• HTTPS port 443 should be open or able to access https://marketplace-api.looker.com• SSH port 22 should be open or able to access https://github.com• GIT port 9418 should be open or able...

Technical Tips & Tricks

Article Git branches showing up for other developers after being deleted

Last tested: Sep 18, 2018 Each developer can have their own local version of any branch if they checkout another branch. If developer X deletes branch A, and developer Y had checked it out, the other developer will still have branch A. If they then push it to production, it will be resurfaced in rem...

Technical Tips & Tricks

Article Can you show / hide filters on embedded content?

Last tested: Jun 8, 2020 Yes you can! The way to do this is different depending on the type of content.For User defined dashboards, you can use the embed settings option in the cog menu. (click the cog menu on the dashboard > Edit Embed Settings.) For LookML dashboards, you can use the show_filte...

Technical Tips & Tricks

Article Why isn't embed working in Safari? Are there browser settings we need to set for SSO embed content?

Last tested: Jan 21, 2021 Some browsers have their nuances.Safari and firefoxSafari disables third party cookies by default if the user has not previously visited the host of the iframe, so users will have to enable third party cookies in their privacy settings by disabling the setting Prevent Cross...

Technical Tips & Tricks

Article How can I examine the query response objects?

Last tested: Apr 29, 2020 If you're curious about:what's inside the query response object which field type a table calculation resolves to how the data object is structuredyou might be interested in the Viz Inspector: https://github.com/noahamac/viz-inspectorThis visualization outputs to the scre...

Technical Tips & Tricks

Article What liquid variables can be used with reference line labels?

Last tested: Mar 1, 2018 You can combine words with the actual value of a reference line to create a label. For example:Average: {{mean}}will show something like Average: 123.0The following calculations can be put in the {{ }} syntax:median mean max min deviation (represents the std deviation) varia...

Technical Tips & Tricks

Article How can I check datagroup trigger values?

Last tested: Jul 15, 2020 The Admin > Datagroups page displays the current datagroup value.If your Looker instance is self-hosted and you would like to check previous values, you can do so in the logs by running:grep 'UPDATE' looker.log | grep 'datagroupname' | grep 'trigger_value' Replace datagr...

Technical Tips & Tricks

Article BIGQUERY (Error): Cannot Connect (Connection Refused) on BigQuery

Last tested: Dec 21, 2020 Note: This card only applies to BQ connections going through a proxy. For connection refused in all other scenarios, see this postThis article explains that this error can be caused by a proxy. If you host your own instance, then we'll want to make sure that Looker is allow...

Technical Tips & Tricks

Article Does a clustered environment help with scheduling?

Last tested: Jan 21, 2019Requiring lots of concurrent schedules is a great use case for a clustered environment. Each node will have its one schedule limit. So, for example, So if there is the default 3 schedule threads in a 3 node cluster, there can be 9 concurrent schedule threads. This content is...

Technical Tips & Tricks

Article What happens to SAML shadow groups when disabling SAML?

Last tested: Jul 23, 2019 Nothing immediately, but as of Looker 6.14, a shadow group will go away 31 days after the last login of a user in that group.After Looker 6.14:Each group is intended to persist as long as some user is a member of the group. The change made is intended to deal with two looph...

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 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 Can a dashboard filter be applied to multiple fields?

Last tested: Jan 6, 2021 Yes- if you use the sql: parameter on a filter field like this: filter: datefil {type: datesql: {% condition %} ${created_date} {% endcondition %} and {% condition %} ${users.created_date} {% endcondition %};;}Note that since we are referencing another view, every explore u...

Technical Tips & Tricks

Article Is data downloaded from a dashboard in the same timezone as the dashboard setting?

Last tested: Aug 16, 2019 If you download from the dashboard menu, the data will be in the same timezone as the dashboard setting.If you download from an individual tile of the dashboard, the data will be in the timezone of the saved query tile. This content is subject to limited support. ...

Technical Tips & Tricks

Article What permission is required to create a project?

Last tested: Apr 12, 2018The manage_models permission is required to create a project. This permission is not in the Developer permission set for the Developer role. This content is subject to limited support.

Technical Tips & Tricks

Article What format do state names need to be in for the map_layer_name: us_states to work

Last tested: Mar 7, 2019 According to our documentation, "us_states - Accepts full state names and two-letter state abbreviations."In testing, the state name must be in Capitalized format like "Florida". All caps like "FLORIDA" or all lower case like "florida" will not be mapped.A user who had the n...

Technical Tips & Tricks

Article Do conditional format fields need to be numeric?

Last tested: Apr 5, 2019 Yes! For table visualization conditional formatting, the fields must be numeric.If you have strings or another data type, consider using HTML in your LookML as in this Community article, or go +1 this Feature Request. This content is subject to limited support. ...

Technical Tips & Tricks

Article Why are there duplicate groups with a 'shadowing saml config group xx' extension after the group name?

Last tested: Feb 1, 2019The SAML group is appended with the 'shadowing saml config group xx' , which will show up in the Group name in the Looker Admin Groups. When a SAML config is updated, the groups are re-mapped. Each update will increment the XX number. As long as there are members in the prior...

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 Can a sql trigger value return more than 1 row, and 1 column?

Last tested: Jan 16, 2019 According to docs, the sql_trigger_value will only consider the first row and column in the SQL you write. It is recommended to have your trigger value return only 1 value, to prevent confusion and protect non-streaming SQL dialects from loading large result sets into memor...

Technical Tips & Tricks

Article PDT rebuild error: `SQL Error in CREATE TABLE as SELECT: This connection has been closed`

Last tested: Nov 5, 2019 This is likely a timeout error.If the PDT is persisted with the persist_for parameter then this PDT can only be built by querying it via an explore/look/dashboard and the build is subject to Looker's 60 minute proxy timeout.If you have determined that this PDT is timing out...

Technical Tips & Tricks

Article "Variable not found" when dynamically querying derived tables using parameters

Last tested: Nov 26, 2020 Are you using the method outlined in Dynamically Query Tables Using Parameters with derived tables and hitting a pesky "Variable not found" error message in the LookML Validator?While derived tables in the format ${derived_table_or_view_name.SQL_TABLE_NAME} don't need to be...

Technical Tips & Tricks

Article If a user within a group email address unsubscribes from a schedule, will the affect other recipients in this email group?

Last tested: Dec 7, 2020 Yes, this will unsubscribe all recipients in the group email from the schedule. This is mentioned in Docs, and there is a Community post on handling/monitoring unsubscriptions. This content is subject to limited support.

Technical Tips & Tricks

Article Does Looker support UNION in NDTs?

Last tested: Dec 27, 2018Looker does not currently support UNIONs in NDTs. 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