The query which populates wmf_experiments.experiment_assignment_v1 includes a commented out filter in its WHERE clause:

WHERE timestamp >= to_timestamp('${date_hour}')
  AND timestamp < to_timestamp('${date_hour}') + INTERVAL 1 HOUR
  -- AND action = 'experiment_exposure' -- Uncomment after experiments start logging exposure (cf. T411677)
  AND action != 'tick' -- Remove once we're filtering to experiment exposure events only

Until we make the switchover, we will continue to treat all events collected from experiments as exposure events, which negatively impacts GrowthBook's performance. Switching over will reduce the volume of data that is scanned any time an experiment is re-analyzed.

Acceptance criteria

• Query is updated to use action = 'experiment_exposure' events only.
• Airflow DAG is updated to use the new query URI