Snowflake ODBC 8.0.1 Linux
- Last Updated: May 8, 2026
- 10 minute read
- OpenAccess SDK
- Documentation
README
Progress(R) DataDirect(R)
Progress(R) DataDirect(R) for ODBC for Snowflake(TM)
Linux Platforms (32- and 64-bit)
Release 8.0.1
February 2026
***********************************************************************
Copyright (C) 2026 Progress Software Corporation and/or its
subsidiaries or affiliates. All Rights Reserved.
***********************************************************************
This README file contains information for Progress(R) DataDirect(R)
for ODBC for Snowflake(TM) Driver.
This README file contains information not included in the PROGRESS
DATADIRECT(R) FOR ODBC FOR SNOWFLAKE DRIVER USER'S GUIDE.
CONTENTS
Post-GA Product Announcements
Requirements
Installation Directory
Data Source and Platform Support
Changes for 8.0.1
Release 8.0.0 Features
Configuring Data Sources
Notes, Known Problems, and Restrictions
Driver WorkAround Options
Documentation
Installed Files for 32-bit Drivers
Installed Files for 64-bit Drivers
Post-GA Product Announcements
The readme files will no longer be updated with product announcements and new
features after the General Availability (GA) of the product. For the latest
updates and enhancements, please refer to the release notes
(https://www.progress.com/datadirect-connectors/whats-new).
Requirements
* The installer program requires a Java Virtual Machine (JVM) that is
Java SE 11 or higher, including Oracle JDK, OpenJDK, and IBM SDK (Java)
distributions.
* The driver requires a JVM that is Java SE 8 or higher, including Oracle
JDK and OpenJDK distributions. Also, you must set the library path environment
variable of your operating system to the directory containing your JVM's
libjvm.so file and that directory's parent directory.
* The driver requires the following runtime library for Linux:
C/C++ runtime libraries version GCC 2.12 or higher
Installation Directory
* The default installation directory for the 32-bit driver is:
/opt/Progress/DataDirect/ODBC
* The default installation directory for the 64-bit driver is:
/opt/Progress/DataDirect/ODBC_64bit
Data Source and Platform Support
For the latest data source and platform support information, refer to the
Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
Changes for 8.0.1
CVE-2022-41853 - Use of Externally-Controlled Input to Select Classes or Code
('Unsafe Reflection')
-----------------------------------------------------------------------------
Several Progress DataDirect ODBC drivers utilized a version of HyperSQL
Database that was vulnerable to remote code execution described in
CVE-2022-41853. All impacted drivers have been patched to fix this
vulnerability. For details on impacted drivers and fixed versions, refer to
the following KB article:
https://community.progress.com/s/article/DataDirect-ODBC-Critical-Security-
Bulletin-November-2022-CVE-2022-41853
Documentation
-------------
Any product package made available after February 9, 2021 will not include the
HTML help system or user's guide PDF. The full documentation set, including
these items, is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-snowflake
While the product packages will not include these documentation items, the
installation Help directory will provide an HTML redirect for direct access
to the HTML help.
Note that all Progress DataDirect for ODBC documentation has been migrated to
the Progress Information Hub:
https://docs.progress.com/
Enhancements
------------
* The driver has been enhanced to support key-pair authentication. When
key-pair authentication is enabled (AuthenticationMethod=21), you
can authenticate to Snowflake using a pair of private and public keys. To
configure the driver to use key-pair authentication, you can use the new
Private Key Content (PrivateKeyContent), Private Key File (PrivateKeyFile),
and Private Key Passphrase (PrivateKeyPassphrase) connection options.
* The driver has been enhanced to support the authorization code grant, the
client credentials grant, and the refresh token grant, in addition to the
access token flow. Also, on Windows, the Snowflake Configuration Manager may
now be used to obtain access tokens.
* On Windows, the driver now includes the Snowflake Configuration Manager
for quick configuration and testing of your driver in a web browser. This
tool allows you to:
- Configure data sources and connection strings
- Test connectivity for your data sources and connection strings
- Obtain access tokens for OAuth 2.0 authentication
- Execute SQL commands for testing purposes
* The driver has been modified to map Snowflake data types for fixed-point
numbers to the Numeric data type by default. In addition, the
IntegerFieldMapping connection option has been added to the driver. This
connection option allows you to specify whether fixed-point numbers are
mapped to Numeric or BigInt.
* The driver binaries now include debugging symbols that can be used for
diagnosing and debugging issues in the driver.
* The driver now allows you to specify whether the driver fetches metadata
for only tables in the database to which you are connected when a database
name is not specified in metadata calls. When enabled, this behavior can
provide better performance for metadata calls by reducing the number of
tables queried. You can use the new Use Session Database For Metadata
(UseSessionDatabaseForMetadata) connection option to configure the driver's
behavior. Refer to the user's guide for details.
* The driver has been enhanced to support connecting to Snowflake partner
applications. You can use the new Partner Application Name
(PartnerApplicationName) connection option to specify the name of the
partner application to which you want to connect. Refer to the user's
guide for details.
* The ICU library files that are installed with the product have been upgraded
to version 74.1. In addition, the ICU library file names have changed. For
the 32-bit driver, the ICU file name has changed from libivicu28.so to
libivicu.so. For the 64-bit driver, the ICU file name has changed from
libddicu28.so to libddicu.so.
This upgrade is available starting in build 08.02.0965 of the ICU library
files.
* The driver has been enhanced to fall back to JSON query format when the arrow
format is not properly initialized. The driver uses a high-speed arrow
transfer that requires the restricted APIs from java.nio package. When the
JVM is not correctly configured for Java SE 16 and higher, an exception is
returned when the driver executes a query. To allow you to continue executing
queries in this scenario, you can configure the new Arrow Fallback To JSON
(ArrowFallbackToJson) option to switch to the JSON query format.
Note: This option is not currently exposed on the GUI. To configure the
option via the GUI, specify the attribute and setting in the Extend Options
field on the Advanced tab.
Feature details:
* Available: Driver version 08.00.0100 (B1193, U0945, J001002)
* 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.
* 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.
* The driver is enhanced to support the COPY command for loading and unloading
data from local file systems and cloud storage platforms.
Changed Behavior
----------------
* The installer program now requires you to install a JRE that is Java SE 11 or
higher before running the installer. In earlier versions, the JRE used by the
installer program was included in the product. However, to avoid potential
security vulnerabilities, the installer program no longer includes a JRE.
Instead, the installer program uses the JRE in your environment to allow for
the most secure version of a JRE to be used.
Notes:
- This change does not affect the JVM requirements for the driver. For the latest
driver requirements, refer to the Product Compatibility Guide:
https://docs.progress.com/bundle/datadirect-product-compatibility/resource/
datadirect-product-compatibility.pdf
- The installer program cannot remove the already installed JRE files from the
install directory automatically. Remove them manually.
- To install the 32-bit drivers on 64-bit Windows platforms and start the SQL
engine service, the installer requires the 32-bit version of Java SE 11 or
higher installed on your machine and defined on your path.
* The product package no longer includes the ODBC Cursor library file
(odbccurs.so) because it has some known security vulnerabilities that
could potentially expose you to security risks.
Note: The installer program cannot remove the ODBC Cursor library file
automatically while installing a new version of the driver. Remove it
manually.
* The installer program has been updated to no longer install common components
for drivers that do not use them. As a result, the installer program no longer
installs the following common components for the Snowflake driver:
- OpenSSL library files, such as ivopenssl30.so, ddopenssl30.so, fips.so,
and openssl.cnf.
- Curl library files, such as libivcurl28.so and libddcurl28.so
If the files are not used by any other DataDirect driver on your machine, you
can safely remove them from existing product directories.
Release 8.0.0 Features
The Progress DataDirect for ODBC for Snowflake provides enhanced
performance over the native ODBC Snowflake driver. It supports create,
read, update, and delete operations. In addition, the driver:
* Serves as a complete pass-through driver, leveraging the SQL engine
functionality of Snowflake to execute SQL queries.
* Supports integration with third-party applications: Tableau, Crystal Reports,
Microsoft Excel, Microsoft Access, Microsoft SQL Linked Server,
SQL Server Integration Services, and Microsoft Power BI.
* Provides proxy support using ProxyHost, ProxyPassword, ProxyPort, and
ProxyUser connection options.
* Supports the handling of large result sets with configurable paging using the
FetchSize connection option.
* The driver supports authentication methods, such as, OAuth and
UserID/Password.
Configuring Data Sources
Data sources are stored in the system information file (typically,
odbc.ini). For details on configuring this file, see the PROGRESS DATADIRECT
FOR ODBC FOR SNOWFLAKE DRIVER USER'S GUIDE.
Notes, Known Problems, and Restrictions
The following are notes, known problems, and restrictions with the latest release
of the driver:
* The driver does not support specifying values for the same connection
option multiple times in a connection string or DSN. If a value is
specified using the same attribute multiple times or using both
long and short attributes, the connection may fail or the driver may
not behave as intended.
* The driver does not support plain text inserts in columns of binary data.
Data inserted into columns containing binary data, requires a conversion
to hex format.
* The driver does not support scrollable cursor operations on result set data.
* The driver supports Windows 32 and 64-bit, Linux 32 and 64-bit platforms.
* The driver gives a warning message when a SELECT query is run for the first
time in a new connection instance, using a console application and OpenJDK 11.
* The OAuth token is valid for 10 minutes, if no connection instance is
established or after a connection instance is terminated. A token does not
expire in an uninterrupted connection instance.
* The active connections viewed on the Snowflake console are termed as JDBC
connections. This is due to the underlying JDBC layer architecture of the
driver.
Driver WorkAround Options
Progress DataDirect has included non-standard connection options (workarounds)
for the driver that enable you to take full advantage of packaged ODBC-enabled
applications requiring non-standard or extended behavior. Refer to the chapter
"WorkAround options" in THE PROGRESS DATADIRECT FOR ODBC DRIVERS REFERENCE for a
description of these options.
Documentation
PROGRESS DATADIRECT FOR ODBC FOR SNOWFLAKE DOCUMENTATION SET
------------------------------------------------------------------------
The driver documentation set is available from the Progress Information Hub:
https://docs.progress.com/category/datadirect-snowflake
You can access the online help system directly via the HTML redirect in the
installation Help directory.
Installed Files for the 32-bit Driver
This file list assumes a full installation of the 32-bit driver and
documentation.
The installer copies the following files and subdirectories to the
product installation directory, by default:
/<install_dir>/:
----------------
odbc.csh Setup script for C shell
odbc.ini Sample odbc.ini file
odbcinst.ini Sample odbcinst.ini file
odbc.sh Setup script for Bourne shell
IVODBC.LIC DataDirect license file
license.txt End User License Agreement
/bin/:
------
ivtestlib Test application to check that required
libraries are present and loadable
/FIXES/:
--------
fixes8.0.txt List of fixes since last release
/help/:
-------
*.html HTML redirects to driver help systems
/include/:
----------
odbcinst.h Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h
/install/:
----------
*.* Files associated with the installer program
/java/lib/:
-----------
snowflake.jar Java components of the driver
/lib/:
------
ivsnowflake28.so DataDirect Driver for Snowflake
ivtrc28.so Progress DataDirect trace library
libivicu.so Unicode conversion tables
libodbc.so ODBC Driver Manager
libodbcinst.so ODBC Installer
/locale/en_US/LC_MESSAGES/:
---------------------------
ivsnowflake28.mo Snowflake driver message file
ivsnowflake28.po Snowflake driver message file source
odbc.m ODBC Driver Manager message file
odbc.po ODBC Driver Manager message source
/NOTICES/:
----------
ODBC for Snowflake v8.0 notices.txt
Third-party vendor license agreements
/READMES/:
----------
ODBC for Snowflake v8.0 readme.txt
This file
/samples/bulkstrm/:
------------------
bulkstrm Bulk streaming example application
bulk.cpp Bulk streaming example source
bulk.hpp Bulk streaming example header
bulkstrm.txt Bulk streaming description
ddlogging.properties Log configuration file for the
Snowflake driver
main.cpp Bulk streaming example source file
msgprintf.hpp Bulk streaming example header file
streambulk.mak Bulk streaming example make file
/samples/example/:
------------------
example Example application
example.c Example source
example.h Example header
example.mak Example make file
ddlogging.properties Log configuration file for the
Snowflake driver
/samples/trn/:
--------------
makefile Translation Library example make file
readme.trn Translation Library example description
translat.c Translation Library example source file
/tools/:
--------
ddencpwd Password Encryption Tool
ddextu License Extender utility
ddprocinfo Processor Information utility
launch_server.sh Script that launches the SQL Engine in
server mode
/uninstall/:
------------
*.* Files used to uninstall the product
Installed Files for the 64-bit Driver
This file list assumes a full installation of the 64-bit driver and
documentation.
The installer copies the following files and subdirectories to the
product installation directory, by default:
/<install_dir>/:
----------------
odbc.csh Setup script for C shell
odbc.ini Sample odbc.ini file
odbcinst.ini Sample odbcinst.ini file
odbc.sh Setup script for Bourne shell
DDODBC.LIC DataDirect license file
license.txt End User License Agreement
/bin/:
------
ddtestlib Test application to check that required
libraries are present and loadable
/FIXES/:
--------
fixes8.0.txt List of fixes since last release
/help/:
-------
*.html HTML redirects to online connector help
systems and documentation resources
/include/:
----------
odbcinst.h Include files
qesqlext.h
sql.h
sqlext.h
sqltypes.h
sqlucode.h
sqlunx.h
/install/:
---------
*.* Files associated with the installer program
/java/lib/:
----------
snowflake.jar Java components of the driver
/lib/:
------
ddsnowflake28.so DataDirect Driver for Snowflake
ddtrc28.so Progress DataDirect trace library
libddicu.so Unicode conversion tables
libodbc.so ODBC Driver Manager
libodbcinst.so ODBC Installer
/locale/en_US/LC_MESSAGES/:
---------------------------
ddsnowflake28.mo Snowflake driver message file
ddsnowflake28.po Snowflake driver message file source
odbc.m ODBC Driver Manager message file
odbc.po ODBC Driver Manager message source
/NOTICES/:
----------
ODBC for Snowflake v8.0 notices.txt
Third-party vendor license agreements
/READMES/:
----------
ODBC for Snowflake v8.0 readme.txt
This file
/samples/bulk/:
---------------
bulk Bulk application
bulk.c Bulk example source
bulk.mak Bulk example make file
bulk.txt Bulk load example readme
ddlogging.properties Log configuration file for the
Snowflake driver
/samples/bulkstrm/:
-------------------
bulkstrm Bulk streaming example application
bulk.cpp Bulk streaming example source
bulk.hpp Bulk streaming example header
bulkstrm.txt Bulk streaming description
ddlogging.properties Log configuration file for the
Snowflake driver
main.cpp Bulk streaming example source file
msgprintf.hpp Bulk streaming example header file
streambulk.mak Bulk streaming example make file
/samples/example/:
------------------
example Example application
example.c Example source
example.h Example header
example.mak Example make file
ddlogging.properties Log configuration file for the
Snowflake driver
/samples/trn/:
--------------
makefile Translation Library example make file
readme.trn Translation Library example description
translat.c Translation Library example source file
/tools/:
--------
ddencpwd Password Encryption Tool
ddextu License Extender utility
ddprocinfo Processor Information utility
launch_server.sh Script that launches the SQL Engine in
server mode
/uninstall/:
------------
*.* Files used to uninstall the product
~~~~~~~~~~~~~~~~~~
February 2026
End of README.TXT