-- Slowly-changing customer attributes, so a historical metric can be -- recomputed against what a customer's segment WAS, not what it is now. {% snapshot snap_customers %} {{ config( target_schema='snapshots', unique_key='customer_id', strategy='check', check_cols=['segment', 'country_code'], invalidate_hard_deletes=True ) }} select customer_id, tenant_id, customer_name, segment, country_code from {{ ref('stg_customers') }} {% endsnapshot %}