https://www.growthbook.io/ logo
h

handsome-library-89124

06/08/2022, 8:19 AM
Hi, is there any way to set single source of data (only BQ) and provide BQ JSON key file and ProjectId in backend env.
f

future-teacher-7046

06/08/2022, 12:04 PM
Yes, we support connecting to BigQuery with a JSON key file.
h

handsome-library-89124

06/08/2022, 12:04 PM
I can set in env file? can you share example or document?
f

future-teacher-7046

06/08/2022, 1:45 PM
With BigQuery, you can choose the "auto-discovery" method for authentication and the set the env variable:
Copy code
export GOOGLE_APPLICATION_CREDENTIALS="/home/${USER}/key.json"
1
h

handsome-library-89124

06/08/2022, 1:53 PM
why export?
f

future-teacher-7046

06/08/2022, 1:54 PM
that's just how you set env variables from a terminal on Linux. You don't need that part if you are setting env variables some other way.
h

handsome-library-89124

06/08/2022, 1:56 PM
Yes I will set in .env file
2 Views