Bruin Academy

Learn Bruin through tracks, use cases, and practical guides.

Start with AI analyst workflows or data pipelines, choose local setup or Cloud setup, then use role guides and the full library when you need a specific example.

Start with the outcome you want.

Pick AI Analyst or Pipelines, then choose local setup, Cloud setup, or the full local-to-team path.

Track

AI Analyst

Build an AI analyst locally, then move to governed Cloud agents for browser chat, schedules, dashboards, and Slack.

6 guides98 minBeginner to intermediate

Best for Analysts and teams using AI for data questions.

Local workflow1 complete guide

Build an AI analyst locally

Create a Bruin project, import warehouse context, wire MCP, and ask SQL-backed business questions from your AI coding tool.
Start guide
  1. 1Create a Bruin ProjectSet up the local workspace for metadata, checks, and agent context.
  2. 2Connect Your DataAdd the warehouse connection the analyst can inspect and query.
  3. 3Build Your Data ContextImport schema details and enrich tables with descriptions and checks.
  4. 4Set Up Your AI AgentConnect Cursor, Claude Code, or Codex through Bruin MCP.
  5. 5Analyze Your DataAsk the first SQL-backed business question with grounded context.
Cloud AI agent5 focused guides

Operate a governed Cloud AI agent

Configure the agent, chat with it, schedule recurring work, deliver answers to Slack, and build dashboards with AI.
Start guide
  1. 1Configure AI AgentsCreate the agent and scope access.
  2. 2Chat with an AI AgentTest browser chat over governed data.
  3. 3Schedule an AI AgentRun recurring reports and alerts.
  4. 4Deploy to Bruin Cloud & SlackAnswer questions from Slack.
  5. 5Build Dashboards with an AI AgentGenerate dashboard views by chat.

Track

Data Pipeline

Build ingestion, transforms, checks, and production workflows with Bruin CLI, ingestr, and Bruin Cloud.

7 guides91 minBeginner

Best for Data engineers and analytics engineers.

Local workflow4 guides

Build pipelines locally

Install Bruin, build your first local project, learn the core concepts, then complete the NYC Taxi pipeline.
Start guide
  1. 1Install BruinCLI, extension, and MCP setup.
  2. 2Build Your First PipelineCreate a local DuckDB pipeline.
  3. 3Core ConceptsProjects, pipelines, assets, and checks.
  4. 4End-to-End Pipeline: NYC TaxiIngest, transform, and validate real data.
Cloud deployment3 guides

Deploy pipelines to Bruin Cloud

Create Cloud connections, attach your Git project, enable a pipeline, and trigger the first governed run.
Start guide
  1. 1Manage ConnectionsStore source and destination credentials.
  2. 2Create a ProjectConnect your GitHub repo.
  3. 3Enable a PipelineTurn on scheduled Cloud runs.

Role-based guides for business and data teams.

Browse the guides that map to real professional workflows: marketing, finance, revenue operations, analytics, BI, and governed data engineering.

Marketing / Growth

Marketing Analyst

Pull Google Ads, Klaviyo, and GA4 into DuckDB, build report layers, and ask attribution or CAC questions with an AI agent.

MarketingGA4CAC
Marketing / Growth

SEO Optimizer Agent

Run a scheduled agent that reads GA4 and GSC data, measures content impact, opens PRs, and reports to Slack.

GrowthSEOSlack
Finance / Investment

Stock Analyst

Pull fundamentals, market prices, and macro data into DuckDB, then ask SQL-backed questions about market performance.

FinanceFMPFRED
Finance / Investment

AI Analyst for Stock Market Data with BigQuery & Claude

Build a local AI analyst for investment data with BigQuery, Bruin CLI, Bruin MCP, and Claude Code.

FinanceBigQueryClaude
Finance / Investment

Connect a Slack AI Analyst to the Stock Market

Deploy a stock market AI analyst to Bruin Cloud and Slack so finance teams can ask governed data questions in chat.

FinanceSlackBruin Cloud
Product Analyst

Reliable Firebase A/B Tests Guide

Build delivery-proofed Firebase cohorts so experiment analysis reflects the assignment that actually reached the device.

Product AnalyticsFirebaseExperimentation
Product Analyst

Deterministic A/B Test Bucketing

Use stable assignment rules so clients, backend services, and warehouse analysis place each user in the same variant.

Product AnalyticsA/B TestingBigQuery
Ecommerce / Revenue Ops

Shopify Data Pipeline

Build an ecommerce analytics stack for Shopify data with ingestion, warehouse setup, reports, dashboards, and an AI analyst.

EcommerceShopifyPipeline
Sales / RevOps

Build a Salesforce to Snowflake ELT Pipeline with Bruin

Create a Salesforce to Snowflake ELT workflow with Cloud connections, Slack delivery, MCP, and operational agent skills.

RevOpsSalesforceSnowflake
Data Analyst / BI Analyst

Build an AI Data Analyst

Set up a local AI analyst that understands warehouse context and answers business questions with SQL-backed analysis.

Data AnalystMCPSQL
Data Analyst / BI Analyst

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 SQL.

Data AnalystdbtBigQuery
Data Analyst / BI Analyst

Dashboards as Code with Bruin DAC

Author dashboards as YAML, query DuckDB, serve locally, and use the in-browser AI assistant to build new charts.

BIBruin DACDuckDB
Data Analyst / BI Analyst

Build Dashboards with an AI Agent

Use a Bruin Cloud AI agent to generate queries, create charts, and build dashboards from natural language prompts.

BIDashboardsBruin Cloud
Data Engineer / Analytics Engineer

Bruin Cloud Deployment

Move a local Bruin project into Bruin Cloud with managed connections, a synced project, and an enabled pipeline.

Data EngineerBruin CloudGitHub

Browse the Academy library.

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

Product

Quick filters

Content type

Stack
Level
Industry
Role
Trackcli

Build an AI Data Analyst

Create a local context layer for your warehouse, connect an AI coding tool through Bruin MCP, and ask SQL-backed business questions.

Bruin CLIBruin AIMCPBigQuery
6 steps - 55 min
Coursecloud

Cloud AI Agent

Create governed Bruin Cloud agents that chat with data, send scheduled reports, and answer questions from browser or Slack.

Bruin CloudBruin AISlack
5 guides - 43 min
Coursecli

Local Pipeline Development

Start with install, first pipeline, core concepts, local projects, and the CLI learning path.

Bruin CLIIDE ExtensionBruin AIDuckDB
4 guides - 83 min
Coursecloud

Bruin Cloud Deployment

Start with connections, projects, pipeline runs, AI agents, dashboards, Slack, and Cloud operations.

Bruin CloudBruin AISlackMCP
3 starter guides - 12 min
Guidecli

Install Bruin

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

Bruin CLIIDE Extension
3 parts - 10 min
Guidecli

Chess Data to DuckDB

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

Bruin CLIDuckDB
1 guide - 8 min
Guidecli

Bruin Core Concepts

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

Bruin CLI
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.

Bruin DACDuckDB
4 steps - 20 min
GuidecliNew

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.

Bruin CLIBruin AIDuckDB
6 steps - 60 min
GuidecliNew

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.

Bruin CLIBruin AIDuckDB
6 steps - 60 min
GuidecliNew

Build an AI Data Analyst

Set up a working AI analyst that understands your warehouse context and answers business questions with SQL.

Bruin CLIBruin AIBruin Cloud
6 steps - 55 min
GuidecloudNew

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.

Bruin CLIBruin CloudBruin AIMCPSalesforce
15 min - video
GuidecloudNew

SEO Optimizer Agent

Build a scheduled AI agent that reads GA4 and GSC data from BigQuery, opens landing-page PRs, measures impact, and reports to Slack.

Bruin CloudBruin AISEOBigQuerySlack
3 steps - 26 min
GuidecloudNew

Growth Marketing

Explore agent workflows for SEO, lifecycle, demand generation, performance marketing, and marketing operations.

Bruin CloudBruin AISEOBigQuerySlack
5 workflows - Self-paced
Guidecloud

Deploy a Slack AI Agent

Sign up for Bruin Cloud, connect your database, configure an AI agent, and answer governed data questions in Slack.

Bruin CloudBruin AISlack
9 steps - 20 min
Guidecloud

AI Data Analyst Onboarding

Follow the Bruin Cloud AI analyst track from connecting data to chats, dashboards, integrations, and scheduled agents.

Bruin CloudBruin AISlack
7 steps - 15 min
Trackcli

Bruin for Work

Browse Academy guides by role across marketing, finance, product, operations, data, and engineering teams.

Bruin CLIBruin CloudBruin AIBigQueryDuckDB
5 role paths - Self-paced
Guidecli

End-to-End Pipeline: NYC Taxi

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

Bruin CLIDuckDBBruin AI
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.

Bruin CLIBruin AIBigQuerydbt
5 steps - 45 min
GuidecliNew

Shopify Data Pipeline

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

Bruin CLIBruin CloudBruin AIClickHouseBigQuery
6 steps - 70 min
Guidecli

Notion to PostgreSQL

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

Bruin CLIPostgres
2 steps - 10 min
Guidecli

Oracle to DuckDB

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

Bruin CLIDuckDB
3 steps - 16 min
Guidecli

Using Bruin Templates

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

Bruin CLIDuckDB
2 steps - 8 min
GuidecloudNew

Build Dashboards with an AI Agent

Use a Bruin Cloud AI agent to scaffold and edit dashboards from natural language - no YAML required.

Bruin CloudBruin AI
5 min - video
Guidecli

IDE Extension

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

Bruin CLIIDE Extension
2 steps - 8 min
Guidecli

Bruin + Python

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

Bruin CLIPython
2 steps - 22 min
Guidecli

Data Engineering Zoomcamp

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

Bruin CLIDuckDB
9 steps - Self-paced
Guidecli

Deploy Bruin with Apache Airflow

Orchestrate Bruin pipelines from Apache Airflow using BashOperator or KubernetesPodOperator, with secure credentials and scheduled DAGs.

Bruin CLIDeploymentAirflow
4 min
Guidecli

Deploy Bruin with AWS ECS

Run Bruin pipelines as ECS Fargate tasks with ECR images, Secrets Manager credentials, EventBridge schedules, and CloudWatch logs.

Bruin CLIDeploymentAWS
4 min
Guidecli

Deploy Bruin with AWS Lambda

Package Bruin in an AWS Lambda container image for short scheduled or event-driven production pipeline runs.

Bruin CLIDeploymentAWS
4 min
Guidecli

Deploy Bruin with GitHub Actions

Run Bruin pipelines from GitHub Actions using repository secrets, scheduled workflows, push triggers, and manual production runs.

Bruin CLIDeploymentCI/CD
4 min
Guidecli

Deploy Bruin with GitLab CI/CD

Run Bruin pipelines from GitLab CI/CD using protected variables, scheduled pipelines, branch triggers, and manual jobs.

Bruin CLIDeploymentCI/CD
4 min
Guidecli

Deploy Bruin with Google Cloud Run Jobs

Run Bruin pipelines as Google Cloud Run Jobs using Artifact Registry, Secret Manager, Cloud Scheduler, and Cloud Logging.

Bruin CLIDeploymentGCP
4 min
Guidecli

Deploy Bruin on Ubuntu with Cron

Install Bruin CLI on an Ubuntu VM, store credentials locally, schedule production pipeline runs with cron, and verify logs.

Bruin CLIDeployment
4 min
Guidecli

Deterministic A/B Test Bucketing

Use stable IDs, salts, SHA-256 parity tests, and BigQuery checks to assign deterministic A/B test variants across SQL, Python, C#, and apps.

Product AnalyticsA/B TestingExperimentationBigQueryPython
7 min
Guidecli

Reliable Firebase A/B Tests Guide

Build reliable Firebase A/B tests with Remote Config proxy parameters, abtest_start events, and BigQuery assignment tables based on device delivery.

Product AnalyticsFirebaseA/B TestingExperimentationBigQuery
6 min
Guidecloud

Chat with an AI Agent

Use Bruin Cloud's chat to ask an AI agent about your data, generate reports, and run Bruin Cloud CLI tasks like pipeline status and history.

Bruin CloudBruin AI
6 min - video
Guidecloud

Configure AI Agents

Create and configure AI agents in Bruin Cloud - pick a project, add messaging integrations, attach a connection set, and set permissions.

Bruin CloudBruin AI
6 min - video
Guidecloud

Schedule an AI Agent

Set up an AI agent to run on a schedule in Bruin Cloud - generate daily reports, post Slack alerts, and trigger custom SQL queries.

Bruin CloudBruin AI
6 min - video
Guidecloud

Create a Project

Connect a GitHub repo to Bruin Cloud, create your first project, and add the connections it needs.

Bruin Cloud
4 min - video
Guidecloud

Manage Connections

Configure connections in Bruin Cloud so your pipelines can reach data sources, destinations, and other external systems.

Bruin Cloud
4 min - video
Guidecloud

Migrate a Project to the Bruin GitHub App

Move an existing Bruin project from a GitHub personal access token to the Bruin GitHub App in less than a minute, directly from Team Settings.

Bruin CloudGitHub
2 min
Guidecloud

Enable a Pipeline

Enable a pipeline in Bruin Cloud, add any missing connections, and trigger the first run.

Bruin Cloud
4 min - video
Guidecloud

Pipelines Overview

A walkthrough of the Bruin Cloud pipeline page: runs, assets, backfills, lineage, connections, and manual runs.

Bruin Cloud
5 min - video
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.

Bruin CLIPythoningestr
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.

Bruin CLIPythonBigQueryPostgresDuckDB
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.

Bruin CLIPythonBigQueryPostgresDuckDB
10 min
Guidecloud

Build Dashboards with an AI Agent

Use the Bruin Cloud AI agent to build interactive dashboards from natural language prompts - generate queries, create charts, and ask follow-up questions in one place.

Bruin CloudBruin AI
3 min - video
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.

Bruin CLIBigQueryMCPFinance
15 min - video
Guidecloud

Connect a Slack AI Analyst to the Stock Market

Build a stock market AI analyst, deploy it to Bruin Cloud, and connect it to Slack so your team can ask data questions in natural language. <a href="https://join.slack.com/t/bruindatacommunity/shared_invite/zt-3rt3616ba-tUTTZWNZoVjB_QSSleDxAg" target="_blank" rel="noopener noreferrer">Join our Slack and try out the agent for free</a>.

Bruin CloudSlackBruin CLIFinance
20 min - video
Guidecloud

Connect Bruin Cloud MCP to Claude Code

Set up the Bruin Cloud MCP so your AI agent can query pipelines, inspect runs, and trigger actions in Bruin Cloud directly from your terminal.

Bruin CloudBruin AIMCP
5 min - video
Guidecloud

Deploy an AI Analyst to Bruin Cloud & Slack

Build a stock market AI analyst in Bruin Cloud and connect it to a Slack AI agent so your team can query data from any channel.

Bruin CloudSlackBruin CLI
20 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.

Bruin CLIBruin AIMCP
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
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.

Bruin CLIIDE Extension
2 min - video

Run Bruin in production with Cloud or your own scheduler.

Bruin Cloud is the managed default for projects, private connections, scheduled runs, catalog, lineage, governed AI agents, and Slack or Teams delivery. Self-managed teams can also run Bruin CLI from CI, cron, serverless jobs, containers, or Airflow.

Deployment mode

Bruin Cloud

Managed production in Bruin Cloud

Use Bruin Cloud when you want managed projects, encrypted connections, scheduling, catalog, lineage, access controls, and governed AI agent delivery in one place.

Self-managed deployment

Run Bruin CLI from your own scheduler

Use these guides when your team owns orchestration in CI/CD, cron, serverless jobs, containers, or Airflow while keeping pipeline logic in Bruin projects.

Sign up to our newsletter

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