# BigQuery
Establishing a workspace connection to a BigQuery data warehouse allows any workflow in that workspace to access tables from datasets in BigQuery.
To establish a connection to your BigQuery data warehouse, click the **Integrations** tab in your workspace and select **New Integration.**
When establishing a connection, the following information is required:
| Input | Description |
| --------------- | ---------------------------------------------- |
| Connection Name | Choose a name for your connection |
| Key | Service account key file generated by BigQuery |
{% hint style="info" %}
Importing data uses the BigQuery Storage API, which must be enabled on your Google Cloud Platform account.
{% endhint %}
## **Database configuration instructions**
To connect Cascade to your BigQuery project, you will need to create a service account for Cascade to use.
### Generate a new BigQuery service account key
You must have Google Cloud admin permissions to create a service account. Google has documentation on creating a [service account](https://cloud.google.com/iam/docs/service-accounts) and [generating a service account key](https://cloud.google.com/storage/docs/authentication#generating-a-private-key).
1. Navigate to the [Google Developers Console](https://console.developers.google.com/). Before proceeding, click on the drop down to the left of the search bar and select the project to which you want to connect. Once selected, choose **Credentials** in the left menu:\ 
2. Click **CREATE CREDENTIALS** and choose **Service account**:\
3. Enter a name for the new service account, optionally add a description, and click **CREATE**:\
4. Your service account requires two Google BigQuery [predefined roles](https://cloud.google.com/bigquery/access-control#curated_roles_comparison_matrix):
* **BigQuery > BigQuery Data Editor**
* **BigQuery > BigQuery Job User**
Select the first role in the **Select a role** field, then click **ADD ANOTHER ROLE** and select the second role.
After selecting both roles, click **CONTINUE**:\
5. Click **Done**:\
6. This will create your service account, which needs a key to access. Select the service account you just created, then click **KEYS**, then **Add Key:**\
\
7. Select **JSON** and click **CREATE**:\
8. The JSON key will be saved to your computer. **BE SURE TO REMEMBER WHERE IT IS SAVED.** After noting the download location, click **CLOSE**:\
### Use your key to connect BigQuery to Cascade
1. Return to Cascade, and begin the process to connect a BigQuery database. When you see the form to enter your BigQuery credentials, first enter a name for the new database connection.
2. Open the service account key you downloaded from BigQuery in a text editor, and **copy** the contents.
3. In the **Key** field, paste the contents of the service account key into the text box.
4. Click **Test and Save** to complete the connection.
Once an integration is established, open a workflow and select **Import from BigQuery** to pull data from your database into Cascade.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.cascade.io/cascade/integrations/bigquery.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.