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

Department of Customer LoveLooker Staff

published in Blog Archives

Accessible data science with BigQuery Machine Learning + Looker

This content, written by Ken Cunanan, was initially posted in Looker Blog on Jul 25, 2018. The content is subject to limited support.At Google Cloud Next ‘18 today, Google took a step toward more accessible machine learning with the announcement of a new feature for Google BigQuery called BigQuery Machine Learning (BQML). BQML is a fully managed service that makes it easier for data scientists to build and train machine learning models in BigQuery using SQL syntax. The traditional data science workflow Most organizations have because the data science workflow requires a lot of resources, and the largest resource consumption often has little to do with the actual discipline of data science or the creation of machine models. A typical data science workflow can look like this: Generate hypothesis & define features -- define relevant attributes (features) of data that they believe can be used to predictive future behavior. Prepare training dataset -- from their hypothesis, data scie

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

What happens in Looker when you change a Git Repo name outside of Looker?Knowledge Drop

Last tested: Jul 5, 2017 If you change the name of your remote repository outside of Looker, Looker will still try to connect to the old repo name.The recommended practice is to reset your git connection to the new repo name.Some providers, like Github, claim that they will just point you to the new repo instead, but it's best not to take chances. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Today Looker is announcing our integration with BigQuery, we think it's a big deal.

This content, written by Lloyd Tabb, was initially posted in Looker Blog on Nov 5, 2015. The content is subject to limited support.BigQuery Is the Next Step in Data Warehouse Evolution Today Looker is announcing our integration with BigQuery, we think its a big deal. Analytic databases are getting faster and a lot easier to deploy. Technologies are leap-frogging each other quickly. MPP databases have opened up new ways to look at really large datasets. Products like Amazon’s AWS Redshift changed the game by deploying quickly in the cloud. Now those cloud products are becoming even more powerful through truly elastic multi-tenant architectures. This progress is a perfect match for Looker’s in-database architecture… and Looker customers are benefiting from each step forward. We think BigQuery is the next step in data warehouse evolution. A true multi-tenant clustered database, BigQuery gives you Redshift’s ease-of-setup, but adds essentially infinite scale-out. One of our customers is pu

samLooker Staff

published in Technical Tips & Tricks

When would I use the | symbol after the sql parameter in old LookML?Knowledge Drop

Last tested: Feb 20, 2018 The pipe | symbol is only used in old LookML. It tells the validator that multiple lines of code are coming. This has been replaced in New LookML with the ability to use double semicolons to end code blocks like html or SQL. # Example of | used correctly. Without the |, this would error.sql: | CASE WHEN 1=1 THEN 'grand'ELSE 'not as grand'END More examples: https://oldlookmldocs.looker.com/reference/view-params/sql-for-derived_table This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

How can an admin see what permissions an embed user has?Knowledge Drops

Last tested: Dec 2020Click on the user in Admin > Users. Under “Roles” for that user, click the embedded role. You’ll see a popup with permission sets and model sets. Another quick way to check this is via the browser’s Network console. For example: Open Network console. (For Chrome, this can be found under the three dots menu, then “More Tools > Developer Tools.) Run the page with the Embedded iframe. Filter Network responses for embed and click on that line. You're looking for the encoded URL like %2embed%2F.... Click on Headers and scroll to the Query String Parameters section. Click view parsed (It may already be defaulted). You'll then see a section like: permissions:["see_user_dashboards","see_lookml_dashboards","save_content","access_data","see_looks","schedule_external_look_emails","embed_browse_spaces","schedule_look_emails","explore","see_sql","download_without_limit"] This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

How Guru modernized their data stack to provide more value to customers

This content, written by Mitch Stewart, was initially posted in Looker Blog on Nov 4, 2020. The content is subject to limited support.At , we help organizations consolidate and manage knowledge so they can get the answers they need to quickly. Our main focus is capturing a company’s information and expertise — whether from internal messaging tools like Slack and Teams, the web, and employees' heads — and creating a single source of truth that’s easy for any employee to then access and use within their corporate business applications. Our goal is that with Guru, teams spend less time hunting down information and more time doing their jobs. Unlike traditional wikis, intranets, or knowledge bases, Guru “lives where you work.” As an overlay to any web-based application, we have a unique way of understanding what knowledge is being leveraged across specific business applications. These insights are super valuable for our customers, and as such, analytics has been a core component of our pro

samLooker Staff

published in Technical Tips & Tricks

How do I check a github repo to view recent changes to a file?Knowledge Drop

Last tested: Sep 14, 2020 Github's UI makes this pretty easy, and they have an article on it.Basically, you want to go to the repo, click on the file in question, and then select "Blame" or "History.""Blame" will show you the changes made on a line-by-line basis, whereas "History" will show you a timeline of changes. Think of it as sorting changes by "line number" vs sorting by "change date." This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Migrating from LDAP to SAML when users have different emailsKnowledge Drop

Last tested: Dec 3, 2017 Fortunately, when migrating to SAML there is an option to merge from LDAP. So this should be quite simple.There was once an unfortunate case where some users had different emails in the LDAP system and the SAML system. The best way to fix this kind of thing is to create a new credentials_email for the user via the api and set that to have the email address that you want for that user in SAML. Then, in the SAML setup, add ‘email’ to the ‘merge by’ list. (If you already had that user try to log in with SAML and it created a new user object that you didn’t want, then you have to delete that new un-needed user object.) Then, when the person logs in Looker should find that credentials_email with the matching email address for the user and merge the new SAML login info to that existing user account. This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

Dashboard Performance system activity tableKnowledge Drop

Last tested: Apr 17, 2018 Each row in this table represents an execution of the dashboard, so there should be multiple rows per dashboard.“Max Runtime” and “Min Runtime” are the max/min runtimes of the queries *within* the dashboard. This content is subject to limited support.

Peggy_BeardMember

published in Technical Tips & Tricks

How do I reference a parameter of type date in a dimension?Knowledge Drop

Last tested: May 15, 2019 Here is an example:parameter: testDate { type: date} This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

How to connect a new LookML Project to a non-empty Git repoKnowledge Drop

Last Tested: Sep 14, 2020 Create the new LookML project under Develop > Manage Projects Choose "Blank Project" and give it a name The next page will ask you to "configure git" Enter your repo URL when prompted, and enter the deploy key on the repo After configuration, Looker will prompt you to push your local branch, pull down remote changes, and finally push to production! This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Does Looker use tokens for SAML?Knowledge Drop

Last tested: Sep 18, 2019 Looker doesn't use tokens at all when authenticating with SAML.In fact, we are 100% decoupled from Okta’s notion of sessions and how they keep users logged in or not.When a user hits the ‘Authenticate’ button, we redirect the user’s browser to the SAML IdP and (implicitly) say “the user using this browser wants to log in, let me know if this is someone you trust and please give me info about them”. The IdP eventually redirects the user’s browser back to us with a signed SAML doc (or not if the IdP doesn’t trust this user). We verify the doc and then extract the info about the user that we care about (email, name, groups, etc).We then forget about that SAML doc. There is no token-like thing we retain from that doc (other than the stable user id). We then maintain our own sessions and cookies to authenticate each request from a logged-in user as they use looker. But, that is all completely decoupled from any tokens or the like from the SAML IdP. This content is

samLooker Staff

published in Technical Tips & Tricks

How do I escape commas when using liquid {{value}}?Knowledge Drop

Last tested: May 2020You can use {{ filterable_value }} as shown in the liquid docs. This content is subject to limited support.

samLooker Staff

published in Technical Tips & Tricks

Can the individual series of a pivoted dimension be split between different axes ?Knowledge Drop

Last tested: March 31, 2021 No. Each measure goes on one axis. If you have a measure pivoted, all of its pivoted values go on the same axis.If you want to specify the axis for a particular measure for each pivot, then use filtered measures instead. Create a filtered measure for each possible value (and maybe one more for any unanticipated values). Then you can specify which axis to use for each of your new measures (cite docs). This content is subject to limited support.

LanLooker Staff

published in Technical Tips & Tricks

Why can't self-hosted instances install the listing viz from the marketplace?Knowledge Drop

Last tested: Mar 29, 2020 Self-hosted instances would see this error Could not install listing. Contact support for more information.These are looker network Requirements for self-hosted instances connecting to the Marketplace backend:HTTPS port 443 should be open or able to access SSH port 22 should be open or able to access GIT port 9418 should be open or able to accessYou should be able to access the viz you are interested in after adjusting these rules. This content is subject to limited support.

molly.lippsettLooker Staff

published in Technical Tips & Tricks

Filter with Python SDKKnowledge Drop

Last tested: Jun 22, 2020 Using the Python SDK, you create the filters argument in the form of a dictionary, ex:filters={"view.field_name": value}If you want a contains filter, you can use wildcards, ex:filters: {"view.field_name" : "%containstring% "} This content is subject to limited support.

molly.lippsettLooker Staff

published in Technical Tips & Tricks

Error "The resource already exists" while using create_dashboard endpointKnowledge Drop

Last tested: Nov 9, 2020Check if you're passing a slug in to the call - each slug needs to be unique system wide, so that's a possible cause for this error. This content is subject to limited support.

VincentLooker Staff

published in Technical Tips & Tricks

Why wouldn’t a value_format_name or value_format apply to my field?Knowledge Drop

Last Tested: Dec 5, 2019 Without a type parameter, a field type defaults to string. You need to add type: number in most cases where this happens.You should change this:measure: ratio_of_cases_to_accounts {value_format_name: decimal_1sql: 1.0 * ${count} / ${accounts.count} ;;} to this:measure: ratio_of_cases_to_accounts {value_format_name: decimal_1type: numbersql: 1.0 * ${count} / ${accounts.count} ;;} This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Blog Archives

Marketing conversion rates: clarity, trust, and the feedback loop

This content, written by Jonathon Knapp, was initially posted in Looker Blog on Jun 15, 2017. The content is subject to limited support.Test, measure, iterate. The dialogue is similar with most SDR departments across tech: book more meetings, make more calls, adopt new approaches. There are so many different types of strategies, and while each approach has its value, I think we can all agree that these approaches are meaningless if you can’t track the effectiveness of the approach. At Looker, our SDR team takes a multifaceted data-driven approach to everything we do. Below, I’m sharing the most valuable metrics and ‘Looks’ (aka: dashboards, if you aren’t a Looker-user) that our team uses to achieve maximum efficiency. Clarity Our SDR team understands the value of Looker to our process. We rely the conversion data on our Looker dashboards to influence our team’s daily workflow. From monitoring the pipeline to something as simple as tracking phone calls made, we’re always exploring data

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Schedule Failed to Send (data action) {"webhook_id":null,"success":false,"refresh_query":false,"message":null,"validation_errors":null}Knowledge Drop

Last tested: Jan 17, 2019 With storage Action Hub integrations, you may run into schedules failing with the {"webhook_id":null,"success":false,"refresh_query":false,"message":null,"validation_errors":null} message in the Admin > Scheduler > History panel.Check to see if you have a file named specified in the schedule, as this can cause this error. Also test if the set-up of the Action integration is valid (Admin > Action > Settings and test). This was seen in Google Cloud Storage and Azure Storage. This content is subject to limited support.

ryan.dunlavyLooker Staff

published in Technical Tips & Tricks

Can Looker track how many scheduled emails were opened for a customer? (Read receipts)Knowledge Drop

Last tested: May 14, 2019There isn't any way to see who read emails that have been sent from Looker - feature request for comment is here This content is subject to limited support.

MorganLooker Staff

published in Technical Tips & Tricks

What does "Cache Reset At" mean in the Datagroups tab?Knowledge Drop

Last tested: Jul 4, 2018 "Cache Reset At" refers to the last time the datagroup was "triggered" and cleared all of the cache for the explore/model/pdt. This corresponds to the sql_trigger parameter used in the datagroup definition."Cache Reset At" does not account for max_cache_age parameters. It only refers to triggered cache clears. The reason is that max_cache_age does not specify a universal cache expiration across the entire datagroup; it only specifies cache expiration for individual queries. For example, if you have max_cache_age: "1 hour" , and you run queries at 9:00 and 9:05, those cached queries will expire at 10:00 and 10:05 respectively (assuming they have not been busted by a sql_trigger change first). So there is no single time that would make sense to display for when the max_cache_age resets. This content is subject to limited support.

Kento_TomineCommunity Admin

published in Technical Tips & Tricks

Can we send an unlimited result with Schedule?Knowledge Drop

Last tested: Nov 23, 2020 Yes, we can. Schedules sent via webhook, S3, or SFTP can send an unlimited result set as long as the result set streams.Sam explained in this article. For more details, please search (command + F) "Scheduling and Sending" in this article. This content is subject to limited support.

Department of Customer LoveLooker Staff

published in Technical Tips & Tricks

Why aren't my SSO embed URLs creating a new embed user when I access them?Knowledge Drop

Last tested: Aug 24, 2020 If you are getting a "You are not authenticated to view this page" 401 error, then the login has failed and the user will not be created. Try the URL in the Embed URI Validator. Fabio's troubleshooting guide can also be helpful.If the login is successful, this most likely means that existing credentials are being used instead of new credentials. Check to see whether the external_user_id in the embed URL matches the embed credentials of an existing user under Admin - Users.If the external_user_id does not match an existing user, check to see if force_logout_login is set to false in the embed URL. If so, when a user has an existing UI Looker session and accesses a new URL, their existing credentials are used instead of the embed credentials defined in the new URL, so no new user will be created.It is generally recommended to set force_logout_login to true to avoid these issues. Virtually all use cases for setting force_logout_login to false can be made cleaner b

molly.lippsettLooker Staff

published in Technical Tips & Tricks

HADOOP—Error: Error reading from hdfsKnowledge Drop

Last tested: Aug 13, 2018What does this mean when you see it in a database connection test? It's possible for blocks of the Hadoop File System to get corrupted - in this case you'll see a message like this. Removing the corrupted block from hdfs removes the error. This content is subject to limited support.

1
...
57
58
59
60
61
62
63
...
85

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