📊 dbt가 잘하는 일 vs Python이 잘하는 일

-- dbt에서는 이런 로직이 아주 힘들다...
SELECT
  CASE 
    WHEN user.age BETWEEN policy.min_age AND policy.max_age THEN 30
    ELSE 0
  END +
  CASE 
    WHEN user.income < policy.income_ceiling THEN 25
    ELSE 0
  END + ...

{
  "policy_name": "청년 월세 지원",
  "eligibility": "만 19세 이상 34세 이하 / 무직 또는 재직 / 독립가구",
  "target_region": "전국",
  "link": "https://example.com"
}

SELECT * FROM {{ source('raw', 'policies') }}

SELECT
  policy_name,
  REGEXP_EXTRACT(eligibility, '만 (\d{2})세 이상')::INT AS min_age,
  REGEXP_EXTRACT(eligibility, '(\d{2})세 이하')::INT AS max_age,
  CASE
    WHEN eligibility LIKE '%무직%' AND eligibility LIKE '%재직%' THEN '무직,재직'
    WHEN eligibility LIKE '%무직%' THEN '무직'
    WHEN eligibility LIKE '%재직%' THEN '재직'
    ELSE '무관'
  END AS job_status,
  CASE
    WHEN eligibility LIKE '%독립가구%' THEN '독립가구'
    ELSE '무관'
  END AS household_type,
  target_region,
  link
FROM {{ source('raw', 'policies') }}

SELECT
  policy_name,
  min_age,
  max_age,
  job_status,
  household_type,
  target_region,
  link
FROM {{ ref('stg_policies') }}
WHERE min_age IS NOT NULL AND max_age IS NOT NULL