Accessing BigQuery
Connecting to GCP BigQuery Service from your DevBox.
Architecture Diagram
DevZero Workspace
Step 1: Generating Google Authentication Credentials for BigQuery
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.
Step 2: Connecting to BigQuery through Python API
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.
Last updated