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

echoing-advantage-79611

10/06/2023, 1:02 PM
Hi everyone ! I'm trying to connect BigQuery to GrowthBook. Specifically, I've created the link between Analytics and GrowthBook, I've created the service account in BigQuery and generated the keys. However, when I import the keys into GrowthBook and click on "View schemas," I don't see any tables. It says that there are no tables present. How can I resolve this issue?
b

billions-xylophone-11752

10/06/2023, 2:23 PM
Hey, Alessandro - when you created the Service Account for BigQuery, did you grant it the permissions as outlined in this doc article?
e

echoing-advantage-79611

10/06/2023, 2:23 PM
yes, this 3: ā€¢ BigQuery Data Viewer ā€¢ BigQuery Metadata Viewer ā€¢ BigQuery Job User
b

billions-xylophone-11752

10/06/2023, 2:24 PM
If you click the "Retry" button, I'm assuming it ends up returning the same message?
e

echoing-advantage-79611

10/06/2023, 2:24 PM
unfortunatly yes
šŸ¤” 1
b

billions-xylophone-11752

10/06/2023, 2:32 PM
Is the BigQuery instance you're connecting to getting data via GA4, or is it an internal setup?
e

echoing-advantage-79611

10/06/2023, 2:35 PM
Thank you so much for the help you are trying to provide me with. I have connected GA4 to BigQuery; in fact, in the BigQuery project, I have the "analytics" dataset with the corresponding "events" table.
Schermata 2023-10-06 alle 16.34.43.png
I've tried to recreate the project and reconnect it multiple times, I've regenerated the keys but nothing changes, the tables never appear in GrowthBook
Schermata 2023-10-06 alle 16.37.47.png
šŸ‘€ 1
b

billions-xylophone-11752

10/06/2023, 2:44 PM
I'm trying to recreate this on my end, but I haven't been successful yet. Everything looks to be set up correctly on the GrowthBook side.
e

echoing-advantage-79611

10/06/2023, 2:46 PM
I've followed step by step every type of guide, video, and explanation in the documentation multiple times, but every time I get this error. I can't understand what it might be.
r

refined-lifeguard-96652

10/09/2023, 10:47 PM
I was going to ask my own question about this but I scrolled up and found your issue, I'm seeing the exact same thing right now. I have a GA4 instance streaming data to bigquery I can see the analytics data going in to bigquery when i use the console I've created a service account following the steps in the documentation But growthbook seems to refuse to see these tables
The thing is i can see this service account usage in the logs and it doesn't look like anything is failing
From what I can tell the query being run is valid
Copy code
SELECT * FROM `my-db-name.INFORMATION_SCHEMA.SCHEMATA`
but when i run this myself in the SQL form it returns no data
OK some googling I thing i see the issue, because the query above gives no region info it defaults to
region-US
my dataset is located in the EU though, when i change the query to
Copy code
SELECT * FROM `my-db-name.region-EU.INFORMATION_SCHEMA.SCHEMATA`
I see the row returned correctly. Is there a way i can add this region qualifier to the my dataset queries in Growthbook?
a

acoustic-spoon-44754

10/10/2023, 10:05 AM
We have the same problem. Everything has been setup according to instructions. We can use the growth book user to query the BigQuery api and extract the experiment event data but when adding a data source on the site GrowthBook says it can't find any tables. Our data is also located in the EU.
e

echoing-advantage-79611

10/10/2023, 1:03 PM
hi everyone, I haven't been able to find a solution yet, I am in contact with @billions-xylophone-11752 for the resolution
b

billions-xylophone-11752

10/10/2023, 1:40 PM
@refined-lifeguard-96652 Thanks for digging into this - I was able to create a new BigQuery instance and add a dataset outside of the US, and in that, I was able to replicate the behavior. I'm exploring a few different fixes right now. I'll keep you all in the loop. CC: @echoing-advantage-79611 @acoustic-spoon-44754
šŸ™Œ 3
Just a quick update - I've got a solution working, just awaiting feedback and approval from others on the team. When it's live, I'll follow up here.
šŸ™Œ 3
r

refined-lifeguard-96652

10/11/2023, 11:25 AM
It looks like this has just been released šŸŽ‰, thanks @billions-xylophone-11752 šŸ¤— I can now access my data as expected
šŸ™Œ 1
b

billions-xylophone-11752

10/11/2023, 12:52 PM
Yup! This is out - thanks to everyone for raising this issue and for your patience!
a

acoustic-spoon-44754

10/11/2023, 12:52 PM
Thank you!
e

echoing-advantage-79611

10/11/2023, 1:10 PM
Thank you so much @billions-xylophone-11752, it works.
2 Views