Setup bigquery

Add database connection details and credentials

Delete the variable "GOOGLE_APPLICATION_CREDENTIALS" from .env file, if present.

sed -i '' '/^GOOGLE_APPLICATION_CREDENTIALS=/d' .env

Log in to the Researcher Portal using a Chrome web browser
- https://localhost:443/portal - local workstation
- https://<FQDN>/portal - remote server
Login as the new admin user
Switch to Admin Portal
Select Setup on top right
URL is now:
- https://localhost:443/portal/systemadmin/setup - local workstation
- https://<FQDN>/portal/systemadmin/setup - remote server
Select Databases Configure button
Select Add database
Enter the database information.
Click Save

name	value	note
Database ID	big_query	display name
Project		Your big query project name
Dataset		Your big query dataset name from the project
Extra		Your service account json key