ODBC Driver Version 2.2.1

Release Date: 27th August 2019

Qubole has released a new version of ODBC driver for Linux, Mac, and Windows.

For more details, see:

What’s New

Note

Unless stated otherwise, features are generally available, available as self-service and enabled by default. For more information, see Launch Stage and Availability of Features.

These are the changes in this version:

  • This version adds support for path-style URLs for S3 buckets (that are used as default storage location (defloc)) in ODBC Driver for Linux, Mac, and Windows. Path-style URLs support a dot (.) character in the S3 bucket name. For more information, see documentation on S3 buckets.

    ODBC drivers versions, 1.1.10, 1.1.11, and 2.2.0 only supported virtual-hosted-style URLs for S3 buckets.

    Virtual-hosted-style URLs do not support a dot (.) character in the domain name. For more information, see bucket naming guidelines.

  • This version reintroduces the Bucket Region configuration property in ODBC Driver for Linux, Mac, and Windows. Note that versions 2.2.0 and 2.2.1 do not support S3 buckets that require V4 signature.

  • Starting this version, ODBC driver for Linux only creates system-level DSNs during its installation. For details on steps to create user-level DSNs, see Creating a User-level DSN.

List of Changes

Bug Fixes

  • ODBC-325: The ODBC driver versions 1.1.10, 1.1.11, and 2.2.0 do not support a dot (.) character in the S3 bucket name as they supported only virtual-hosted-style URLs in S3 buckets. This has been resolved as this version supports path-style URLs that accept a dot (.) character in the S3 bucket name.

    By default, virtual-hosted style URLs are enabled by default on ODBC Drivers for Mac and Windows. To enable path-style URLs for S3 buckets:

    • On ODBC Driver for Linux, disable VIRTUAL_HOST_STYLE in the system DSN configuration.
    • On ODBC Driver for Mac, disable VIRTUAL_HOST_STYLE in the system DSN configuration.
    • On ODBC Driver for Windows, disable Virtual Hosted-Style URL in the system DSN’s advanced configuration.
  • ODBC-331: Starting this version, ODBC driver for Linux only creates system-level DSNs during its installation. For details on steps to create user-level DSNs, see Creating a User-level DSN.