yato — orchestrate your queries with no pain
summary
Small Python package that runs a folder of SQL files and materializes tables in a local DuckDB in dependency order by matching SQL globs, producing a working DuckDB database from a repo of queries. Demo uses the jaffle_shop example, generates a Mermaid lineage diagram for table dependencies, and the GitHub repo had 199 stars that morning. Does not call dbt internals — it infers dependencies from SQL text — and column‑level lineage is not implemented yet.
AI-written summary · about
related talks
25mA quack of all trades: DuckDB, a versatile analytical database to keep in your toolkit
22mDuckDBT: Not a database or a dbt adapter but a secret third thing
33mData preparation and analytics on your laptop with DuckDB
47mPlay Data Engineer Locally with DuckDB
28mAnalyze data easily with duckdb - and the implications on data architectures
38mFrom Big Data to DuckDB: Ryan Boyd (MotherDuck) on Hyper-Tenancy, Duck Lake, and Making Data Fun.
07mAerodynamic data models: Flying fast at scale with DuckDB
55mDuckLake: Learning from Cloud Data Warehouses to Build a Robust “Lakehouse”