Bruin CLI Step 2 of 3

Oracle to DuckDB

Guide overview
  1. Set Up Oracle with Docker8 min
  2. 2Initialize & Configure4 min
  3. 3Run Pipeline & Verify4 min
PreviousSet Up Oracle with DockerNextRun Pipeline & Verify

1) Initialize the project

bruin init command

Create a new project from the oracle-duckdb template:

bruin init oracle-duckdb oracle-demo
cd oracle-demo

This creates a project with:

oracle-demo/
├── assets/
│   ├── customers.asset.yml       # ingestr: Oracle → DuckDB
│   ├── orders.asset.yml          # ingestr: Oracle → DuckDB
│   ├── order_items.asset.yml     # ingestr: Oracle → DuckDB
│   └── sales_per_customer.sql    # SQL transformation in DuckDB
├── .bruin.yml
└── pipeline.yml

Sign up to our newsletter

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