Hello I have added my existing mysql as data sourc...
# ask-questionsd
damp-angle-95696
10/29/2021, 9:33 AMHello 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_viewedf
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.
future-teacher-7046
10/29/2021, 9:48 AM
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 🙏
67 Views