Exasol

https://www.exasol.com

Install

Install Ibis and dependencies for the Exasol backend:

pip

Install with the exasol extra:

pip install 'ibis-framework[exasol]'

And connect:

import ibis

con = ibis.exasol.connect(...)

1

Adjust connection parameters as needed.

conda

Install for Exasol:

conda install -c conda-forge ibis-exasol

And connect:

import ibis

con = ibis.exasol.connect(...)

1

Adjust connection parameters as needed.

mamba

Install for Exasol:

mamba install -c conda-forge ibis-exasol

And connect:

import ibis

con = ibis.exasol.connect(...)

1

Adjust connection parameters as needed.

Connect

ibis.exasol.connect

con = ibis.exasol.connect(
    user = "username",
    password = "password",
    host = "localhost",
    port = 8563,
    schema = None,
    encryption = True,
    certificate_validation = True,
    encoding = "en_US.UTF-8"
)

Note

ibis.exasol.connect is a thin wrapper around ibis.backends.exasol.Backend.do_connect.

Connection Parameters

do_connect

do_connect(self, user, password, host='localhost', port=8563, schema=None, encryption=True, certificate_validation=True, encoding='en_US.UTF-8')

Create an Ibis client connected to an Exasol database.

Parameters

Name	Type	Description	Default
user	str	Username used for authentication.	required
password	str	Password used for authentication.	required
host	str	Hostname to connect to (default: “localhost”).	'localhost'
port	int	Port number to connect to (default: 8563)	8563
schema	str | None	Database schema to open, if None, no schema will be opened.	None
encryption	bool	Enables/disables transport layer encryption (default: True).	True
certificate_validation	bool	Enables/disables certificate validation (default: True).	True
encoding	str	The encoding format (default: “en_US.UTF-8”).	'en_US.UTF-8'