Hey! I am trying to make a simple GrowthBook metrics analysis but I get some errors. We are using Amplitude as our product analysis platform so I had to export our data to AWS Athena (I am not even sure if we did this right but GrowthBook seems to think it is?). Anyway, I just create a metric, "Doctor List", which is supposed to get all the "Doctor List" events that already exist, but when I try to analyse this metric by clicking on "Run analysis" I get the following error: line 14
11 mismatched input '$'. Expecting: '*', <expression>. The SQL query that GrowthBook is generating is:
-- Last 90 days - Doctor List Metric
WITH
__metric as ( -- Metric (Doctor List)
SELECT
anonymous_id as anonymous_id,
1 as value,
m.timestamp as timestamp,
m.timestamp as conversion_start,
m.timestamp as conversion_end
FROM
(
SELECT
user_id,
$ amplitude_id as anonymous_id,
event_time as timestamp
FROM
$ events
WHERE
event_type = 'Doctor List'
) m
WHERE
m.timestamp >= from_iso8601_timestamp('2023-01-12T23:11:24.843Z')
AND m.timestamp <= from_iso8601_timestamp('2023-04-16T23:11:24.843Z')
),
.......
Line 14 (where the error is) is basically this:
$ amplitude_id as anonymous_id,
