dbt_flow_simple_orders_example_postgres.sql

{{
    config(
        materialized='incremental'
    )
}}


with orders as (
  select * from {{ ref('stg__orders') }}
),

payments as (
  select * from {{ ref('int_payments_mapped') }}
),

orders_payments as (
  select
    orders.order_id,
    orders.customer_id,
    order_date,
    status,
    payment_method_name,
    amount
  from payments
  inner join orders on
    payments.order_id = orders.order_id

  {% if is_incremental() %}

    where order_date > (select max(order_date) from {{ this }} )

  {% endif %}
)


select * from orders_payments