BigQuery
This guide shows you how to create a BigQuery Connection in Ascend.
Prerequisites​
- Ascend Project
- Ascend Workspace
- Credentials for a GBQ account
- Service Account Key: The Service Account Key associated with the service account accessing GBQ
Create a BigQuery Connection
From your workspace Super Graph view, follow these steps:
- Form
- Files panel
- Create a Connection by either:
- Clicking the + button next to Connections in the left Build panel
- Right-clicking in the Super Graph and selecting Create Connection
- Enter a descriptive name like `data_plane_bigquery`
- Select BigQuery from the available options
- Fill in the required fields (and any optional fields as needed)
- Click Save at the bottom to create your Connection

- Open the Files panel in the top left
- Right-click the Connections directory and select New File

- Give your file a descriptive name like `data_plane_bigquery.yaml`
For complete configuration options, see our Connection reference guide.
Example​
Use the following YAML template for your BigQuery Connection. Customize the highlighted values with your specific Connection details:
/my_project/connections/gbq_connection.yaml
connection:
bigquery:
project: <project_id>
dataset: <dataset>
key: ${vaults.<your_vault>.<key>}
location: <region>
🎉 Congratulations, you just set up a BigQuery Connection in Ascend!