Redpoint Interaction v7.x Documentation
Redpoint Interaction v7.x Documentation
Breadcrumbs

Admin: Google BigQuery ODBC driver configuration

This section describes how to configure Google BigQuery using the Simba ODBC driver configured in Redpoint Interaction docker based image.

Please follow the steps below:

  1. In your docker-compose.yml file, ensure that following entries below are defined.

volumes:
          -./config/odbc:/app/odbc-config
          -./config/odbc/google-creds:/app/odbc-google-creds-config

  1. Create a new or edit an existing odbc.ini located at the ./config local directory:

    • Set the BigQuery odbc name and provide credentials.

    • Set the Driver parameter: Driver=/app/odbc-lib/bigquery/SimbaODBCDriverforGoogleBigQuery64/lib/libgooglebigqueryodbc_sb64.so.

e.g.:

[ODBC]
Trace=no
[ODBC Data Sources]
gbq=Simba ODBC Driver for Google BigQuery 64-bit
[gbq]
Description=Simba ODBC Driver for Google BigQuery (64-bit) DSN
Driver=/app/odbc-lib/bigquery/SimbaODBCDriverforGoogleBigQuery64/lib/libgooglebigqueryodbc_sb64.so
Catalog=[ENVIRONMENTAL SETTING]
DefaultDataset=[ENVIRONMENTAL SETTING]
SQLDialect=1
OAuthMechanism=1
RefreshToken=[ENVIRONMENTAL SETTING]
KeyFilePath=[ENVIRONMENTAL SETTING]
TrustedCerts=/app/odbc-lib/bigquery/SimbaODBCDriverforGoogleBigQuery64/lib/cacerts.pem
AllowLargeResults=0
Min_TLS=1.2
DefaultStringColumnLength=16384
LargeResultsTempTableExpirationTime=3600000
RowsFetchedPerBlock=100000
Timeout=300000
SSL=0

To check if the ODBC driver is connected, execute isql [ODBC_NAME] -v in the execution service CLI.

  1. Request a JSON Google service account key file, or create one using this guide.

  2. Place the JSON key file inside /config/odbc/google-creds.

  3. In the Pulse database, update the ConnectionConfiguration field in the rpi_Clients table for the BigQuery client: {"ProjectId":"[GOOGLE_PROJECT_ID]","ServiceAccountJsonPath":"/app/odbc-google-creds-config/[GOOGLE_SERVICE_ACCOUNT_KEYFILE].json"}.