DCI Interface Hero

Google BigQuery JDBC Driver

Google BigQuery logo

Select your platform

Table of Contents:


    Progress DataDirect’s JDBC Driver for Google BigQuery offers a high-performing, secure and reliable connectivity solution for JDBC applications to access Google BigQuery data. Our JDBC driver can be easily used with SQL across all platforms - Unix / Linux, AIX, Solaris, Windows and HP-UX. Enjoy real-time analytics, reporting and business intelligence (BI) capabilities with your favorite tools such as Tableau, Power BI, Qlik, Excel, Cognos, Informatica, SAS, Board, MicroStrategy, SSIS, Oracle OBIEE and more.

    • Use the High Performing Storage API when fetching large amount of data
    • Use Service Account authentication to run the Google BigQuery jobs associated with service credentials without providing end-user’s credentials
    • Use full CRUD support with both Standard and Legacy SQL dialect


    Support for Storage API

    Supports the ability to read large amount of data quickly. The driver uses the Google BigQuery high performing Storage API for Selects based on the configurable values of the Storage API Threshold and Storage API Min Page Count connection option. 

    Support for Standard and Legacy SQL

    Supports both Standard and Legacy SQL dialects based on configurable values of Syntax option. The driver also supports CRUD operations with internal tables and read operations with external tables by leveraging the SQL engine functionality of Google BigQuery.

    OAUTH and Service Account Support

    Authenticate users without providing user credentials using secure OAUTH 2.0 protocol and Service Account authentication.  The driver also provides an option to pass the service account key directly rather than relying on a disk. 

    Security and Compliance

    Protect customer-sensitive data elements (including remote credential or database pairings stored) with encryption, both at rest (AES-256) and in transit (SSL/TLS). 

    Cross-platform Support

    Use one JDBC driver for all versions of SQL across both 32-bit and 64-bit platforms.

    Technical Specifications

    Progress DataDirect for JDBC for Google BigQuery
    Version 6.0.0

    Supported Versions

    • Google BigQuery

    Platform Support

    • 32- and 64-bit platforms

    Software Requirements

    • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.


    Connect any application to any data source anywhere

    Explore all DataDirect Connectors

    A product specialist will be glad to get in touch with you

    Contact Us