https://www.growthbook.io/ logo
#ask-questions
Title
# ask-questions
b

billowy-lizard-55653

09/28/2023, 2:28 PM
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.
b

billions-xylophone-11752

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
my_dataset
with the actual dataset where the experiment assignments are stored.
b

billowy-lizard-55653

09/28/2023, 3:23 PM
Aha brilliant, thank you!!
2 Views