← duckrun docs

multi-lakehouse — one dbt project, three Lakehousesdbt

Actual local run · one dbt project, a Bronze/Silver/Gold medallion across three Lakehouses · 2026-07-02 UTC. Extra write roots are declared once as named catalogs: in the profile; a model picks one with the standard dbt +database: <alias>. ref() and joins resolve across Lakehouses.

outputs:
  dev:
    type: duckrun
    root_path: "<Silver lakehouse>"      # the default catalog
    catalogs:
      lh_bronze: { root_path: "<Bronze lakehouse>" }
      lh_gold:   { root_path: "<Gold lakehouse>" }

Bronze — lh_bronze.main.raw_generation

…/mcd/bronze · {{ config(materialized=…, database='lh_bronze') }}

gen_date	duid	fuel	mw
2024-01-01	BW01	Black coal	500.0
2024-01-01	WIND1	Wind	200.0
2024-01-01	GAS1	Natural gas	300.0

Silver — (default).main.clean_generation

…/mcd/silver · {{ config(materialized=…) }}

gen_date	duid	fuel	mw	est_tonnes_co2
2024-01-01	BW01	Black coal	500.0	450.0
2024-01-01	WIND1	Wind	200.0	0.0
2024-01-01	GAS1	Natural gas	300.0	147.0

Gold — lh_gold.main.generation_by_fuel

…/mcd/gold · {{ config(materialized=…, database='lh_gold') }}

fuel	total_mw	total_tonnes_co2
Black coal	500.0	450.0
Natural gas	300.0	147.0
Wind	200.0	0.0