Hi there, I appreciate your response.
I’ve created...
# ask-questionsc
cuddly-chef-71648
12/22/2023, 12:01 PMHi 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 payingf
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
fresh-football-47124
12/22/2023, 5:03 PM
Looks like "event_properties:experiment_id" is incorrect
c
cuddly-chef-71648
12/22/2023, 9:30 PMThanks Graham, you are right!
cuddly-chef-71648
12/27/2023, 12:44 PMHi @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 (cuddly-chef-71648
12/28/2023, 12:14 PMthe issue is fixed
👍 1
23 Views