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

white-salesclerk-40048

10/02/2023, 9:42 AM
Hello team, I'm trying to connect growthbook to BigQuery, I inserted the correct BigQuery Project ID, uploaded the service account key file and inserted the name of the default dataset, the schema browser is telling me that there are
no tables found
and when I wrote the SQL for the experiment assignment query it outputs
"Access Denied: Table project-name-1234: database_name.table_name: User does not have permission to query table project-name-1234: database_name.table_name, or perhaps it does not exist in location EU.
I'm sure it's in location EU as I checked and already ran the query in the google cloud editor and it gave me the list of IDs that I need, what could be the problem if someone faced this problem before? Thank you in advance.
f

fresh-football-47124

10/03/2023, 8:35 AM
Hi Amr: did you check the permissions your service account has in BigQuery?
we have some docs on the permissions
w

white-salesclerk-40048

10/03/2023, 8:46 AM
this part correct? the service account has these permissions yes, but the table I'm accessing is not in the same project as the service account so maybe that's the problem?
h

helpful-application-7107

10/03/2023, 4:55 PM
It has permissions on both projects?
w

white-salesclerk-40048

10/04/2023, 10:33 AM
I created a service account that is in the same project of the dataset I'm accessing, I added the key to the growthbook datasource and when I tried saving I got this
User does not have bigquery.jobs.create permission in project project-name
, as seen in the screenshot it has that permission
Any idea what could be the problem?
h

helpful-application-7107

10/10/2023, 2:35 PM
Is
project-name
the same name as the project in your datasource config in GrowthBook?
w

white-salesclerk-40048

10/10/2023, 2:39 PM
yes it's the same name in the BigQuery Project ID field
h

helpful-application-7107

10/10/2023, 2:41 PM
Ok, then I don't know what could be going wrong. If you could share the screenshots in DM or elsewhere of your service account details and roles in BigQuery and your Data Source form you are trying to save in GrowthBook maybe I could see something that is going on.
w

white-salesclerk-40048

10/11/2023, 8:44 AM
Sure
15 Views