BigQuery connector

Last modified by Aurelie Bertrand on 2026/01/12 15:14

Requirements

  • A Google BigQuery account

JDBC driver installation

To install the BigQuery JDBC driver:

  1. Make a backup of the ddenterpriseapi/WEB-INF/lib and studio/WEB-INF/lib directories.
  2. Stop the server.
  3. Delete the following files provided by Digdash:
    • google-api-services-bigquery-v2-rev355-1.22.0.jar
    • GoogleBigQueryJDBC42.jar
  4. Copy the BigQuery driver zip files into the ddenterpriseapi/WEB-INF/lib and studio/WEB-INF/lib directories.
  5. For files other than those from step 3, compare those added from the BigQuery driver zip with those delivered by DigDash. If a file with the same name but a different version is supplied by DigDash, delete the file from the BigQuery driver zip and keep only the one supplied by DigDash. This is the case, for example, for the commons-codec-1.15.jar file .
  6. Restart the server.

Connecting to a BigQuery database

To connect to a BigQuery database via the dedicated interface, see the page Connecting to a BigQuery database.

You can also use the JDBC connector, see the page Connecting to Google Big Query via the JDBC connector.