https://www.growthbook.io/ logo
Powered by
r

refined-breakfast-76512

11/29/2022, 7:34 AM
Hello! I'm just getting started with GrowthBook and immediately ran into an issue with connecting to BigQuery/GA4! 😄 I believe I've followed the instruktions but can't connect to BQ from GrowthBook. 😞 When trying to connect I get:
Access Denied: Project tandlakare-se-prod: User does not have bigquery.jobs.create permission in project tandlakare-se-prod.
Even though the user (service account) has the 
BigQuery Job User
role. What am I missing? 🙏
f

fresh-football-47124

11/29/2022, 7:42 AM
Hi Mattias
that’s interesting - BigQuery Job User has the bigquery.jobs.create role
do you have multiple projects?
r

refined-breakfast-76512

11/29/2022, 8:00 AM
Yes, we do. Is that an issue?
...and Hi, Graham! (sorry for my bad manners 😇 ).
f

fresh-football-47124

11/29/2022, 8:44 AM
I’m just wondering if it’s a typo - because I saw that one had capital PROD
and if you had multiple projects with similar names (I’m not sure if case matters in BigQuery projects)
r

refined-breakfast-76512

11/29/2022, 9:19 AM
Well depends on if it's the project NAME or project ID that is used. 🤔 id's are lower case only as far as I understand.
But judging from the BigQuery view it should be the "lower case" case (pun intended) 😉
f

fresh-football-47124

11/29/2022, 9:50 AM
I’ll take a look at the code - perhaps we have a bug
I don’t see anything obviously wrong
@future-teacher-7046 do you know?
r

refined-breakfast-76512

11/29/2022, 10:00 AM
Thanks! 🙏
f

future-teacher-7046

11/29/2022, 12:24 PM
The email addresses in the JSON key file don't seem to match. It's showing growthbook-io@, but the GCP console is showing growthbook-io-analytics@.
r

refined-breakfast-76512

11/29/2022, 1:44 PM
That is true! How is that possible? 😄
Seems I've messed something up in IAM! 🤔
Massive thanks @future-teacher-7046 for spotting that! 🙏
Powered by