Hi folks. I may be missing something here but in the Growthbook dashboard i have a BigQuery data source with the data set correctly named. However, when I set up an experiment (via a feature) to use this data source, the SQL query fails because it using the default 'my_dataset' as the data set, and not the value specified. I can't see how to edit the query or get it to use the correct value. I think the dataset was left blank during setup but it says it can be changed. Thanks for any advice.
09/28/2023, 3:09 PM
Hey Tom! Yea, if we don't know the default data set at the time of creating the data source, the default query won't be 100% correct.
To change this, you can go to the data source in your account, and then go to the "Experiment Assignment Queries" section. There you can edit the SQL Query to replace
with the actual dataset where the experiment assignments are stored.