I was trying to connect BigQuery to GB, and after ...
# ask-questions
e
I was trying to connect BigQuery to GB, and after creating a new project in google cloud, the
analytics_<property_id>
is missing. Do I need to create it along with the tables ?
f
Hi @echoing-park-17810, It takes about a day before your GA4 dataset is created in BQ. So Iโ€™m not sure, but maybe youโ€™re early? Also, did you also create a service account for Growthbook in BQ? I followed this guide, and it worked fine: https://docs.growthbook.io/guide/bigquery
e
@fresh-stone-24633 thank you for your answer ๐Ÿ™‚ Do you mean this will be automatically populated a day after I link it?
analytics_<property_id>
f
Ah no that is immediately available then you probably still have to create the service account in BQ so you get the key file that you can upload in GB when you add the BQ datasource.
e
I already have the service account and uploaded the JSON to GB, what I am not sure is
analytics_<property_id>
is missing here @fresh-stone-24633
f
Ah yes that should show up after a day. @echoing-park-17810
Iโ€™m actually in the same process now for another client Iโ€™ll let you know how it goes ๐Ÿ˜‰
e
I got it working ๐Ÿ™‚ , it would take sometime to populate
๐Ÿ‘ 2
thanks @fresh-stone-24633 ๐Ÿ™‚
๐Ÿ™Œ 2