Bruin Academy

Practical guides for Bruin CLI, Cloud, and AI agents

Install Bruin, create projects, define assets, run and validate pipelines, configure Cloud connections, inspect lineage, and set up AI agents.

Start with the CLI Find your track Join the community

Academy map

Pick the fastest path through Bruin.

Start with setupInstall Bruin, create a local project, or connect Cloud.Pick a practical pathFollow role, industry, and AI analyst examples.Filter the full librarySearch by product, stack, role, level, and content type.Move toward productionBring Bruin into your repo, schedule, lineage, and team workflow.

Getting started

Start with the Bruin setup path you need.

Use these when you are new to Bruin or setting up a new environment. They cover installation, the first local project, core concepts, Cloud projects, connections, and enabling a pipeline.

Use cases

Practical examples by job, role, and industry.

These demos show how to apply Bruin features to real-world workflows: marketing analytics, financial analysis, and Shopify data pipelines.

GuideNew

Salesforce to Snowflake ELT

Build a Salesforce to Snowflake pipeline with Bruin Cloud connections, ingestr assets, MCP, Slack, and a Bruin agent that can create, maintain, and repair the graph.

15 min - video
DemoNew

Marketing Analyst

Ingest Google Ads, Klaviyo, and GA4 into DuckDB, build staging and report layers, and let an AI agent answer attribution and CAC questions.

6 steps - 60 min
DemoNew

Stock Analyst

Ingest FMP, Yahoo Finance, and FRED into DuckDB, build staging and report layers, and let an AI agent analyze fundamentals, prices, and macro regimes.

6 steps - 60 min
DemoNew

Shopify Data Pipeline

Build an analytics stack for your Shopify store - pick your warehouse, marketing, and ads tools.

6 steps - 70 min

Library

Browse the Academy library.

Filter all Academy content by product, content type, stack, level, industry, and role.

Product

Content type

Stack
Level
Industry
Role
Getting startedcli

Install Bruin

Install Bruin CLI, add the VS Code extension, and connect AI tools through Bruin MCP.

3 parts - 10 min
Getting startedcli

Chess Data to DuckDB

Build the first local pipeline with a public API, DuckDB, ingestr assets, and SQL transforms.

1 guide - 8 min
Getting startedcli

Bruin Core Concepts

Learn projects, pipelines, assets, variables, checks, and commands before building production workflows.

5 concepts - 25 min
GuidecliNew

Dashboards as Code with Bruin DAC

Scaffold a DAC project, connect a local DuckDB, author a YAML dashboard, and serve it on localhost - then let the in-browser AI assistant add new charts by chat.

4 steps - 20 min
DemocliNew

Stock Analyst

Ingest FMP, Yahoo Finance, and FRED into DuckDB, build staging and report layers, and let an AI agent analyze fundamentals, prices, and macro regimes.

6 steps - 60 min
DemocliNew

Marketing Analyst

Ingest Google Ads, Klaviyo, and GA4 into DuckDB, build staging and report layers, and let an AI agent answer attribution and CAC questions.

6 steps - 60 min
GuidecliNew

Build an AI Data Analyst

Go from zero to a working AI analyst that understands your database and answers business questions.

6 steps - 55 min
Guidecli

End-to-End Pipeline: NYC Taxi

Build a complete data pipeline from raw API data to clean, aggregated reports with quality checks.

4 steps - 40 min
GuidecliNew

dbt + Bruin AI Data Analyst

Layer Bruin context on top of an existing dbt and warehouse setup so an AI agent can navigate models and run real SQL.

5 steps - 45 min
DemocliNew

Shopify Data Pipeline

Build an analytics stack for your Shopify store - pick your warehouse, marketing, and ads tools.

6 steps - 70 min
Guidecli

Notion to PostgreSQL

Load Notion data into PostgreSQL using Bruin's ingestr asset type.

2 steps - 10 min
Guidecli

Oracle to DuckDB

Move data from Oracle XE into DuckDB with Docker setup, data seeding, and SQL transformations.

3 steps - 16 min
Guidecli

Using Bruin Templates

Scaffold a complete data pipeline with ready-made blueprint templates.

2 steps - 8 min
Guidecli

IDE Extension

Install and explore the Bruin extension for VS Code and Cursor - manage pipelines, view lineage, and preview queries.

2 steps - 8 min
Guidecli

Bruin + Python

How Bruin supports Python - from Python assets and materialization to the Python SDK that removes boilerplate.

2 steps - 22 min
Guidecli

Data Engineering Zoomcamp

A free bootcamp by DataTalks.Club covering the data engineering lifecycle with Bruin.

9 steps - Self-paced
Guidecli

Incremental vs. Full Refresh Runs in Bruin

Learn how Bruin's interval start/end variables drive incremental runs, how --full-refresh changes the picture, how each behaves across SQL, Python, and ingestr assets, and how to protect critical tables with refresh_restricted.

7 min
Guidecli

Using the Bruin Python SDK

Skip the boilerplate. Use the Bruin Python SDK to query databases, manage connections, and access pipeline context from your Python assets with a few imports.

12 min
Guidecli

Materializing Python Assets into Your Warehouse

Return a DataFrame, let Bruin handle the rest. Learn how to use Python materialization to load data into BigQuery, Snowflake, Postgres, and more - with support for merge, append, and incremental strategies.

10 min
Guidecli

AI Analyst for Stock Market Data with BigQuery & Claude

Build a local AI analyst for stock market and investment data using Bruin CLI, BigQuery, and Claude Code.

15 min - video
Guidecli

Set Up Bruin MCP with Claude Code

Install the Bruin MCP in Claude Code to give your AI agent full access to the Bruin CLI - query data, run assets, and build pipelines using natural language.

3 min - video
Guidecli

Validate Pipelines Before Deploying

Use bruin validate to check pipeline configurations, asset definitions, SQL syntax, dependency issues, and circular dependencies before deploying.

3 min - video
Guidecli

Navigate Your Run History

Use the Bruin VS Code extension to browse past runs, see which assets succeeded or failed, copy commands, and re-run previous executions.

2 min - video
Guidecli

Understand Materialization with Render

Use bruin render to see how materialization transforms your SQL queries at runtime - from append inserts to full refresh table recreation.

4 min - video
Guidecli

Query Databases from Your IDE

Use the Bruin extension's built-in database viewer to browse tables, view schemas, and run queries across all your connections without leaving VS Code.

2 min - video
Guidecli

Auto-Generate Asset Dependencies

Use bruin patch fill-asset-dependencies to automatically detect and generate dependencies from your SQL queries - no manual declaration needed.

2 min - video
Guidecli

Auto-Generate Column Schema from Your Database

Use the Bruin extension to automatically pull column names and data types from your database into your asset definitions - no manual entry needed.

2 min - video
Guidecli

Run Multiple Specific Assets

Select exactly which assets to run using the Bruin VS Code extension - pick individual assets, include downstream dependencies, and create targeted runs.

2 min - video

Production next step

Bring local Bruin work into governed Cloud operations.

Bruin Cloud is the managed layer for the pipelines you build with Bruin CLI and ingestr. It connects to your Git repo, stores connections securely, runs pipelines on schedule, tracks catalog and lineage, and gives teams AI agents in Slack, Teams, or the browser.

Book a demo Explore Bruin Cloud

From repo

Git-synced projects

Connect a repository once, then let Cloud sync pipelines, assets, schedules, and environment-specific settings from code.

Operations

Scheduled runs

Run pipelines on schedule, trigger manual runs, inspect history, and recover from missing configuration without leaving Cloud.

Governance

Catalog and lineage

Use asset metadata, tiers, quality checks, lineage, and audit trails to understand what changed and who depends on it.

Team access

AI agents for data

Expose governed data workflows through Cloud chat, Slack, Teams, dashboards, scheduled agents, or the Bruin Cloud MCP.

Cloud guide path

01

Manage connections

Move local connection names into encrypted Cloud connections that pipelines and agents can use.

4 min guide02

Create a project

Connect GitHub, sync a Bruin project, and attach the connections your production runs need.

4 min guide03

Enable a pipeline

Turn on a synced pipeline, resolve missing connections, trigger the first run, and check lineage.

4 min guide