hi! I'm testing growthbook and trying to connect t...
# ask-questionsw
worried-businessperson-32427
11/02/2023, 4:40 PMhi! I'm testing growthbook and trying to connect to big query but no tables are being created in the dataset
r
rhythmic-agent-34208
11/02/2023, 4:40 PM@worried-businessperson-32427 has opened an issue Close Issue button
b
brief-honey-45610
11/02/2023, 5:02 PMHello, Dario, thanks for reaching out!
Could you please send me a screenshot of your configuration in the GrowthBook dashboard?
brief-honey-45610
11/02/2023, 6:16 PMimage (1).png
brief-honey-45610
11/02/2023, 6:17 PMFrom Dario via DM:
the dataset "growthbook" is created
I see an error in the experiment result section as follows "Not found: Table destinia-243f3:growthbook.viewed_experiment was not found in location europe-west9"
obviously the table viewed_experiment doesn't exists 🙂
r
rhythmic-agent-34208
11/03/2023, 12:53 AMHi Dario,
We don't create tables for most users. Your event tracker will create tables in the dataset, which depends a little bit on what event tracker (e.g. GA4, Segment) that you're using.
That table not found error has two normal issues:
1. You actually don't have that table in your BigQuery. This could be because:
Your experiment assignment query isn't properly configured (pointing to the wrong table) or the table doesn't exist.
You'd need to find the table where you are logging experiment assignment events to using your event tracker and you need to ensure that your assignment query on the Data Source page is pointing to that table.
2. Another cause is that sometimes the permissions or the location of the project and where we execute queries is different from where the data are (e.g. us-west-1 vs europe-west-9).
Could you please check those 2 things nd let me know what you find?
w
worried-businessperson-32427
11/03/2023, 9:00 AMI didn't create any table and I'm not using any other experiment tracking software. Do you have any table strcuture recomendation or should the user choose on their own?
worried-businessperson-32427
11/03/2023, 10:48 AMI manage to create the table in Big query and now I don't have any error but I'm not sure it's working. I'm running an experiment and there is not information inserted in the table.
worried-businessperson-32427
11/03/2023, 1:40 PMI'm trying to fire an experiment with runInlineExperiment and it doesn't (feature is ON and experiment is running) when getting experiments using "$growthbook->getViewedExperiments();" I receive an empty array. Is something else I'm missing?
r
rhythmic-agent-34208
11/03/2023, 3:42 PMHi Dario, thanks for the updates here. I'll take a look today and reply with an update as soon as I can.
w
worried-businessperson-32427
11/03/2023, 4:06 PM👍 thanks!
worried-businessperson-32427
11/03/2023, 4:06 PMsorry for the huge text 😕 the main issue right now is that the event is not firing
89 Views