Devart announced the release of ODBC Driver for Google BigQuery.
The driver is intended for use in various analytics, database management and reporting tools, IDEs and programming languages on Windows (32/64-bit) to access Google BigQuery data warehouse.
Devart ODBC Driver for Google BigQuery provides full support for the standard ODBC API functions and data types and BigQuery SQL expressions and data types, and is able to connect to BigQuery warehouse directly through HTTPS.
One of the prominent features of ODBC Driver for Google BigQuery is that users have the ability to specify whether the driver must return foreign keys, which is a time-consuming operation. On many occasions, third-party tools do not actually need foreign key metadata, so it is an effective way to increase the speed of data retrieval operations.
For compatibility purposes, we added the option to specify a column or a set of comma-delimited columns that will be returned by the driver as primary keys for BigQuery tables. Google BigQuery has no primary key or unique constraints, which makes it impossible for some third-party tools to work with BigQuery tables correctly.
As an extra benefit comes cost-effective deployment: the driver is a standalone installation file that does not require the user to install or update any dependencies. For large organizations with hundreds of machines, we offer the silent install method with an OEM license.