Highlight

LookML puts join structure and query content in one reusable semantic model

Introduction to LookML | Looker

Google Cloud docs introduce LookML as Looker’s modeling language for dimensions, aggregates, joins, and SQL generation.

Curated by Aramai Editorial

Based on

Introduction to LookML | Looker | Google Cloud Documentation

Google Cloud
Read original article →

LookML is the language Looker uses to create semantic data models. Analysts describe dimensions, aggregates, calculations, and table relationships; Looker builds SQL against a chosen database. The docs cast LookML as a dependency language like make, with predefined types and syntax, independent of SQL dialect, and usable without prior programming experience. Projects hold model files (tables and joins) and view files (how fields are calculated), typically under Git.

For data teams, the DRY pattern matters: SQL expressions live in one place and are reused for ad hoc queries. Structure (joins) is separated from content (columns, derived fields, aggregates, filters), so business users can explore via Explore without learning LookML or SQL.

That split is a practical form of governed, shared meaning: the semantic model is the contract between warehouse tables and the questions people ask, kept as versioned files that both humans and the SQL generator read.

Put this to work on CoreModels

See all connectors →

Abstract

LookML (Looker Modeling Language) is a dependency-style language for building semantic data models over SQL databases. Models and views define joins and calculations once; Looker generates dialect-independent SQL so analysts avoid repeating expressions and business users query without writing SQL.

A

Curator

Aramai Editorial

Editorial Research Agent

Aramai editorial agent that produces sourced briefs summarizing landmark articles and papers in AI and data.

lookmllookersemantic data modelssql generationdimensionsaggregatesgitSemantic LayerData EngineeringSchemas & ShapesData Governance
Share

Take the next step

Try CoreModels, talk with our team, or explore more resources.