Support and Certifications

Visit the following web pages for the latest support and certification information.

Changes Since 8.0.0

  • Enhancements
    • The driver is now compiled with a Visual Studio 2022 compiler for the Windows platforms. As a result, you must have Microsoft Visual C/C++ runtime version 14.40.33810 or higher on your machine to run the driver.
    • The driver has been enhanced to retry API call executions when an HTTP failure or driver exception occurs. You can configure this behavior with the new Retry Exceptions (RetryExceptions) connection option. When this option is set to 1, the driver uses the retry value specified by the WS Retry Count (WSRetryCount) connection option. See Retry Exceptions for details.
    • The driver has been enhanced to support fetching access and refresh tokens at connection when OAuth2.0 is enabled. When using the new dynamic authorization code grant, you can initiate an authorization code grant flow by specifying login credentials using the login prompt for your service, thereby providing a method to authenticate without fetching access and refresh tokens via the Configuration Manager or a third-party application. In addition, the new Enable Login Prompt (EnableLoginPrompt) option has been added to enable this functionality. See Dynamic authorization code grant and Enable Login Prompt for details.
    • The driver has been enhanced to support the JSON and Interval data types, which map to the SQL_LONGVARCHAR and SQL_VARCHAR odbc data types respectively. See Data types for details.
    • On Windows platforms, the driver includes an enhanced setup dialog, the Progress DataDirect Google BigQuery Configuration Manager, for quick configuration and testing of your driver in a web browser. The tool allows you to:
      • Configure data sources
      • Generate and edit connection strings
      • Test connect data sources and connection strings
      • Execute SQL commands for testing
      • Access connection option descriptions and the full product documentation
      For details, see Generating connection strings with the Configuration Manager and Testing connections and queries with the Configuration Manager.
    • The driver has been enhanced to allow users to specify values for the following exposed connection options:The driver used the default values for these options previously when authenticating to Google BigQuery. See Configuring OAuth 2.0 authentication and Configuring service account authentication for details.
    • The driver has been enhanced to support the Google BigQuery Streaming API when executing batch insert operations. This behavior can be configured using the Use Streaming Insert connection option. See Google BigQuery Streaming API for details.
    • A Password Encryption Tool, called ddencpwd, is now included with the product package. It encrypts passwords for secure handling in connection strings and odbc.ini files. At connection, the driver decrypts these passwords and passes them to the data source as required. See Password Encryption Tool (UNIX/Linux only) for details.
    • The driver has been enhanced with the new Primary Key Pattern (PrimaryKeyPattern) connection option, which allows you to determine which column in a table is designated as the primary key. Google BigQuery does not have the concept of primary keys, or even uniqueness. However, some applications do not function properly without at least one column in a table designated as the primary key. This option allows your applications that require a primary key to function correctly when connecting to Google BigQuery data sources.
    • The driver has been enhanced to support the BIGNUMERIC data type. See Data types for more information.
    • The Service Account Key Content connection option has been added to the driver. This option allows you to specify the private key required for service account authentication without having to persist the .json or .p12 file that contains the private key. See Configuring service account authentication and Service Account Key Content for details.
    • The Enable Catalog Support connection option has been added to the driver. It determines whether the driver supports specifying values for catalog parameters in metadata calls. See Enable Catalog Support for details.
    • The drivers using base version B0649 and later have been enhanced to include timestamp in the internal packet logs by default. If you want to disable the timestamp logging in packet logs, set PacketLoggingOptions=1. The internal packet logging is not enabled by default. To enable it, set EnablePacketLogging=1.
    • The driver has been enhanced to support the Google BigQuery Storage API when fetching large result sets. See Google BigQuery Storage API and Storage API attributes for details.
      Note: Currently, the Storage API is supported only on Windows 64-bit, Linux 64-bit, and JVM 64-bit. If an application attempts to use the Storage API on an unsupported platform, the driver falls back to the Standard API.
  • The Driver Manager for UNIX/Linux has been enhanced to support setting the Unicode encoding type for applications on a per connection basis. By passing a value for the SQL_ATTR_APP_UNICODE_TYPE attribute using SQLSetConnectAttr, your application can specify the encoding at connection. This allows your application to pass both UTF-8 and UTF-16 encoded strings with a single environment handle.

    The valid values for the SQL_ATTR_APP_UNICODE_TYPE attribute are SQL_DD_CP_UTF8 and SQL_DD_CP_UTF16. The default value is SQL_DD_CP_UTF8.

    This enhancement is available in build 08.02.0449 of the driver manager.

  • Changed Behavior
    • On Windows platform, the default value of the SQL Engine Mode connection option has been changed to 1 (Server).
    • When existing DSNs are updated using the Configuration Manager, the boolean values of "0" and "1" are converted to "true" and "false" for relevant connection options.
    • The driver updates string values in an existing DSN to number values when the Configuration Manager is used to update the Authentication Method connection option. The following updates occur:

      - The string value "oauth2.0" is updated to 24

      - The string value "serviceaccount" is updated to 28

    • The default value of the WSRetryCount connection option has been changed to 5.
    • The default value of the SchemaSet configuration option has been changed to the project and dataset specified at connection. For details, see SchemaSet (Config Option)

Highlights of 8.0.0 Release

  • The driver supports both standard and legacy Google BigQuery SQL dialects. See Standard and legacy SQL support for more information.
  • The driver serves as a complete pass-through driver. It leverages Google BigQuery SQL engine to execute queries.
  • The driver supports create, read, update, and delete (CRUD) operations.
  • The driver returns data for complex data types, such as Array and Struct, as JSON strings, which are easy to comprehend for ODBC applications. See Json Format for more information.
  • The driver provides proxy support. See Proxy Host, Proxy Password, Proxy Port, and Proxy User for more information.
  • The driver supports the handling of large result sets with configurable paging and the Fetch Size and WS Fetch Size connection options.