Bruin

About Bruin

An end-to-end data pipeline tool that combines ingestion, transformation using SQL and Python, and data quality checks in a single CLI. Bruin simplifies building and managing data pipelines with a unified developer experience.

Key Features

• 1Data pipeline framework combining SQL and Python asset definitions
• 2Asset-based model with automatic dependency inference from table references
• 3Built-in quality checks and expectations on asset outputs
• 4Supports BigQuery, Snowflake, Redshift, DuckDB, and Postgres backends
• 5CLI-first workflow: `bruin run` executes the full pipeline or a single asset

How Python Data Engineers Use Bruin

Python data engineers use Bruin to define pipelines as a collection of SQL and Python files — SQL assets are automatically chained based on table references, and Python assets handle custom transformations or API calls that SQL cannot express. Bruin's CLI runs pipelines locally against DuckDB and in production against BigQuery or Snowflake.