Amazon Redshift

{{ config(
    materialized='table',
    dist='key',
    dist_key='customer_id',  -- Collocate with dim_customers
    sort=['order_date', 'customer_id'],
    sort_type='compound'  -- or 'interleaved'
) }}

select
    order_id,
    customer_id,
    order_date,
    total_amount
from {{ source('raw', 'orders') }}

{{ config(
    materialized='view',
    bind=false  -- Late binding view
) }}

-- Query external Spectrum table
select
    event_date,
    user_id,
    event_type
from spectrum_schema.raw_events
where event_date >= current_date - 7

{{ config(
    materialized='incremental',
    unique_key='event_id',
    incremental_strategy='delete+insert',
    dist='user_id',
    sort='event_timestamp'
) }}

select
    event_id,
    user_id,
    event_timestamp,
    event_data
from {{ source('raw', 'events') }}

{% if is_incremental() %}
where event_timestamp > (
    select max(event_timestamp) from {{ this }}
)
{% endif %}