Bruin Academy

Guide

Chess Data to DuckDB

Build your first Bruin pipeline by ingesting chess API data and storing it in DuckDB - no credentials needed.

Build your first Bruin pipeline

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.

Before you start

Guide overview

Start guide
  1. 1Initialize & ConfigureScaffold a chess data project from a template and configure your DuckDB and Chess API connections.
  2. 2Run & QueryExecute the chess pipeline and query the results in DuckDB to verify your data.

Resources

Bruin CLI documentationDuckDB platform docsIngestr asset type

Get help & contribute

Join Slack GitHub Docs

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.