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:
dbc install exasol
Exasol URI structure
The following URI format is supported by the ADBC driver for Exasol:
exasol://[user[:password]@]host[:port][/schema][?params]
Examples:
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
|
tls
|
boolean |
Enable TLS/SSL encryption Accepted values: |
true
|
validate_certificate
|
boolean |
Validate the server’s TLS certificate Accepted values: |
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 |
- |
user/username |
string | Alternative to user:password@ in the URL |
[empty] |
password/pass |
string | Alternative to :password@ in the URL |
[empty] |