This message was deleted.
# ask-questions
w
This message was deleted.
f
Hi Andrey - so that query is defined in the assignment query on the data source page
Looks like "event_properties:experiment_id" is incorrect
c
Thanks Graham, you are right!
Hi @fresh-football-47124, could you help me here please?
Copy code
No matching signature for operator = for argument types: JSON, STRING. Supported signature: ANY = ANY at [30:7]
Copy code
WHERE
17      event_type = 'Experiment Viewed'
18      AND amplitude_id is not null
19  ),
20  __experimentExposures AS (
21    -- Viewed Experiment
22    SELECT
23      e.device_id as device_id,
24      cast(e.variation_id as string) as variation,
25      CAST(e.timestamp as DATETIME) as timestamp,
26      e.device AS dim_device
27    FROM
28      __rawExperiment e
29    WHERE
30      e.experiment_id = 'connect-device-yellow-button'
31      AND e.timestamp >= '2023-12-20 14:50:00'
32      AND e.timestamp <= '2023-12-27 12:38:32'
33  ),
34  __experimentUnits AS (
the issue is fixed
👍 1
132 Views