Downloading the ODBC Driver on Mac¶
Qubole supports two variants of its ODBC drivers:
Series 2.1.x (starting with version 2.1.1) is based on top of AWS SDK and hence it has inherent support for accessing AWS S3 buckets that require signature version V4. New S3 buckets that are created after January 20, 2020 only support signature version V4. AWS regions that are created after 2013 only support signature version V4, which are listed in AWS Service endpoints.
Qubole recommends you to test if the S3 bucket is in the AWS region that supports signature version V4 to use series 2.1.x drivers.
Series 2.2.x is based on older (1.X.X) releases and does not support accessing AWS S3 buckets that require signature version V4. It supports accessing AWS S3 buckets that require signature version V2. To know regions that support signature version V2, see AWS Service endpoints.
Proceed as follows to prepare your system and download the driver:
The Qubole driver is stored in the publicly accessible cloud storage, and works on all cloud platforms (except GCP) supported in QDS.
Download and install the iODBC Driver Manager for Mac from: http://www.iodbc.org.
Download the Qubole ODBC driver. The following table provides version, downloadable locations, and so on.
ODBC Driver Version AWS V4 Signature Support Downloading Location Driver Release Notes 2.1.1 Yes as it is Series 2.1.x https://paid-qubole.s3.amazonaws.com/odbc/2.1.1/qds-odbc-2.1.1.dmg ODBC Driver Version 2.1.1 2.2.2 No as it is Series 2.2.x https://paid-qubole.s3.amazonaws.com/odbc/2.2.2/qds-odbc-2.2.2.dmg ODBC Driver Version 2.2.2
Downloading ODBC Driver Older Versions on Mac¶
To download the last three older ODBC driver versions, choose the version from this list:
ODBC Driver Version AWS V4 Signature Support Downloading Location Additional Description 2.1.0 (beta) Yes https://s3.amazonaws.com/paid-qubole/odbc/2.1.0/qds-odbc-2.1.0.dmg
The ODBC Driver versions 2.0.0 and 2.1.0 are beta releases. They can cause data loss in scenarios where results data has NULL characters (0x00) and are therefore not recommended for production usage. For more information, see Launch Stage and Availability of Features.
2.0.0 Yes https://s3.amazonaws.com/paid-qubole/odbc/2.0.0/qds-odbc-2.0.0.dmg
ODBC Driver Version AWS V4 Signature Support Downloading Location Additional Description 2.2.1 No https://paid-qubole.s3.amazonaws.com/odbc/2.2.1/qds-odbc-2.2.1.dmg NA 2.2.0 No https://paid-qubole.s3.amazonaws.com/odbc/2.2.0/qds-odbc-2.2.0.dmg