{{
  config(
    materialized = 'view',
    schema = 'raw'
  )
}}

SELECT
    dt AS signup_date,
    'Web' AS platform,
    media_source,
    country_code,
    event_name
FROM {{ source('suno_prod', 'af_website_events') }}
WHERE dt >= '2025-02-01'  -- TODO(FY): variable here
    AND dt < CURRENT_DATE()
    AND event_name = 'af_complete_registration'
