Intermediate dbt
Mike Metzger
Data Engineer
{{ source() }}
function{{ ref() }}
functionselect *
from
{{ source('raw', 'orders') }}
models/model_properties.yml
sources:
section- name:
option- name:
option under tables:
version: 2
sources:
- name: raw
tables:
- name: phone_orders
- name: web_orders
{{ source() }}
{{ source(source_name, table_name) }}
select * from
{{ source('raw', 'phone_orders') }}
UNION
select * from
{{ source('raw', 'web_orders') }}
-- dbt compiled
select * from
'raw'.'phone_orders'
UNION
select * from
'raw'.'web_orders'
sources:
section instead of models:
version: 2
sources:
- name: raw
tables:
- name: phone_orders
columns:
- name: id
tests:
- not_null
- unique
- name: web_orders
Intermediate dbt