Malloy

Search this site

Embedded Files

Skip to main content

Skip to navigation

Malloy

A modern open source language for analyzing,<br>transforming, and modeling data.

Born in Santa Cruz, California

Why Malloy?<br>Simple naming and practical reusability. Save time by avoiding repetitive definition writing.<br>Prevents the frustration of seemingly accurate queries leading to incorrect results.<br>Easier to read, write, and comprehend.<br>Refine your model iteratively as you query.

How it works<br>Malloy queries are concise and reader-friendly. They seamlessly translate into SQL, optimized for your database.<br>Malloy's semantic data modeling allows you to effortlessly craft and recycle intricate business logic.<br>Daunting, intricate SQL challenges become straightforward in Malloy.

Hands down the cleanest implementation<br>of a better SQL I've seen so far.<br>Idris Munk

Nested Queries<br>Discover how easy it is to write queries using Malloy to produce rich hierarchical views of data.<br>No more rewriting queries to create hierarchies. Queries are reusable components in Malloy.<br>See relationships and dimensions of the data simultaneously - giving you unparalleled insights.

Symmetric Aggregates<br>Malloy automatically prevents miscalculating aggregates such as sums, averages, and counts. This helps take a huge burden off analyst's shoulders who risk charging ahead with incorrect data.

This feels like magic.<br>Lloyd Tabb

Freedom and Safety<br>SQL offers maximum freedom, but no safety. - and it’s impossible to save or reuse calculations in a data model.<br>Existing semantic data models, like LookML, provide safety but restrict analytical freedom.<br>Malloy combines the safety of a semantic data model with the full flexibility of a relational query language.

How to Get Started<br>Check out our Quickstart tutorial:<br>Malloy Quickstart<br>Learn more on our Documentation page:<br>Malloy Documentation<br>Install our VSCode Extension and start writing Malloy on your own datasets:<br>Visual Studio Marketplace<br>Join the Slack community – share what you’ve built, ask questions, and give us feedback!<br>Malloy Slack

Google Sites

Report abuse

Google Sites

Report abuse