Malloy is an open source language for describing data relationships and transformations. It is both a semantic modeling language and a querying language that runs queries against a relational database. Malloy currently supports BigQuery, Postgres, and DuckDB.
We've built a Visual Studio Code extension to facilitate building Malloy data models, querying and transforming data, and creating simple visualizations and dashboards.
Click here to try Malloy in your browser!
To write your own Malloy models, use the VS Code Extension, currently available for Mac, Linux, and Windows machines.
-
Download Visual Studio Code: Download Visual Studio Code
-
Add the Malloy extension from the Visual Studio Code Marketplace: Open VS Code and click the Extensions button on the far left (it looks like 4 blocks with one flying away). This will open the Extension Marketplace. Search for "Malloy" and, once found, click "Install"
-
Download and unzip the Sample Models (models data).
-
Open the samples folder in VS Code. In VS Code, go to File > Open Folder... select samples/duckdb > Open. DuckDB is built into the extension so you're ready to run these.
-
Start with
1_airports.malloy
in the FAA dataset. This is a sub-sample of the NTSB Flights dataset. In the editor pane, abovesource: airports
, click the word "Preview" to run aSELECT *
, and click the word "Run" above any query object to run it (see gif below for example).
To get to know the Malloy language, follow Malloy by Example and/or continue through the numbered models in the FAA directory.
Note: The Malloy VSCode Extension tracks a small amount of anonymous usage data. You can opt out in the extension settings. Learn more.
- Join our Malloy Slack Community! Use this community to ask questions, meet other Malloy users, and share ideas with one another.
- Use GitHub issues in this Repo to provide feedback, suggest improvements, report bugs, and start new discussions.
Documentation:
- Malloy Language - A quick introduction to the language
- eCommerce Example Analysis - a walkthrough of the basics on an ecommerce dataset (BigQuery public dataset)
- Modeling Walkthrough - introduction to modeling via the Iowa liquor sales public data set (BigQuery public dataset)
YouTube - Watch demos / walkthroughs of Malloy