Write the model

A staging model is one SELECT from the raw model: explicit columns, light cleaning, renames to conventions. Here is the worked example — every choice in it is deliberate, and each explanation sits on the line it belongs to. Tap the numbers, then write yours:

select

    organisation_code,

    upper(trim(site_code)) as site_code,

    day_of_week,

    opens_at::time as opens_at,
    closes_at::time as closes_at,

    is_open_24h::boolean as is_open_24h

from {{ ref('raw_reference_opening_hours') }}