Templates

Bruin templates are ready-to-edit pipeline blueprints. They scaffold the folder structure, pipeline.yml, starter assets, and example connection configuration for common use cases.

Use this page as a catalog: pick a category, scan the template cards, then initialize the matching template with bruin init.

Start from a template

Run the interactive wizard when you want to browse templates from the CLI:

bruin init

You can also initialize a template directly:

bruin init [template-name] [folder-name]

Arguments:

• template-name: The template to use. If omitted, Bruin uses the default template.
• folder-name: The folder to create. If omitted, Bruin uses bruin-pipeline for the default template and the template name for other templates.

To see the complete list available in your installed Bruin version:

bruin init --help

Template catalog

These bundled templates are grouped by the job they help you start. Use the docs search for template names, sources, warehouses, or tags such as DuckDB, Snowflake, Shopify, Python, or demo.

AI agent skills are installed separately with bruin ai skills; see AI Skills.

Analytics demos

Business analyticsecommerceInteractive ecommerce pipeline with selected raw sources, staging models, and revenue, customer, product, marketing, and KPI reports.ShopifyStripeKlaviyoGA4Demo pipelinedemo-snowflake-sales-analyticsGenerated retail sales data in Snowflake with bronze, silver, and gold models for SKU and channel decisions.SnowflakePythongold modelsDemo pipelinedemo-snowflake-salesforceSeeds Salesforce CRM demo data, ingests it into Snowflake, and builds relationship, lending, and marketing analytics.SalesforceSnowflakeCRMAgent test pipelineself-heal-demoLocal DuckDB project with separate seed and demo pipelines for realistic duplicate, freshness, schema drift, and quality failures.DuckDBAI agentsdata quality

Local and learning templates

Local SQLduckdbSmall DuckDB pipeline with SQL assets, seed data, macros, materialization, and quality checks.DuckDBSQLseedPython assetspythonShows isolated Python assets using multiple Python versions and dependency files.Python 3.11Python 3.12Python 3.13Source examplechessCopies chess game and profile data into DuckDB, then builds a player summary SQL model.ChessDuckDBingestrCredential-free sourcefrankfurterPulls foreign exchange rates into DuckDB and builds cleaned rates plus currency performance insights.FrankfurterDuckDBFX

Warehouses and databases

Warehouse SQLathenaAmazon Athena SQL assets for sample cars, drivers, payments, and travellers data.AthenaAWSSQLWarehouse SQLclickhouseClickHouse SQL pipeline with a sample table and schema checks.ClickHouseSQLchecksLayered ELTbronze-silver-postgresIngests Frankfurter rates into PostgreSQL, then builds a curated silver summary model with checks.Postgresbronzesilver

Source-to-warehouse ingestion

Commerce sourceshopify-bigqueryCopies Shopify data into BigQuery and includes a starter transformation asset.ShopifyBigQueryingestrCommerce sourceshopify-duckdbCopies Shopify data into DuckDB for local ecommerce exploration.ShopifyDuckDBingestrSpreadsheet sourcegsheet-bigqueryCopies Google Sheets data into BigQuery with a simple source asset.Google SheetsBigQuerySpreadsheet sourcegsheet-duckdbCopies Google Sheets data into DuckDB for a local spreadsheet ingestion workflow.Google SheetsDuckDBWorkspace sourcenotionCopies a Notion database into BigQuery, then runs a starter SQL model.NotionBigQueryingestrSupport sourcegorgiasCopies Gorgias customers, tickets, messages, and satisfaction surveys into BigQuery.GorgiasBigQuerysupportProduct analyticsfirebaseBuilds BigQuery assets for Firebase Analytics events, parameters, users, and cohorts.FirebaseBigQueryevents

Other bundled templates

Bruin also ships smaller starter templates and specialized examples that may not have full walkthrough pages yet.

Template	Use when you want to start with
default	The standard Bruin starter project.
empty	A minimal pipeline with almost no scaffolding.
bigquery	A BigQuery SQL starter with seed data and macros.
databricks	A Databricks SQL starter.
redshift	A Redshift SQL starter.
oracle-duckdb	Oracle source assets with a DuckDB transformation.
stripe-databricks	Stripe ingestion into Databricks with bronze and silver layers.
nyc-taxi	A local NYC taxi example with ingestion, lookup data, staging, and reports.
bruin-cloud	Bruin Cloud metadata ingestion and summary examples.
r	R assets, including an example with dependencies.
variant-example	A runnable project showing pipeline variants.
duckdb-lineage	A DuckDB example focused on lineage.
bootstrap	A small bootstrap example with seed data.
zoomcamp	The Data Engineering Zoomcamp-inspired pipeline example.

Initialize any of these by name:

bruin init nyc-taxi my-taxi-pipeline

Choosing a template

Goal	Start with
Learn Bruin locally without cloud credentials	duckdb, python, frankfurter, or chess
Build a source-to-warehouse ingestion pipeline	shopify-bigquery, gsheet-bigquery, notion, or gorgias
Explore a complete demo with generated data	demo-snowflake-sales-analytics or demo-snowflake-salesforce
Scaffold ecommerce reporting	ecommerce
Work with a specific database	athena, clickhouse, bronze-silver-postgres, bigquery, databricks, or redshift

Most templates include placeholder connection values only. Replace the generated .bruin.yml values before running the pipeline.