Looker: Google's Data Analytics Platform
Looker is Google Cloud's data analytics platform that creates a single source of truth for metrics. It uses a modeling language, LookML, to define business logic on top of your database.
The mental model
Looker is not just a dashboard tool; it's a data modeling platform that sits on top of your existing database. Think of it as a 'source of truth' factory for your company's metrics. You define a metric like 'revenue' once in its modeling language, LookML, and everyone in the company uses that exact same definition for their analysis.
How it works
Looker connects directly to a company's live SQL database (like BigQuery or Snowflake). Developers write LookML code to define dimensions (attributes like 'customer signup date'), measures (aggregations like 'count of users'), and the relationships between data tables. This LookML model acts as a semantic layer. Business users then use a web interface to explore this modeled data, create visualizations, and build dashboards by pointing and clicking. Looker translates their actions into optimized SQL queries and runs them against the database in real time.
When to use it
Use Looker to empower non-technical users to self-serve their own data questions safely and consistently. It is ideal for establishing a single source of truth for key business metrics across an organization, ensuring everyone uses the same calculations. Its API also allows for embedding analytics and reports into other applications.
When not to use it
Looker is not a database; it does not store data. It queries your database live, so it's a poor fit if your underlying database is slow or not designed for analytical workloads. The upfront investment in building a robust LookML model can be significant, making it overkill for small teams or simple, one-off analyses where a direct SQL client would suffice.
One canonical example
A company wants to track 'Monthly Active Users' (MAU). Instead of each analyst writing a slightly different SQL query, a data engineer defines the logic for MAU once in the central LookML model. Now, anyone on the marketing, product, or executive team can drag the 'Monthly Active Users' measure into a report, confident they are using the official, vetted definition.
Interview question
A company uses Looker to analyze its sales data. What is the primary role of LookML in this scenario?
- a.To define consistent business metrics and relationships for all users.Correct
- b.To directly create and manage the underlying SQL database tables.
- c.To generate pre-computed aggregate tables for faster dashboard loading.
- d.To store the company's raw sales data for long-term archival.
Why? this is the answer
LookML's core function is to define business logic, dimensions, and measures once, ensuring a 'single source of truth' for metrics across the organization. Looker does not store data itself, nor does it manage the underlying database tables directly.
Just read this? Test yourself on what you have been reading.
Read the original → docs.cloud.google.com
- #data analytics
- #bi
- #google cloud
- #lookml
Put your scrolling time to good use
Learn one idea, try a quiz and save useful cards for revision. Tezvyn makes it easy to learn and stay current in your tech field, a few minutes at a time.
The iPhone app is on the way
We are building it. Until it lands, nothing here is held back from you: every interview card, your saved cards, streaks and the job board all work in Safari, plus hundreds of free practice quizzes of thirty questions each. Sign in and it all carries over to the app the day it arrives.
Want it as an icon? Tap Share at the bottom of Safari, then Add to Home Screen. It opens full screen and the cards you have read stay available offline.
We are hiring for this. Every open role lists the topics its interview covers, so you can prepare for the real thing rather than guessing.
See open roles