https://www.growthbook.io/
Join Slack
Hello gb team. I have connected my big query data source with growthbook. When I am creating my test...
# 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.
69 Views
Open in Slack
PreviousNext
Powered by

GrowthBook Users

Open source platform for stress free deployments, measured impact, and smarter decisions.

Powered by