Über Devart ODBC Driver for Google BigQuery

Ganz einfach Daten aus Google BigQuery abrufen.

Devart ODBC Driver for Google BigQuery provides a high-performance and feature-rich connectivity solution for ODBC-compliant applications to access BigQuery data from Windows. It includes full support for standard ODBC API functions and data types implemented in the driver makes interaction of your database applications with BigQuery easy.

Features

  • Connection to Google BigQuery - Establish a connection to BigQuery data through HTTPS. You also have the ability to connect through a proxy using the following connection options: Host, Port, Username and Password.
  • BigQuery Standard SQL - Supports all BigQuery standard SQL expressions, including functions and operations and all data types:
    • Aggregate functions
    • Array functions
    • Datetime functions
    • Geography functions
    • JSON functions
    • Navigation functions
    • Net functions
    • Hash functions
  • DML Operations - Modify data in a BigQuery data warehouse in the same way as in any other SQL database:
    • INSERT
    • UPDATE
    • DELETE
  • ODBC Conformance
    • ODBC API Functions support
    • ODBC Data Types support
    • In addition, it provides support for Advanced Connection String parameters, allowing any desktop and web applications to connect to Google BigQuery from various environments and platforms that support ODBC.
  • BigQuery Compatibility - Devart ODBC driver fully supports the Google BigQuery API, data types, and expressions, including functions and operators.