> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superblocks.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google BigQuery

> Build apps with read and write access to BigQuery

export const IntegrationSuccess = ({integrationName}) => {
  return <p>
      <b>{integrationName} connected!</b><br />You can now use{" "}
      <a href="/building-with-clark">Clark to build</a> with {integrationName}.
    </p>;
};

export const Alert = ({type, title, children}) => {
  const variant = ["info", "success", "warning", "danger", "note"].includes(type) ? type : "note";
  return <div className={`alert alert--${variant}`}>
      <div className="alert-icon" />
      <div className="alert-content">
        {title && <div className="alert-title">{title}</div>}
        <div className="alert-body">{children}</div>
      </div>
    </div>;
};

## Setting up Google BigQuery

Before getting started in Superblocks, set up a GCP Service Account with the [following IAM roles](https://cloud.google.com/bigquery/docs/access-control#bigquery):

* **Data Viewer**
* **Metadata Viewer**
* **Job User**

Then generate a [service account key](https://cloud.google.com/iam/docs/keys-create-delete#creating_service_account_keys).

### 1. Add integration

<p>
  Select <strong>BigQuery</strong> from the{" "}
  <a href="https://app.superblocks.com/integrations/bigquery">integrations page</a>.
</p>

### 2. Configure settings

Fill out the form with the following settings:

| Setting             | Required                                   | Description                                                                                                                                                               |
| ------------------- | ------------------------------------------ | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Name                | <span className="table-checkmark">✓</span> | Name that will be displayed to users when selecting this integration in Superblocks                                                                                       |
| Service Account Key | <span className="table-checkmark">✓</span> | Paste your Google [Service Account Key](https://cloud.google.com/iam/docs/creating-managing-service-account-keys#creating_service_account_keys) JSON object in this field |

### 3. Test and save

Click **Test Connection** to check that Superblocks can connect to the data source.

<Alert type="info">
  If using Superblocks Cloud, add these Superblocks IPs to your allowlist (not necessary for Hybrid or Cloud-Prem deployments). See the <a href="/integrations/auth/guides/configure-ip-allowlist-for-databases">Configure IP allowlist for databases</a> guide for more information.
</Alert>

After connecting successfully, click **Create** to save the integration.

### 4. Set data tags

Optionally, configure different data tags for [separate development environments](/development-lifecycle/build/data-tags).

<Alert type="success">
  <IntegrationSuccess integrationName="Google BigQuery" />
</Alert>