Quick reference
Point a SQL tool at the database, then explore TPC-H, the classic decision-support benchmark. One dataset, three questions by role. Copy the SQL, run it, read the answer.
Your password is generated locally on install and never shared. Get yours with:
exakit info
then read the file it points to, for example:
cat ~/.exasol-starter-kit/credentials/personal_sys_password
New Connection, pick the Exasol driver, then enter the details above.
Create a database connection with the Exasol driver, same host, port and user.
Comes preinstalled in its own environment. Connect straight from Python.
Open a SQL shell right in your terminal.
exapump interactive -p starter-kit
A hosted console for exploring an Exasol database, local or remote, with a temporary AI assistant included. A quick way to try things before you install the kit.
SELECT c.C_MKTSEGMENT AS segment,
COUNT(o.O_ORDERKEY) AS order_count,
ROUND(SUM(o.O_TOTALPRICE), 2) AS total_revenue
FROM TPCH.CUSTOMER c
JOIN TPCH.ORDERS o ON c.C_CUSTKEY = o.O_CUSTKEY
GROUP BY c.C_MKTSEGMENT
ORDER BY total_revenue DESC;DESCRIBE TPCH.ORDERS;
SELECT r.R_NAME AS region,
SUM(o.O_TOTALPRICE) AS total_sales,
COUNT(o.O_ORDERKEY) AS order_count
FROM TPCH.ORDERS o
JOIN TPCH.CUSTOMER c ON o.O_CUSTKEY = c.C_CUSTKEY
JOIN TPCH.NATION n ON c.C_NATIONKEY = n.N_NATIONKEY
JOIN TPCH.REGION r ON n.N_REGIONKEY = r.R_REGIONKEY
GROUP BY r.R_NAME
ORDER BY total_sales DESC;