ODBC Driver for Google BigQuery

Achieving connectivity with Google BigQuery databases for users who rely on ODBC-based applications can be done in multiple ways. Being tailor-fitted for such purposes, the ODBC Driver for Google BigQuery will provide users with the means to establishing a high-performance connection for accessing the said databases in an efficient manner.

With support for both 32 and 64-bit infrastructure, the driver also offers full support for standard ODBC API functions, as well as a wide range of specific data, making for effective connectivity. This connectivity is performed directly, through the HTTPS protocol, and users who cannot connect this way have the choice of using a dedicated proxy, with classic options: host, port, username, and password.

The driver supports most standard SQL syntax that is compliant with the BigQuery database, including all functions and operations or data types. Some of these include aggregate, array, geography, or hash functions.

Support for DML is also provided, enabling users to either insert, update, or delete the data in the BigQuery data warehouse, just as with any other SQL database environment.

Last but not least, the ODBC conformance is provided for both API functions and data types, complete with support for Advanced Connection String parameters, therefore allowing any desktop or web applications to establish a connection.