---
title: Google BigQuery
description: Learn how to connect and configure Google BigQuery connections in Infoveave to access scalable cloud data warehouses for analytics and data processing.
---

import { Steps } from '@astrojs/starlight/components';

# Google BigQuery

Google BigQuery connection helps Infoveave access Google’s scalable cloud data warehouse to query, analyze, and process large datasets efficiently.

## Adding a Google BigQuery Connection

To create a new Google BigQuery connection:

<Steps>
1. Go to **Administration** > **Connections**
2. Click **New Connection** and select **Google BigQuery** from the available connectors
3. In the **New Google BigQuery Connection** form, choose your preferred authentication method and provide the required configuration details
</Steps>

## Connection Parameters

When setting up a Google BigQuery connection, provide the following information:

| Field | Description |
|-------|-------------|
| **Name** | A unique name to identify your BigQuery connection |
| **Authentication Method** | Choose between **Auth code** (OAuth) or **Service account** |

BigQuery supports two authentication modes in Infoveave, explained below.

---

## Authentication Methods

### **1. Auth Code (OAuth)**

Use OAuth authentication when you prefer signing in with your Google account.

Steps:

- Click **Sign in with Google**
- Choose the Google account that has BigQuery access
- Authorize Infoveave to access your BigQuery datasets
- Provide the **Project** associated with your BigQuery resources

This method is suitable when:

- You want easy sign-in without service account management  
- You prefer user-level access to BigQuery resources  

---

### **2. Service Account**

Use a service account when you want secure, automated, non-user-based access.

Steps:

- Select the **Service account** tab
- Upload the JSON **service account key file** downloaded from Google Cloud
- Ensure the service account has BigQuery access roles (Viewer, Data Viewer, or custom roles)

This method is ideal for:

- Scheduled automations  
- Server-to-server communication  
- Environments requiring strict credential control  

---

## Steps to Validate and Save

<Steps>
1. After providing authentication details (OAuth or Service account), click **Validate** to verify the connection
2. If validation succeeds, click **Save** to store the connection
3. You can now use this BigQuery connection as a datasource across Infoveave workflows and dashboards
</Steps>

## Example Use Cases

With a Google BigQuery connection configured, you can:

- Query large datasets directly from BigQuery into Infoveave  
- Build dashboards using data stored in BigQuery tables  
- Automate workflows based on query results or data refresh schedules  
- Combine BigQuery data with CRM, ERP, or API datasets for unified analytics  
- Run complex analytical queries for forecasting or data modeling  
- Visualize multi-terabyte datasets without moving data out of BigQuery