Looker Connect Training

Help Center

Documentation

Community

Cloud Certifications

The Kitchen Table

Explore the product knowledge we've built up together

2061 Topics

Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

Empowering Yieldify with data: what has Looker done for us?

This content, written by Demis Bhojoo, was initially posted in Looker Blog on Apr 4, 2016. The content is subject to limited support.I recently stumbled upon Justin Kan’s old post This post reminded me of my time at - where my colleague and friend, Charles Dupont, wrote an excellent article on why learning SQL is important for any business team. The article describes how, through the use of data, a small team managed to automate 90% of repeatable tasks (obviously a huge time saver) and enabled individuals to delve deeper into the reasons why specific actions were successful or not. Having taken the leap early on, any new hire was able to use data to learn and develop effectively - and that’s how I got started in Business Intelligence. This short blog post reflects on how Looker has changed the way we work at Yieldify by empowering employees with easily accessible data - here we go. Business Intelligence or Intelligent Business? Since being deployed, the Business Intelligence (BI) te

130
Department of Customer Love
Moderator
1 month ago
Peggy_Beard
Looker Staff
Peggy_BeardLooker Staff
published in Technical Tips & Tricks

Why does my project still have the "Deploy to Production" option when I have enabled pull requestsKnowledge Drop

Last tested: Dec 16, 2020Has the project been deployed to production at least once? The very first deploy can't be via pull request. This content is subject to limited support.                  

130
Peggy_Beard
Looker Staff
11 months ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

Can I sort my pivoted table by measure totals?Knowledge Drop

Last tested: Jun 1, 2020 No - there is a feature request, please add your +1 and use caseYou can do this for row totals however, just by clicking on the row total column header. This content is subject to limited support.                  

130
sam
Looker Staff
10 months ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

5 Ways Looker makes Firebase Analytics Data in BigQuery Useful

This content, written by Ernesto Ongaro, was initially posted in Looker Blog on Nov 22, 2019. The content is subject to limited support.The best apps today use a data-driven approach to make them successful. Knowing which segments of users stick around and get the most value (and in turn give you the most revenue) shouldn’t be a guessing game, it should be an exact science. Millions of modern apps are written in Google’s backend application development platform, Firebase. Firebase contains over 18 tools to help application developers build, improve, and grow any app. If you’ve used apps from Venmo, The Economist, or The New York Times, then you’ve used Firebase. There are a few moving pieces here, so let’s introduce them. Cloud Firestore is a database to store your application events, where they can then be analyzed in Firebase Analytics. Firebase Analytics offers some great out of the box functionality, but a lot of growing companies run out of runway with it, and their analytical que

130
Department of Customer Love
Moderator
1 month ago
molly.lippsett
Looker Staff
molly.lippsettLooker Staff
published in Technical Tips & Tricks

Can I use a dimension in a sql_trigger_value?Knowledge Drop

Last tested: Dec 1, 2020 Currently no. You can, however, select from ${view.SQL_TABLE_NAME} This content is subject to limited support.                  

130
molly.lippsett
Looker Staff
1 year ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

What is a Gravatar?Knowledge Drop

Last tested: Sep 21, 2020 Gravatar is how we populate a user profile picture in Looker. Once you have a Gravatar set up, it will show up in the top right of the page. To navigate to the set up, you can click the link above or go to "Account" in the top right hand corner. This content is subject to limited support.                  

130
sam
Looker Staff
10 months ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

How secure are Public Look URLs, and can I make them more secure?Knowledge Drop

   Last tested: June 2021 Public Looks are completely public. In that way, they are not at all secure.However, the URL is a random hash, which should be unguessable. In that way, they're fairly secure.You can make your Public Look more secure by setting up IP allowlisting on your Looker instance. This content is subject to limited support.                

130
sam
Looker Staff
11 months ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Technical Tips & Tricks

How do we fix a blank timezone in Looker-generated SQL?Knowledge Drop

Last tested: May 11, 2020 There is a known issue where disabling user-specific timezones can cause this to a Look that was created when user-specific timezones were enabled.Either enabling user specific timezones or creating the look from scratch with user-specific timezones off should solve the problem. This content is subject to limited support.                  

130
Department of Customer Love
Moderator
10 months ago
noahmac
Looker Staff
noahmacLooker Staff
published in Technical Tips & Tricks

Network Requirements for Instances Connecting to MarketplaceKnowledge Drop

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 to access https://github.comYou should be able to access the content you're interested in after adjusting these rules. This content is subject to limited support.                 

130
noahmac
Looker Staff
1 year ago
ryan.bouquet
Looker Staff
ryan.bouquetLooker Staff
published in Technical Tips & Tricks

Can I only publish one database view even if the view is in multiple models?Knowledge Drop

Last tested: Jun 22, 2020 Yep, using refinements!Instead of applying "publish_as_db_view: yes" in the view itself, instead we will use refinements on the one model we want to build it for. There we refine it like so: view: +pdt_name {derived table: {publish_as_deb_view: yes}} That way, the publish parameter is only applied inside the one model instead of for each model the table is included in This content is subject to limited support.                  

130
ryan.bouquet
Looker Staff
10 months ago
maxcorbin
Looker Staff
maxcorbinLooker Staff
published in Technical Tips & Tricks

URI (Universal Resource Identifier) for Looker embedKnowledge Drop

Last tested: Jul 3, 2018 A Uniform Resource Identifier (URI) is a string of characters used to identify a resource within a network of computers, such as the World Wide Web. A Uniform Resource Locator (URL) is a kind of URI that also implies the means for retrieving the referenced resource.A URI takes the following generalized form:scheme:[//[user:password@]host[:port]][/]path[?query][#fragment]You can read more about the components of the generalized form here, but for Looker URLs we can pare this down to something more specific:scheme://host[:port]/path[?query]If your path or query strings contain special characters like '/' or '?', you'll need to percent-encode them so that they won't be confused with URI syntax elements. For example, '/' turns into '%2F' and '?' turns into '%3F'. You can easily encode and decode URLs with simple online tools, like this one. This content is subject to limited support.                   

130
maxcorbin
Looker Staff
1 year ago
Lan
Looker Staff
LanLooker Staff
published in Technical Tips & Tricks

publish as db view in multiple projects / modelsKnowledge Drop

Last tested: Feb 11, 2021 What happens if you publish db view in multiple projects or models?It will create a db view for each model -- given that all model belongs to the same projectsIf a PDT is included in two models in two projects, it will only create one stable view for one project This content is subject to limited support.                   

130
Lan
Looker Staff
11 months ago
jamesnestler
Looker Staff
jamesnestlerLooker Staff
published in Technical Tips & Tricks

No clickable links in visualizations (link parameter)Knowledge Drop

Last tested: Jun 12, 2019 One potential reason for this could be if we're trying to use both a link AND html parameter. For example the following won't work:measure: broken_link {type: counthtml: <insert some cool html formatting here>link: {label: "It's broken"url: "tryingtolinkout_butitsbroken.com"}}  This content is subject to limited support.                  

130
jamesnestler
Looker Staff
11 months ago
V
Looker Staff
vishal.dharmadhikariLooker Staff
asked in Technical Tips & Tricks

What does the graph_derived_tables_for_model endpoint do?

You can use the graph_derived_tables_for_model endpoint (documentation) to get a dependency graph of all the PDTs in a specific model in the DOT language. The output can then be rendered into an image by passing the output into a graphviz tool. The rendered image will look something like:  This content is subject to limited support.                

0
V
Looker Staff
10 months ago
Peggy_Beard
Looker Staff
Peggy_BeardLooker Staff
published in Technical Tips & Tricks

Does Instant Dashboards work in embed?Knowledge Drop

Last tested: Nov 16, 2020No, it doesn't. "Fast cached results" do not work in embed because of differences in drill links that aren’t considered in the cache key. This content is subject to limited support.                  

130
Peggy_Beard
Looker Staff
10 months ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Technical Tips & Tricks

Can Admin users view the rendering queue?Knowledge Drop

Last tested: Aug 22, 2017 No, users cannot see the rendering queue.The rendering of PDFs and PNGs is handled by a separate process called Chromium which happens outside of the Looker UI.There is a Feature Request for being able to see rendering queue in the Admin panel. This content is subject to limited support.                   

130
Department of Customer Love
Moderator
11 months ago
A
Looker Staff
adina.katzLooker Staff
published in Technical Tips & Tricks

extension: required and validationKnowledge Drop

Last tested: Apr 30, 2019 The extension: required parameter flags an Explore as requiring extension, which means that the Explore cannot be used on its own. The contents and settings of the Explore will only be used when the Explore is extended using the extends parameter in another Explore.What this means in terms of validation: If there are any validation errors in the base explore then these errors will not surface until the explore is extended and the extended explore inherits the errors. Essentially, there are no errors in the base explore until that explore is extended and we don't resolve the error in the extended explore. This content is subject to limited support.                   

130
A
Looker Staff
11 months ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

3 key considerations for embedded analytics

This content, written by Shohei Narron, was initially posted in Looker Blog on May 24, 2016. The content is subject to limited support.You’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 cloudier. Your end users can’t run their own queries, which means they have to wait for someone else to generate the information they need. Because your solution requires moving data out of your database, analysis is complicated and time-consuming, placing your data analysts in an uncomfortable position: just by doing their jobs, they’re creating a bottleneck. Your engineers would love to help, but wouldn’t focusing on your core offering be a better use of their time? You’re now considering adding value to your customers by giving back the data you’ve collected through a new analytics offering, and you wonder whether to build the tool yourselves or buy an existing tool. Enter Powered By Looke

130
Department of Customer Love
Moderator
1 month ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

4 easy ways to embed analytics with Looker

This content, written by Haarthi Sadasivam, was initially posted in Looker Blog on Nov 6, 2017. The content is subject to limited support.The customers have spoken and, as featured in the , have selected Looker as the Leader in the Embedded Analytics space. So, what exactly does embedding with Looker look like? Powered by Looker Looker’s embedded analytics platform, is all about accessing data within your daily workflow. That could mean public static reports on your website, a private authenticated dashboard in your day-to-day tools, or a full embedded experience within your product for your customers and suppliers. The great thing about all these different use cases is that they all leverage the Looker platform without having you reinvent the wheel. Our powerful modern data modeling layer makes it easy to define your metrics or reports just once for all your different users. Also, your stakeholders can make use of Looker’s reliable scheduling, alerting, and data delivery capabilities

130
Department of Customer Love
Moderator
1 month ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

Accelerating machine learning with Looker + Amazon SageMaker

This content, written by Eric Carr, was initially posted in Looker Blog on Nov 26, 2018. The content is subject to limited support. have been strategic partners since shortly after Looker’s inception. Looker hosts its instances in Amazon Web Services (AWS), and over 55% of our clients are using one of the many Amazon-hosted cloud databases such as , Athena, and various Relational Database Service (RDS) flavors as their primary Looker data sources. With such compatible products and hundreds of joint customers, Looker and AWS are continuously working together to make the end-user experience more streamlined, which makes re:invent one of the annual highlights for our team and customers. This year is no exception. At AWS re:Invent 2018, we’re announcing an integration with AWS SageMaker, as well as a new trial of Amazon Redshift and Looker. We’re excited about both of these additions because we believe that the combination of Looker and Amazon is truly changing the lives of our joint custo

130
Department of Customer Love
Moderator
1 month ago
paola
Looker Staff
paolaLooker Staff
published in Technical Tips & Tricks

Do public URLs work with access filters?Knowledge Drop

Last Tested: Apr 29, 2019 If your Look is dependent on access filters, the public URL will not work. (This includes Google Spreadsheets and Excel imports). This content is subject to limited support.                 

130
paola
Looker Staff
1 year ago
jamesnestler
Looker Staff
jamesnestlerLooker Staff
published in Technical Tips & Tricks

Python-SDK: Why isn't the returned object in JSON?Knowledge Drop

Last tested: Jan 24, 2020 Use file.attribute to access attributes of the object (eg, file.url or file.id).Alternately, use the hidden attribute __dict__ to return the object in json format (eg, file.__dict__ ) This content is subject to limited support.                  

130
jamesnestler
Looker Staff
10 months ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

3 steps for optimizing Looker dashboards with Amazon Redshift

This content, written by Donal Tobin, was initially posted in Looker Blog on Sep 30, 2020. The content is subject to limited support.Many Looker users find that Redshift is an excellent, high performance database that can be used to power sophisticated dashboards. However, given Redshift’s architecture, having an increased number of tiles in a dashboard can result in slower response times and queries that take longer to complete than they initially did. In this piece, we’ll explore how to fine-tune your Redshift cluster so you can better match your Looker workloads to your Amazon Redshift configuration and render dashboards quickly and efficiently. How data bottlenecks happen For many organizations, standing up an analytics stack can initially be a bit of an experiment. It often starts with an identified data need, followed by somebody spinning up an Amazon Redshift cluster, building a few data pipelines, and then connecting an analytics platform, like Looker, to visualize the results.

130
Department of Customer Love
Moderator
1 month ago
Department of Customer Love
Moderator
Department of Customer LoveModerator
published in Blog Archives

Looker and Vertica - geospatial analytics

This content, written by Erin Franz, was initially posted in Looker Blog on Dec 22, 2015. The content is subject to limited support.Vertica offers a suite of geospatial analytics functions with its HP Vertica Place package. This package enables storing and querying of geometric objects - translating locations into geometric points and regions into polygons. Common asks for measuring distance, length, area can be completed directly in Vertica and these requests are optimized at scale using spatial indexes and the underlying power of Vertica’s database. Because Looker performs all analytical workloads in HP Vertica, Looker can utilize these geospatial analytic functions to enable exploration and visualization of results dynamically. To demonstrate some of what’s possible, we’ll start with a table of bookings in Vertica that have associated latitude and longitude locations. When we query for a sample of the table, called locations, we see the following: select * from place.locations limi

130
Department of Customer Love
Moderator
1 month ago
sam
Looker Staff
samLooker Staff
published in Technical Tips & Tricks

What roles are LDAP/SAML users given?Knowledge Drop

Last tested: Sep 12, 2019 If "set roles from groups" is enabled, "LDAP/SAML users are given roles according to their "group to role mappings". Basically, you set a role in Looker to map to a LDAP/SAML group.If "set roles from groups" is not enabled, then it gives the "default role" and "default group" as specified to ALL new users.Reference: Looker-SAML setup guide, Looker-LDAP setup guide This content is subject to limited support.                  

130
sam
Looker Staff
10 months ago

Badges

  • Friendly Face
    sbrylowskihas earned the badge Friendly Face
  • Helpful
    carriehas earned the badge Helpful
  • Community Star
    carriehas earned the badge Community Star
  • Friendly Face
    carriehas earned the badge Friendly Face
  • Community Star
    Dawidhas earned the badge Community Star
Show all badges
Terms of Service