Exasol Driver 0.12.6¶
Driver Version 0.12.6 Release Date 2026-06-08 Tested With Exasol 2025
This driver provides access to Exasol , an in-memory analytics engine. It is developed by Exasol Labs. The source code can be found at exarrow-rs ; the ADBC Driver Foundry distributes precompiled binaries of the upstream sources for Linux, macOS, and Windows.
Note
This page provides some ADBC-specific documentation. For full documentation and examples, see the upstream repository: https://github.com/exasol-labs/exarrow-rs .
Installation¶
The Exasol driver can be installed with dbc :
dbc install exasol
Connecting¶
To use the driver, provide the URI of an Exasol database as the uri option.
from adbc_driver_manager import dbapi
conn = dbapi.connect(
driver="exasol",
db_kwargs={
"uri": "exasol://user:pass@localhost:8563/?tls=true&validateservercertificate=0",
}
)
Full documentation for the connection string format can be found at exarrow-rs .
Note: The example above is for Python using the adbc-driver-manager package but the process will be similar for other driver managers. See adbc-quickstarts .
Feature & Type Support¶
| Feature | Exasol | |
|---|---|---|
| Bulk Ingestion | Create | ❌ |
| Append | ❌ | |
| Create/Append | ❌ | |
| Replace | ❌ | |
| Temporary Table | ❌ | |
| Target Catalog | ❌ | |
| Target Schema | ❌ | |
| Non-nullable fields are marked NOT NULL | ❌ | |
| Catalog (GetObjects) | depth=catalogs | ✅ |
| depth=db_schemas | ✅ | |
| depth=tables | ✅ | |
| depth=columns (all) | ✅ | |
| Get Parameter Schema | ✅ | |
| Get Table Schema | ✅ | |
| Prepared Statements | ✅ | |
| Transactions | ✅ | |
Types¶
Database to Arrow¶
| Database Type | Exasol |
|---|---|
|
BIGINT |
decimal128 |
|
BOOLEAN |
bool |
|
DATE |
date32[day] |
|
DECIMAL |
decimal128 |
|
DOUBLE PRECISION |
double |
|
HASHTYPE |
❌ [1] |
|
INT |
decimal128 |
|
INT/INTEGER |
decimal128 |
|
NUMERIC |
decimal128 |
|
REAL |
double |
|
SHORTINT/SMALLINT |
decimal128 |
|
SMALLINT |
decimal128 |
|
TIMESTAMP |
timestamp[us] |
|
VARCHAR |
string |
Arrow to Database¶
| Arrow Type | Exasol Type | |
|---|---|---|
| Bind | Ingest | |
|
binary |
❌ |
|
|
binary_view |
❌ |
|
|
bool |
❌ |
|
|
date32[day] |
❌ |
|
|
decimal128 |
❌ |
|
|
double |
❌ |
|
|
fixed_size_binary |
❌ |
|
|
float |
❌ |
|
|
halffloat |
❌ |
(NA/not tested) |
|
int16 |
❌ |
|
|
int32 |
❌ |
|
|
int64 |
❌ |
|
|
large_binary |
❌ |
|
|
large_string |
❌ |
|
|
string |
❌ |
|
|
string_view |
❌ |
|
|
time32[ms] |
❌ |
|
|
time32[s] |
❌ |
|
|
time64[ns] |
❌ |
|
|
time64[us] |
❌ |
|
|
timestamp[ms] |
❌ |
|
|
timestamp[ms] (with time zone) |
❌ |
|
|
timestamp[ns] |
❌ |
|
|
timestamp[ns] (with time zone) |
❌ |
|
|
timestamp[s] |
❌ |
|
|
timestamp[s] (with time zone) |
❌ |
|
|
timestamp[us] |
❌ |
|
|
timestamp[us] (with time zone) |
❌ |
|
Previous Versions¶
To see documentation for previous versions of this driver, see the following: