Models and materialization - Step 5 of 14
Chess Data to DuckDB
Build a small local pipeline with DuckDB.
Before you start
- Bruin CLI installed
What
Build a complete data pipeline that pulls Chess.com game data from a public API and loads it into DuckDB for analysis. No API keys or database credentials are needed because the chess API is open and DuckDB runs locally.
How
Use bruin init chess to scaffold a project with pre-configured assets. Ingestr assets pull data from Chess.com, SQL assets transform it, and bruin run executes the pipeline end to end. You will finish by querying the DuckDB summary table.