---
title: "BigQuery"
description: "BigQuery"
keywords: "BigQuery ODBC driver SQL"
url: "https://myrapidi.com/wiki/bigquery"
locale: "en"
published: "2024-09-18T12:49:51Z"
modified: "2025-11-23T18:13:06Z"
---

Google BigQuery is a fully-managed, serverless data warehouse that allows you to run super-fast SQL queries on large datasets. It’s designed to handle enormous volumes of data efficiently.  
  
**A. In order to connect to BigQuery, follow these steps:**

1. **Set Up Google Cloud Project** : Create or select a project in the Google Cloud Console. Ensure you have billing enabled for the project.
2. **Enable BigQuery API** : Go to the APIs & Services dashboard and enable the BigQuery API for your project.
3. **Create a Service Account** : In the **IAM & Admin** section, create a service account with appropriate permissions. Download the **service account key** file (JSON format).
4. **Install BigQuery Client Library** : Depending on your programming environment, install the BigQuery client library.
5. **Authenticate** : Set up authentication using the service account key. For example, set the GOOGLE\_APPLICATION\_CREDENTIALS environment variable to the path of your JSON key file.
6. **Connect and Query** : Use the client library to connect and run queries.

**B. Next, here are the steps required in order to connect to BigQuery via Rapidi:**  
  
**_Note: All parameters should be separated by a semi-colon(;)_**

1. Select **ODBC** as the connection type;
2. Add a **description** such as Google BigQuery service account;
3. Add **3.0 Driver** as the **ODBC Version** ;
4. Add the following string (in the indicated order) into the **Server Connect** field: 

- Simba ODBC Driver for Google BigQuery
- OAuthMechanism=0
- Email= **The service account email address**
- KeyFilePath=/dbb\_config/service **1234** -dbb **123** /bigquery\_access.json ( Rapidi to add the service ID and the DBB ID where this connection is being set up).

**Important: Please provide Rapidi with the Service Account Key file(jSON format).**

- Catalog= **BigQuery Project ID**
- EnableSession=1
- DefaultDataset= **BigQuery Dataset ID**

**Server Connect** string Example:  
  

> _Simba ODBC Driver for Google BigQuery;OAuthMechanism=0;Email=rapidi-test-2024@rapidi-project-2024-428813.iam.gserviceaccount.com;KeyFilePath=/dbb\_config/service1362-dbb825/bigquery\_access.json;Catalog=rapidi-project-2024-428813;EnableSession=1;DefaultDataset=rapidi-project-2024-428813.198901;_

5. Click on **Test** and then on **Read Design** to finalise the connection setup.