Hey,
I faced with the issue that GrowthBook gener...
# ask-questionss
shy-kangaroo-23950
10/20/2023, 8:26 AMHey,
I faced with the issue that GrowthBook generates wrong database name concatenating project ID twice in an experiment results. Example:
Copy code
SELECT ... FROM `project-id`.`project-id.dataset-id`Invalid project IDshy-kangaroo-23950
10/20/2023, 9:34 AMIs there any suggestions how to fix that?
o
orange-intern-17043
10/20/2023, 3:32 PMHi Evgenij. I have the same issue
orange-intern-17043
10/20/2023, 3:34 PM@fresh-football-47124 Can you take a look please? We cant get our experiment results from BQ because of that issue
f
fresh-football-47124
10/20/2023, 5:07 PM
Hi - when you first enter the project id and data set id, we create the default queries for you. While you can update that info (by clicking edit connection from the data source page), it will not regenerate existing queries. You can edit any of the queries manually to fix the project ids that might be wrong
o
orange-intern-17043
10/20/2023, 5:54 PM@fresh-football-47124 I think problem only with query in this experiment update function. Everywhere else connection looks good. Please take a look at this screen record: https://somup.com/c06YbMBJUd
f
future-teacher-7046
10/20/2023, 7:49 PM
You might have to edit the "Experiment Assignment" queries in the data source setting to remove the duplicate project id.
o
orange-intern-17043
10/20/2023, 7:55 PMI ddi that and in experiment update function it started to work
But now its giving me error on Experiment Assignment query and I cant get it back as it was
orange-intern-17043
10/20/2023, 7:56 PM@future-teacher-7046
orange-intern-17043
10/23/2023, 10:25 AMIt actually worked @future-teacher-7046
Thank you for the tip! With this final issue solved we upgraded to Pro version! It will be great if someone can make a demo for us to show all the features of the platform. But so far I’m so excited to use it
68 Views