Getting Started#

There are three ways to get started with Exasol:

In the following we are going to use the SaaS version.

Setting up the db#

Our main documentation shows you how to create a SaaS account and setup your first database and cluster.

Installing pyexasol#

Once your database is up and running you can connect via any client. From Python we use PyExasol. It can be easily installed via

pip install pyexasol[pandas]

Connecting to the db#

Connecting to an Exasol database is performed via:

import pyexasol

C = pyexasol.connect(dsn='<host:port>', user='sys', password='exasol')

It is slightly different when connecting to a SaaS database as we need a personal access token:

import pyexasol

C = pyexasol.connect(dsn='<host:port>', user='sys', password='<token>')

Finally you can also wrap all credentials into a local config file:

C = pyexasol.connect_local_config('my_exasol')

Executing SQL#

Running your first query is pretty straightforward:

stmt = C.execute("SELECT * FROM EXA_ALL_USERS")

for row in stmt:
    print(row)

It also allows you to load resultsets into a pandas dataframe:

C = pyexasol.connect(dsn='<host:port>', user='sys', password='exasol', compression=True)

df = C.export_to_pandas("SELECT * FROM EXA_ALL_USERS")
print(df.head())