This message was deleted.

Here is the actual SQL Query that you get when creating the metric:

SELECT
  user_id,
  $amplitude_id as anonymous_id,
  event_time as timestamp
FROM
  $events
WHERE
  event_type = 'Doctor List'

Hi Gabriel- it might be easier to help you debug this in person

I think our aws athena setup is wrong which isn't surprising since it's the first time we use it 😅 we'll see if we manage to make it work