An experimental language for data
Welcome to Malloy - an open source language that offers a new way to compose with data, to expose the intelligence you need, all with a single query.
Each query you write in Malloy is a building block for the next level of understanding. The more queries you build, the more refined your understanding becomes.
Malloy is the first hyper-dimensional programming language built for the needs of a big data world.
What is hyper-dimensionality?
When you're working with complex data, and want to see the relationships between data, Hyper-dimensionality allows composition not just with measures and dimensions, but with entire queries and across the relationship graph. This exposes all the interesting facets of a data set, simultaneously, in an easy and understandable way.
Model and Query
Malloy is a semantic data model and a query language in one. Seamlessly build your reusable model as you go.
Hyper-dimensional
Reusable components that expose all the relationships within the data set simultaneously and in a single view.
Superpower your SQL
Malloy writes SQL, optimized for your BigQuery, DuckDB or Postgres (beta) database.
How it works
Discover how easy it is to write queries using Malloy to produce rich hierarchical views of data.
No more rewriting queries to create hierarchies. Queries are reusable components in Malloy.
See relationships and dimensions of the data simultaneously - giving you unparalleled insights.
Playground
Try Malloy in one of our no-install, completely web-based demo environments.
Malloy Composer lets you build a web based data exploration experience by adding just 3 files to your data model. Learn more
Get started
Install Malloy to use with your own data.
Resources
Documentation
Language reference and Quickstart guide
Slack
Please join our Slack community!
We'd love to help.
Github
Discussion, feature requests, and bug tracking
Malloy is full of new ideas. As you work with Malloy, we'd love to help explain them.
Please ask your questions, as they will help Malloy be better. See you on Slack!