https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
c

cuddly-chef-71648

12/22/2023, 12:01 PM
Hi there, I appreciate your response. I’ve created an experiment and added metric from Amplitude. When I try to run query of experiment, I get the following error Syntax error: Expected “)” but got “:” at [10:19]
Copy code
-- connect device pressed (binomial)
2    WITH
3      
4      
5    
6    __rawExperiment AS (
7      SELECT
8  amplitude_id as anonymous_id,
9  event_time as timestamp,
10  event_properties:experiment_id as experiment_id,
11  event_properties:variation_id as variation_id,
12  device_family as device,
13  os_name as os,
14  country,
15  paying
Could you please help me?
f

fresh-football-47124

12/22/2023, 5:02 PM
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

cuddly-chef-71648

12/22/2023, 9:30 PM
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
4 Views