Connecting to GCP BigQuery Service from your DevBox.
Go to IAM & Admin > Service Accounts.
Click on Create Service Account, enter the Service Account Name and click on Create and Continue.
Click on Select a role, select BigQuery Admin, and click on Continue.
Select the new service account and go to Keys.
Click on Add Key > Create a new key and click on Create.
Connect to your DevZero workspace.
Store the Google Authentication Credentials on the workspace.
Install Python and PIP:
Install BigQuery API:
Set the GOOGLE_APPLICATION_CREDENTIALS environment variable.
Write a Python scipt to test the BigQuery API Connection:
Run the Python Script:
If the connection is successful, you should see "Connected" printed in the terminal output.