Turn repeated SQL into a dbt macro

The same currency-conversion CASE statement is pasted into six models, and I just fixed a bug in one copy without touching the other five.

Beginner to intermediateRead 5 minDoing: an afternoon6 steps

What you'll have at the end

One dbt macro every model calls, with the six pasted copies of the same SQL deleted

Before you start

You need

A dbt project where the same currency-conversion CASE block is already pasted into more than one model.

Not covered

Swapping the fixed conversion rates baked into the CASE block for a live rates table that updates on a schedule.

Leans on

6 steps

Writing a custom dbt test

go there if you want a test that fails automatically when the macro's output drifts, instead of re-running the audit compare by hand every time.

Checked 25 Aug 2026