Change Details

The [[ https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/blob/a837f18603009f4f2145767d54d05f2a33dffba7/growthbook/experiment_assignment_query_iceberg.hql | query ]] which populates `wmf_experiments.experiment_assignment_v1` includes a commented out filter in its `WHERE` clause: ```lang=sql 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. ## Prerequisites [ ] Reader Growth's [[ https://test-kitchen.wikimedia.org/experiment/mobile-toc-abc2 | Mobile Table of Contents A/B/C test ]] has completed (ETA 2026-04-12) ## Acceptance criteria [ ] Query is updated to use `action = 'experiment_exposure'` events only. [ ] Airflow DAG is updated to use the new query URI

The [[ https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/blob/a837f18603009f4f2145767d54d05f2a33dffba7/growthbook/experiment_assignment_query_iceberg.hql | query ]] which populates `wmf_experiments.experiment_assignment_v1` includes a commented out filter in its `WHERE` clause: ```lang=sql 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 [x] Query is updated to use `action = 'experiment_exposure'` events only. [ ] Airflow DAG is updated to use the new query URI

The [[ https://gitlab.wikimedia.org/repos/product-analytics/data-pipelines/-/blob/a837f18603009f4f2145767d54d05f2a33dffba7/growthbook/experiment_assignment_query_iceberg.hql | query ]] which populates `wmf_experiments.experiment_assignment_v1` includes a commented out filter in its `WHERE` clause: ```lang=sql 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. ## Prerequisites [ ] Reader Growth's [[ https://test-kitchen.wikimedia.org/experiment/mobile-toc-abc2 | Mobile Table of Contents A/B/C test ]] has completed (ETA 2026-04-12) ## Acceptance criteria [ x] Query is updated to use `action = 'experiment_exposure'` events only. [ ] Airflow DAG is updated to use the new query URI