https://www.growthbook.io/ logo
Join Slack
Powered by
Hello gb team. I have connected my big query data ...
# announcements
i
Hello gb team. I have connected my big query data source with growthbook. When I am creating my test metric. It is showing me the error 
Table "test" must be qualified with a dataset (e.g. dataset.table).
f
Hi Komal - what is your query?
i
WITH __table as ( SELECT user_id as user_id, timestamp as timestamp FROM test ) SELECT * FROM __table LIMIT 1
f
if you run that on BigQuery, does it work?
i
https://docs.growthbook.io/guide/bigquery I have fllowed the steps provided in documentation to create a datasource.
f
okay
i
After that, there is this error in metrics
f
what data do you have in bigQuery? what event tracker are you using (if any)?
i
no
f
what are you trying to AB test? is it a website?
i
yes, I am trying to implement it in a website.
f
do you have any event tracking currently?
i
I have only created one a/b experiment test feature
b
that error from bigquery means the table name inside the query need to be prefix-ed with the dataset. e.g. <dataset_name>.<table_name>. I see in your query you don’t have the dataset in front of 
test
. Try adding the dataset and see if it works?
i
ok
f
it might be that Komal doesn’t have any data there yet
i
So, how can I populate the data of experiments there?
f
GrowthBook works a bit differnetly than other ab testing systems - we connect to your data warehouse and use almost any event tracking system
so you can use something like Google Analytics 4 to do web analytics, and push that data to BigQuery
i
I have tried that as well. But doesn't seem working with me Maybe I am missing any step somewhere. So what I have done is I have created a button in my UI where I am changing its label using a/b testing. I want to count how many users are clicking the button on which label. For that may I know the steps. How to do it from data source to creating metrics to creating experiment to analyse it.
f
just to clarify - “I have tried that as well” - tried what? GA4?
i
yes
f
GA4 steps roughly: 1. Make sure Google Analytics is tracking click events on your button 2. Add the GrowthBook SDK - when you set the Attributes in the SDK, make sure you pass in the clientId from Google (https://developers.google.com/tag-platform/gtagjs/reference?hl=en#set_examples) 3. Make sure your A/B test is set to split based on this clientId attribute
b
Having the same issue as this.
f
Hi Mark, want to make a new thread? This one is very old
and wasn’t very specific
b
Oh no worries. Sorry, I wasn't able to reply. I was able to solve this. I did not know before that I have to change something in the SQL query of the data source.
70 Views
Open in Slack
PreviousNext
Powered by