Looker Connect Training
Help Center
Documentation
Community
Cloud Certifications

Looker Connect Training

Cloud Certifications

- - Knowledge base
Product Announcements
Events
Groups

Community
The Kitchen Table

The Kitchen Table

Explore the product knowledge we've built up together

2115 Topics

Most views

Recently active Most replies Newest first

shivanisankarNew Member

published in Technical Tips & Tricks

Why are my Quick Start Pivots not Showing Up?Knowledge Drop

Last tested: Feb 9, 2021 Even if you have a value in the pivot subparameter of your query parameter, queries with pivots need to have the pivot defined in both pivots AND in dimensions.Example:query: orders_by_brand_name { dimensions: [products.brand, products.category] measures: [products.count, order_items.order_count] pivots: [products.category] description: "Orders by brand name" limit: 500} You can see that products.category is included in both the dimensions and pivots subparameter. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Are merge results cached?Knowledge Drop

Last Tested: Dec 6, 2018 As of 5.12 there is an option to Clear Cache and Refresh on the merged results page. Before 5.12, you had to click "Explore From Here" for each query and "Clear Cache & Refresh" each explore individually. Re-run the merge results and your data will reflect the refresh. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Can Looker support large custom map layers?Knowledge Drop

Last tested: Aug 23, 2019 You bet! Even though you probably don't want to load a topoJSON larger than 5mb directly into the IDE (or the browser), there's a straightforward way to utilize large map layers in Looker, only downloading the bits you need at any given time to keep things manageable.Procedure is outlined here: This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

How to chat with data

This content, written by Dillon Morrison, was initially posted in Looker Blog on Dec 1, 2016. The content is subject to limited support.Big news, the - our chatbot - is live in Slack’s . We launched the Lookerbot in April and have watched it spread like wildfire among our customers. Since we last , we now have hundreds of organizations using the tool daily. For companies like Buffer, Jet.com, and Docker, Lookerbot lets them slack their data making it easier for everyone in the company to be data driven. The Lookerbot’s inclusion in Slack’s App Directory means more people can now find Lookerbot and see what it can do. The success of Lookerbot proves how important accessing data wherever you need it - in a slack conversation, on a warehouse floor, or powering an application - is becoming. To make informed decisions based on data, it can’t just be buried deep in some dashboard. This is what we are most excited about here at Looker. Shifting the paradigm away from what is traditionally

mandy.chanLooker Staff

published in Technical Tips & Tricks

Orphan Groups in LDAP settingsKnowledge Drop

Last tested: Jul 15, 2020 If you have LDAP set up and then delete your old LDAP/AD groups in your IdP, you will still see the old group listed in the Groups page. For example, Viewing Testing (Orphan 123456789) GroupIt should be handled in the same way as SAML shadow groups, where the shadow groups will still appear until users from the old group re-logs in and gets mapped to the new group, or 30 days have passed. This content is subject to limited support.

mandy.chanLooker Staff

published in Technical Tips & Tricks

What is the difference between Most Recent Query Run At Date vs Most Recent Query DateKnowledge Drop

Last tested: Nov 17, 2020 Most Recent Query Run At Date is the most recent query run per query ID. Essentially, it finds the most recent date that the query was run.Most Recent Query Date takes the most recent date of the History ID.So for instance, if the Most Recent Query Run at Date says 2020-11-06 but the Most Recent Query Date says 2020-10-02, this suggests that the History ID of that query was created on 2020-10-02, but the query was ran most recently on 2020-11-06.Reminder: The query ID is a unique combination of SQL text, connection and other fields. It's created the first time a SQL query is ran on a connection. The query ID can be linked to many History IDs This content is subject to limited support.

karisa.eberlyModerator

published in Common Account Questions

How are bugs prioritized within the Looker Engineering Team?Knowledge Drop

Our Looker Engineering Team uses a carefully designed prioritization system to assess issues as they arise. This system is based on several factors such as the impact of the issue and how widespread it is. When you report a bug, you can ask for follow up about its priority to better understand its timeline towards resolution. If you have a question about a bug’s status, please reach out to your Account Manager.

Department of Customer LoveLooker Staff

published in Blog Archives

Better together - 7 ways Looker and AWS make data teams successful

This content, written by Joel McKelvey, was initially posted in Looker Blog on Dec 2, 2019. The content is subject to limited support.Visit the Looker team at AWS re:Invent in Las Vegas, December 2-8th at booth #1405 and ask us about our integrations with AWS. As an AWS Advanced Technology Partner, we are excited to talk about our continued integration with AWS — something many of our customers have come to value and rely upon. To kick off what will be another exciting re:Invent conference in Las Vegas this week, we put together a “top 7” list of facts to highlight all the ways Looker and AWS are better together. Fact one Over 50% of all Looker customers are using Looker with Amazon , , or another AWS database. Using an AWS database has a number of benefits, but one of the cooler things you can access is geospatial data via Athena (check out our to learn how that works). Fact two More than 90% of . And for Looker customers who choose to host their own instances, many of them use AWS a

samLooker Staff

published in Technical Tips & Tricks

Why can't I see my Slack channel in the Looker sending modal?Knowledge Drop

Last tested: April 2021 When you don't see the desired channel in the Looker sending modal:a) If you're using the Lookerbot, you have to invite it to your channel first (On your channel, "Add people to #channel_name", find the Lookerbot the same way you find individual users, and select), orb) if you're using a legacy token, you should see the Looker app under "Apps" on Slack and will have to invite the app to your channel ("Add Apps" on your channel and find the Looker app),then you should see that channel in the modal upon refresh.When Lookerbot isn't showing up in your Slack channel:Step a) from above.Further reading: Using Lookerbot for Slack This content is subject to limited support.

jamesnestlerLooker Staff

published in Technical Tips & Tricks

Why can't I download `content` as `format`?Knowledge Drop

Last tested: Oct 11, 2019 All content in Looker has slightly different allowed download formats. All downloads are contingent on having appropriate permissions. These are distinct from 'sending' and 'scheduling' content.Dashboards:PDF CSVLooks:Text CSV / Excel JSON HTML Markdown PNGExplores:Text CSV / Excel JSON HTML Markdown PNGMerged Queries:Can only be downloaded after saving to a dashboard. Must download the entire dashboard This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Building on the Platform: Custom Applications for Sales & Marketing

This content, written by Dillon Morrison, was initially posted in Looker Blog on Apr 9, 2019. The content is subject to limited support.Today’s successful organizations are moving beyond BI tools to create and deliver custom data experiences. They’re , , and to support rapid growth. As these experiences have become a crucial factor of success, so has the expectation that users can get the data they need to make critical business decisions, regardless of technical skill or specialty. Here at Looker, we're on a mission to empower people through the smarter use of data. To do this, we continue to build, test, and evolve to ensure we're supporting companies throughout their data journeys. Building on our platform, we’re breaking the mold of traditional BI tools to deliver operational insights and provide experiences that are unique to the needs of users. A relatively new way we’re doing this is through pre-built, use case specific applications. Why We Built Applications We love working wi

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Can I automatically start Looker on system reboot?Knowledge Drop

Last tested: Jan 21, 2019 Yes!If you use a System5 style startup system the script is looker_init and it is here... https://github.com/looker/customer-scripts/tree/master/startup_scriptsIf you use systemd startups then here is the answer https://github.com/looker/customer-scripts/tree/master/startup_scripts/systemdAnd if cron is running on the system one could always use the crontab file to restart looker https://www.cyberciti.biz/faq/linux-execute-cron-job-after-system-reboot/This post applies if you host your own instance - Looker-hosted instances automatically start on reboot. This content is subject to limited support.

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.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

RendererNoDataError, while rendering pdf/png.Knowledge Drop

Last tested: Apr 19, 2020 2020-04-08 10:05:54.770 +0000 [INFO|0097a|event:render] :: Render job data not found by user 12020-04-08 10:05:54.772 +0000 [ERROR|0097a|] :: Looker::Render::RendererNoDataError : Render job 9d16e8a23065a16edc63f09c21a04a51 data not found uri:classloader:/helltool-component-build/lib/helltool/render/manager.class:491:in `get_render_results' uri:classloader:/helltool-component-build/lib/helltool/controllers/render_controller.class:163:in `block in GET /render/result/:slug/:filename'2020-04-08 10:05:55.021 +0000 [WARN|0097a|http] :: (0.306463s) Request complete: 500 /render/result/9d16e8a23065a16edc63f09c21a04a51/Internal%20Price%20Checker%202020-04-08T0304.pdf One of the possible causes that might trigger this exception that I came across was the fact that time was out of sync on one of the new nodes that were added to the cluster. We essentially treat nodes that have a bad heartbeat as impostors. It'll still pick up tasks but it won't be allowed to talk to th

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Why are there dashboard links in my drill menu when I haven't defined any?Knowledge Drop

Last tested: Jan 22, 2019 Double check to see if you have the Labs feature Dashboards in Drill Menus enabled. It's an awesome feature that can tell if a dimension can be filled in as a filter in a dashboard and then suggests the drill based on that! This content is subject to limited support.

Nicholas_AlexanderModerator

published in Common Account Questions

Can I enable SAML on my instance?

Looking to create some added/different security to your Looker instance via SAML? Looker is well equipped for that, and multiple customers have enabled this for peace of mind, to fit their use case, or various other reasons! Have a look at this intuitive doc, on how to get started, the setup needed, and how to work with us to get this enabled! Question on this process? Feel free to comment below

jamesnestlerLooker Staff

published in Technical Tips & Tricks

Text Tile: How to create a footer / unlimited width textKnowledge Drop

Last tested: Feb 28, 2020 <div class="vis"><div class="vis-single-value"><font color="#5A2FC2" size="3"><center>If we keep typing will the text wrap at 500px or will it go across the entire tile? This type of example may take a test on your instance to confirm</center></font></div></div> This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Why would a dashboard filter change to matches(advanced)?Knowledge Drop

Last tested: Sep 28, 2020 If this is happening for some users only:We have seen this happen when a user doesn't have the model specified in a dashboard's field filter in their model set, or also when the model for that dashboard field filter hasn't been configured. In this case, the dropdown for the filter options will be missing—it won't actually say "matches (advanced)," although the filter value uses matches (advanced) syntax. For example, here is what the filter edit modal might look like for a user who doesn't have access to the field the "Date" filter is based on:Note that all there are blank entries for the model, explore, and field. Here is what it might look like on the dashboard:Notice that the filter options dropdown is missing.This happens because the default value of a filter is always stored as advanced syntax, which is then translated to the appropriate filter option based on the field type. But the type is part of the field, so the translation step won't happen if the u

Department of Customer LoveLooker Staff

published in Blog Archives

Putting the hack in hackathon: the winners of Looker_Hack : London

This content, written by Scott Sirowy & John Kaster, was initially posted in Looker Blog on Jul 18, 2019. The content is subject to limited support.Note: This is one part of a two-part series on Looker_Hack : London, hosted in May 2019. This post is focused on highlighting the winning projects and the rockstar developers that built them. The second post is about the tools we used to make the Hackathon such a success, which you can find on our . Following the success of our first last October at , we wanted a way to show some #LoveLookerLove to the folks across the Atlantic. To do this, we decided to fly out to the UK, meet more of our innovative Looker customers, and host our first Hackathon event in London. Why a hackathon? Hackathons are a great way to quickly build projects and solutions that can help teams meet specific business goals. For Looker specifically, hackathons provide an avenue for our engineers, designers, and product managers to meet developers and understand how

Department of Customer LoveLooker Staff

published in Blog Archives

Announcing the Looker Block for Audience Analytics by Permutive

This content, written by India Ferard, was initially posted in Looker Blog on Apr 4, 2017. The content is subject to limited support.Audience Analytics by Permutive Block - instantly compare your audiences and analyse behaviours Permutive is the world’s first realtime Data Management Platform, trusted by some of the world’s largest publishers to target their audiences on desktop, mobile and FIA. Permutive enables you to collect, enrich and segment audience data across devices for real-time analysis and targeting. The lets you instantly analyse and compare these audience segments, powered by up-to-date real-time data. We are excited to announce our new Audience Analytics Looker Block, which lets publishers instantly compare, see the overlap and total size of their audience segments. It’s an incredibly flexible Block which can be used for all your audiences to compare any data - how you use it is up to you! Instant, Ccustomisable, up-to-date audience development All publishers need to u

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

How can I fix broken tiles on a lookless dashboard without the content validator?Knowledge Drop

Last tested: Jan 21, 2019 1) Go to the broken dashboard, select 'Get Dashboard LookML' from the gear icon2)) Grab the LookML.3) Paste the LookML into a new dashboard in the model4) Update the LookML to correct any renamed objects (dimensions, measures, models, filters, etc.)5) Navigate to the LookML Dashboards space and open the dashboard6) Use 'import to space' to re-create a new UDD with the fixes applied. This content is subject to limited support.

Aleksandrs_VedernikoLooker Staff

published in Technical Tips & Tricks

How to test if Fileshare (NFS/EFS/GFS) is correctly mounted and accessible from all nodes in the clusterKnowledge Drop

Last tested: Apr 3, 2020 run ps -ef|grep java|grep looker from CL on each node. Verify that --shared-storage-dir path is the same on each node. Test the ability for nodes to write and other nodes to read from the shared storage using path found in step 1. You can do this by creating a file from node1 with touch /mount_path/file.txt For example, if the path to the shared storage directory from step 1 is /lookershare/modelshare , then command will be touch /lookershare/modelshare/file.txt Once you have created a file from node1, try to see in node2 & all other nodes in the cluster can read it with ls -ltr /mount_path/file.txt Loop through all nodes in the cluster This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

How do I update LookML via the API?Knowledge Drop

Last tested: June 2021 This is currently not possible. The lookml-model endpoint does have "explores" in the body, but it's read-only.As a workaround, we recommend using the API of your Git provider. For example, these are Github's API Docs. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

How does query killing work via the API?Knowledge Drop

Last tested: Oct 7, 2019 Here are some facts about queries are killed via the API:Only admin API users can kill queries via the API You can kill a query with the kill_query() endpoint, which requires us to know the query_task_id (not the query_id) Only async query tasks can be killed. To be able to kill a query, it has to have been created using create_query_task() Queries run via synchronous run_query() or run_inline_query() cannot be killed Closing an API connection does not kill the query like it does in the front-end This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Model Names in the Same InstanceKnowledge Drop

Last tested: Aug 12, 2020 In the same instance, you can't have two models with the same name, even if they are in different projects.But in the case of imported projects, they can have the same name.A user was wondering if you can import the same remote project twice in difference projects on the same instance. The answer is yes! when you import a project, the imported lookml files don't actually live on this project - hence it is okay if two imported projects have the same model names. This content is subject to limited support.

1
...
50
51
52
53
54
55
56
...
85

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

Powered by inSided

Terms of Service

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

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

© 2022 Google. All rights reserved.
Privacy | Terms | Community Guidelines