Quary enables teams to model, test and deploy data transformations. This core is a fast (30x faster than DBT to be precise!) and lightweight SQL transformation engine written in Rust.
- Visit our website to learn more
- Visit our documentation to learn how to use Quary
Teams use Quary to transform their raw data tables in a data warehouse into actionable trustworthy insights. Users can easily transform their data by writing SQL select statements, which Quary then converts into tables and views within the data warehouse.
A Quary project is formed by a collection of these select statements, also known as models. These models often build upon one another, creating a structured flow of data transformation. Quary simplifies the process of visualizing dependencies from the source (raw table) to the final insight. Additionally, it provides testing capabilities for the models at each stage, ensuring data integrity and accuracy.
brew install quarylabs/quary/quary
Check out our template here of an example Quary project. The following commands clone the repo, and run some basic commands.
git clone https://github.com/quarylabs/template.git
cd template
quary compile
quary test -s
quary run
Note that you will most likely want to use our Visual Studio Code extension
quary help
If you run into any problems using Quary, please let us know. We want Quary to be easy-to-use, so if you are getting confused, it is our fault, not yours. Create an issue and we'll be happy to help you out.