jaffle_shop is a fictional ecommerce store. This Quary project transforms raw data from '.csv' with DuckDB into a customers and orders model ready for analytics.
This repo is a self-contained playground Quary project. It is helpful for trying Quary and learning some of its core concepts.
This repo contains .csv data, including some (fake) raw data from a fictional app. The raw data consists of customers, orders, and payments, with the following entity-relationship diagram:
The beauty of Quary is that it's easy to start interacting with this project.
You can do this by clicking the period key . on your keyboard straight from this repository. It will take you to an in-browser version of vscode.
Once there, you can install the extension by either:
- Clicking the
Installbutton in the bottom right corner when VS Code asks you to install recommended extensions - Clicking on the extensions icon and installing the extensions from there in the
Recommendedtab
To get a feel for interacting with data models, head to customers.sql and hit the CMD+D (ctrl on Windows) shortcut to open the model documentation or the CMD+Enter (ctrl on Windows) shortcut to see the transformed data.
For more information on Quary:
- Star our opens-source repo.
- Read the Quary documentation.
- Join the Quary community.
A jaffle is a toasted sandwich with crimped, sealed edges. Invented in Bondi in 1949, the humble jaffle is an Australian classic. The sealed edges allow jaffle-eaters to enjoy liquid fillings inside the sandwich, which reach temperatures close to the core of the earth during cooking.
This template example project is copied and modified for Quary based upon DBT (Data Build Tool)'s project example. DBT/jaffle_shop is licensed under the Apache License 2.0.