May 20, 2020 - Devart, a recognized vendor of connectivity solutions for various databases and cloud services, released a brand new product – ODBC Driver for Google BigQuery. The driver provides full support for the standard ODBC API functions and data types, and BigQuery SQL expressions and data types. The solution is intended for use in various analytics, database management and reporting tools, IDEs and programming languages, and is able to access Google BigQuery data warehouse directly through HTTPS.

One of its prominent features 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, the vendor also 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, Devart offers the silent install method with an OEM license.

Learn more about the recent release by visiting Devart’s blog article https://blog.devart.com/odbc-driver-for-google-bigquery-released.html

About Devart
Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. For additional information about Devart, visit https://www.devart.com/.

Contact Information
Jordan Sanders
Devart