MyRapidi
MyRapidi
Menu

Search our Wiki

BigQuery

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/service1234-dbb123/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.