ADBC driver

Learn how to install and configure the Exasol ADBC driver for connecting tools with an Exasol database.

ADBC is a standardized set of APIs and libraries for accessing databases using the Apache Arrow columnar format. This article explains how to install the Exasol ADBC driver and describes the parameters that can be passed in the connection string.

Precompiled binaries for the Exasol ADBC driver are distributed by the ADBC Driver Foundry. More technical details, examples, and source code can be found at exarrow-rs on GitHub.

Install the ADBC driver

Install the ADBC driver with dbc:

Copy
dbc install exasol

Exasol URI structure

The following URI format is supported by the ADBC driver for Exasol:

Copy
exasol://[user[:password]@]host[:port][/schema][?params]
Examples:
Copy
exasol://localhost:18563
exasol://my_user:my_password@localhost:18563
exasol://my_user:my_password@exasol.example.com:18563/my_schema
exasol://my_user:my_password@exasol.example.com:18563/my_schema?connection_timeout=60

If the port is omitted, the default Exasol database port 8563 is used. If the database uses a different port, you must specify the port explicitly in the connection string.

Supported parameters

The following table describes all parameters that can be set via URI query string (?key=value&key2=value2).

TLS encryption is required by default for all connections. If using TLS is not possible and you trust the server, you can include the server fingerprint in the URI.

Parameter Type Description Default
transport string

Transport protocol

Accepted values: native (default) or websocket (requires websocket feature)

native
tls boolean

Enable TLS/SSL encryption

Accepted values: true, false

true
validate_certificate boolean

Validate the server’s TLS certificate

Accepted values: true, false

true
certificate_fingerprint string Pin connection to a specific server certificate (SHA-256 hex of DER cert) [empty]
connection_timeout number Connection timeout in seconds (max 300) 30
query_timeout number

Query timeout in seconds

When unset, no attribute is set and the server’s own QUERY_TIMEOUT governs. The driver imposes no client-side timer.

-
user/username string Alternative to user:password@ in the URL [empty]
password/pass string Alternative to :password@ in the URL [empty]