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

abundant-air-78515

12/06/2023, 9:33 AM
Hi! We have connected Big query and have europe-north as setting, but we get this error in Growthbook:
r

rhythmic-agent-34208

12/06/2023, 9:33 AM
Our official support hours are 6:30am - 5pm Pacific Time, Monday through Friday. You may occasionally hear from us outside of these hours. Your support request has been logged in our system. Our support team will get back to you very soon!
b

billions-xylophone-11752

12/06/2023, 12:13 PM
Hey Samuel - sorry to hear you're having trouble. That error can be for a number of reasons, typically due to an error in the query itself (e.g. trying to access a dataset that doesn't exist within a project) or a permission issue. Can you go to the Data Source in GrowthBook, and click on the "View Schema Browser" button at the top of the page, and confirm that the
prod_public
dataset exists within the
demando-data
project? And lastly, I was able to replicate this error message when I attempted to access a table that didn't exist within a EU hosted dataset. To check this, you can go to one of the metrics in question (maybe
company-active-no (count)
and you can test the query there. And on the right-hand side of the page, you should see our Schema Browser, where you can see what tables are available. If neither of those issues above are your issues, let me know and we can debug further.
a

abundant-air-78515

12/06/2023, 6:15 PM
Thanks alot for your answer and, i have tested the queries in metrics and it works.
So idont think the problem is connected to a schema the dont exist or something with the query
Do you have any other tip?
b

billions-xylophone-11752

12/06/2023, 6:25 PM
Hmm - So you're able to see the Schema Browser, and the individual metric queries run successfully? It's possible the
Experiment Assignment Queries
need to be updated. Can you go to the Data Source page again and open one of the queries and test the query? You can get there by clicking the "Customize SQL" and then you'll see the option to test the query.
a

abundant-air-78515

12/06/2023, 6:27 PM
thanks here i got,
could that be the problem
Can you please help me , this sql returns empty becuase i dont have any with AND event_name = ‘experiment_viewed’ AND experiment_id_param.key = ‘experiment_id’ AND variation_id_param.key = ‘variation_id’
in my analytics data ,
it seem like the problem still exist
b

billions-xylophone-11752

12/07/2023, 7:34 PM
Hey, Samuel - have you started this experiment yet? Looking at the screenshot, it looks like it hasn't been launched yet.
a

abundant-air-78515

12/07/2023, 7:35 PM
iam not running it
i havent run it
i get it when i run update
b

billions-xylophone-11752

12/07/2023, 7:38 PM
Got it. So if the experiment hasn't been launched, it makes sense that there wouldn't be any rows returned for that query. When a user is added to the experiment and bucketed into a variation, that's when the SDK calls the
trackingCallback
, and where your app sends that info to BigQuery.
I'm trying to figure out if that could be the cause of the error message (the
not found in location EU
). Its possible that error message could just be a red herring.
a

abundant-air-78515

12/07/2023, 8:10 PM
okey thanks we try to start it
Hi! i could start the experiment but something seems wrong
We started it for a few days ago
Can you help?
it seems like our metrics work
b

billions-xylophone-11752

12/11/2023, 2:43 PM
Hi, Samuel - sorry that you're still having trouble. Can you click the "update" button in the screenshot attached and let me know if/what the errors are?

https://files.slack.com/files-pri/T01TK60DLAV-F069B3P82Q6/screenshot_2023-12-11_at_08.23.24.png

a

abundant-air-78515

12/11/2023, 4:11 PM
Thanks, i dont get any error
it just says no data
b

billions-xylophone-11752

12/11/2023, 4:28 PM
Gotcha. Well that's good - it seems like we're passed the
not found in EU
error. So when a user is added to an experiment and assigned a variation, that's when the SDK fires the
trackingCallback
. Have you customized what the
trackingCallback
, so it actually updates your BigQuery database with information on which users saw which variation? E.G.
Copy code
// Create a GrowthBook instance
const growthbook = new GrowthBook({
  trackingCallback: (experiment, result) => {
    // This is where you need to update the code to push the results to BigQuery.
  },
});
a

abundant-air-78515

12/12/2023, 9:52 AM
Thanks! i check with my techteam and get back
4 Views