Exasol¶
Driver Version 0.7.0 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 | Support | |
|---|---|---|
| Bulk Ingestion | Create | ❌ |
| Append | ❌ | |
| Create/Append | ❌ | |
| Replace | ❌ | |
| Temporary Table | ❌ | |
| Specify target catalog | ❌ | |
| Specify 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¶
Exasol to Arrow¶
Exasol Type |
Arrow Type |
|---|---|
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 Exasol¶
| Arrow Type | Exasol Type | |
|---|---|---|
| Bind | Ingest | |
|
binary |
❌ |
|
|
binary_view |
❌ |
|
|
bool |
❌ |
|
|
date32[day] |
❌ |
|
|
decimal128 |
❌ |
|
|
double |
❌ |
|
|
fixed_size_binary |
❌ |
|
|
float |
❌ |
|
|
halffloat |
❌ |
(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: