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', **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'`
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
  string_col      string
  timestamp_col   timestamp(3)
  year            int32
  month           int32