Hello I have added my existing mysql as data source, should I create a table with the expected fields, like the sample below? Otherwise, how do I edit experiments query?
Copy code
SELECT
user_id,
anonymous_id,
received_at as timestamp,
experiment_id,
variation_id
FROM
experiment_viewed
f
future-teacher-7046
10/29/2021, 9:45 AM
If you go to settings->data sources and click on your data source you should be able to edit the query settings and put in your own SQL.
If you already have a similar table in MySQL no need to create a new one. Just update the query and use aliases to convert the column names to what is expected (like "received_at as timestamp" is doing in the example)
d
damp-angle-95696
10/29/2021, 10:00 AM
@future-teacher-7046 Thanks for your quick answer. Really helpful 🙏