LookML

LookML is the revolutionary language at the heart of Looker’s data platform. It allows data analysts to get all the knowledge about what data means out of their heads and into software. Rather than trying to replace SQL, LookML harnesses all of SQL’s power, while solving some of the toughest things about using SQL in an organization.

Reusable

LookML lets you define the way tables relate to each other once. Then it uses that information to join tables as they’re needed. Any complex join logic you could specify in your database’s SQL dialect can be done in LookML. And using LookML means you can trust that your colleagues are using the right SQL. They’ll never again forget that one critical thing and mess up their queries.

Collaborative

LookML breaks SQL down into bite-sized chunks that are easy to examine, digest and recombine. This encourages collaboration and iteration. LookML makes it easier to understand and update snippets, eliminating the need to untangle giant SQL queries all at once.

Flexible

LookML allows you to specify formatting for measures and dimensions. No more exporting data so you can format numbers as dollars, percents, or decimals. No more avoiding pivots, running totals, and complex CASE statements because they’re hard to write in SQL. LookML makes all of this easy.

Organized

LookML uses views and models to keep your business logic organized. That means you don’t end up with a folder full of disorganized SQL files. LookML is real code that’s structured and extensible.

Controlled

LookML integrates seamlessly with Git via Github or your own Git server. Each data analyst gets their own branch to try out new analyses without affecting everyone else. Every change to your data model can be audited, examined and rolled back, if necessary.

Get Ready to Love Your Analytics

The best way to understand Looker is to experience it in action. Along the way, we’ll answer your questions about what, why, how and what’s next.

Request a Demo