Redpoint Interaction v6.x Documentation
Auto Light Dark
Redpoint Interaction v6.x Documentation
Auto Light Dark
Breadcrumbs

Admin: Google BigQuery Configuration

Overview

This section describes how to configure Google BigQuery. Please follow the steps below: 

  1. Download the driver from https://docs.cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers and install Windows 64-bit (msi).

  2. Open the ODBC Data Source Administrator, which can be found in Control Panel > Administrative Tools. Select the System DSN tab and click Add.

  3. Find Simba ODBC Driver for Google BigQuery and click Finish. 

    image-20250917-144312.png

  4. In the Simba ODBC Google BigQuery Data Source Configuration Window, click the Sign In... button to log into your Google BigQuery account.  

    image-20250917-144326.png

  5. In a web browser, enter your email or phone number and your password. 

  6. In the authorization page, click the Allow button to permit the ODBC driver to access your data.  

  7. Copy the code and paste it into the Confirmation Code in Google BigQuery ODBC DSN settings. The Refresh Token will be automatically populated after you have pasted the Confirmation Code.

    image-20250917-144353.png

  8. Select an appropriate project & data set. To test the connection, click the Test… button. Once successful, click OK to close the DSN settings.

    image-20250917-144420.png

RPI v6.7 with GCP BigQuery

This section provides some details on required permissions for configuring RPI v6.7 to talk to BigQuery.

Minimum permissions

Permission

Scope*

Why

bigquery.jobs.create

P

Every ODBC query, DML, and SQL DDL statement.

bigquery.datasets.get

D

client.GetDataset() on both paths; ODBC catalog enumeration.

bigquery.tables.list

D

SQLTables/SQLColumns catalog calls.

bigquery.tables.get

D

Schema reads: GetTable(), table.Schema.Fields, add/drop-column pre-checks.

bigquery.tables.getData

D

All SELECT / audience queries.

bigquery.tables.create

D

CREATE TABLE, CREATE TABLE AS SELECT, CREATE OR REPLACE TABLE, GetOrCreateTable(), the t_OLD copy.

bigquery.tables.update

D

PatchTable() (add column), ALTER TABLE DROP COLUMN, RENAME TO.

bigquery.tables.updateData

D

INSERT INTO … SELECT, UPDATE, DELETE, tabledata.insertAll streaming.

bigquery.tables.delete

D

DROP TABLE IF EXISTS (scratch teardown), CREATE OR REPLACE, DROP TABLE t in the drop-column sequence.

bigquery.jobs.get is implied for the creator polling its own jobs.
*Scope: P = project (billing/jobs); D = each dataset RPI touches

Conditional

Permission

When

bigquery.tables.create on the driver's large-results dataset

If Simba's large-result-set spill is enabled. Separate dataset from your data.

bigquery.readsessions.create + bigquery.readsessions.getData

Only if you enable Simba's Storage Read API / high-throughput fetch.

Both are driver settings, not RPI behavior. Please verify against the Simba ODBC for Google BigQuery 2.1.23 install guide.

Last updated: