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

ripe-yak-30943

10/27/2023, 7:45 PM
Hi there! Who can I message about a potential bug / problem with the data source metric query?
1
r

rhythmic-agent-34208

10/27/2023, 7:45 PM
@blue-sundown-32899 has marked the issue as closed. Reopen Issue button
h

helpful-application-7107

10/27/2023, 7:48 PM
You can open a github issue or you can just drop it in here and we can take a look!
r

ripe-yak-30943

10/27/2023, 7:49 PM
I'm getting this error when adding a metric for an experiment:
Copy code
Access Denied: Table zoocasa-growthbook-ga4:my_dataset.events_*: User does not have permission to query table zoocasa-growthbook-ga4:my_dataset.events_*, or perhaps it does not exist in location us-east1.
I've updated my data source to a new project and it has read my dataset, but the query for grabbing metrics is still using the old data source data.
h

helpful-application-7107

10/27/2023, 7:52 PM
Have you updated the Datasource for the experiment?
r

ripe-yak-30943

10/27/2023, 7:58 PM
ok what i did to fix it was to create another data source and then switch the experiments source like you mentioned above.
h

helpful-application-7107

10/27/2023, 7:58 PM
Then the metrics should only exist within that new datasource
You should only be able to add metrics to an experiment if the experimetn and the metrics are coming from the same datasource
r

ripe-yak-30943

10/27/2023, 8:00 PM
yea, the issue is that when i edited my data source (after my dataset finally came through in bigquery) the metrics started showing up, but the query project_name.data_set.events_* stayed the same
h

helpful-application-7107

10/27/2023, 8:00 PM
Hmmm, I'm not sure how exactly to fix that automatically, other than to say that you can go to each of the metrics in your new datasource and update the queries to point to the right BQ location
r

ripe-yak-30943

10/27/2023, 8:01 PM
yea its alright, just an edge case i guess. but creating a new data source fixed it. thanks!
by the way is there an easy way to delete all the metrics i imported to my old datasource. i have 298 of them 😕 bc i need to delete them before i can delete the source
h

helpful-application-7107

10/27/2023, 8:53 PM
Ah, I see.
Yeah that's a known problem with our UX: https://github.com/growthbook/growthbook/issues/150
💯 1
3 Views