Exasol

https://www.exasol.com

Install

Install Ibis and dependencies for the Exasol backend:

Install with the exasol extra:

pip install 'ibis-framework[exasol]'

And connect:

import ibis

con = ibis.exasol.connect(...)
1
Adjust connection parameters as needed.

Install for Exasol:

conda install -c conda-forge ibis-exasol

And connect:

import ibis

con = ibis.exasol.connect(...)
1
Adjust connection parameters as needed.

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
)
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, timezone='UTC', websocket_sslopt=None, **kwargs)

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. 'localhost'
port int Port number to connect to. 8563
timezone str The session timezone. 'UTC'
websocket_sslopt Mapping[str, int] | None Websocket SSL options, originating from None
kwargs Any Additional keyword arguments passed to pyexasol.connect. {}
Examples
>>> import os
>>> import ibis
>>> host = os.environ.get("IBIS_TEST_EXASOL_HOST", "localhost")
>>> user = os.environ.get("IBIS_TEST_EXASOL_USER", "sys")
>>> password = os.environ.get("IBIS_TEST_EXASOL_PASSWORD", "exasol")
>>> schema = os.environ.get("IBIS_TEST_EXASOL_DATABASE", "EXASOL")
>>> con = ibis.exasol.connect(schema=schema, host=host, user=user, password=password)
>>> con.list_tables()
[...]
>>> t = con.table("functional_alltypes")
>>> t
DatabaseTable: functional_alltypes
  id              int32
  bool_col        boolean
  tinyint_col     int16
  smallint_col    int16
  int_col         int32
  bigint_col      int64
  float_col       float64
  double_col      float64
  date_string_col string(256)
  string_col      string(256)
  timestamp_col   timestamp(3)
  year            int32
  month           int32
Back to top