atoti.Session#

final class atoti.Session#

The entry point to interact with Atoti applications.

A session holds data in tables and aggregates it in cubes. It also serves a web app for data exploration accessible with link.

It can be created with either start() or connect().

add_external_table

Add a table from an external database to the session.

close

Close this session and free all associated resources.

connect

Connect to an existing session.

connect_to_external_database

Connect to an external database using DirectQuery.

create_cube

Create a cube based on the passed table.

create_scenario

Create a new source scenario.

create_table

Create an empty table with columns of the given types.

cubes

data_model_transaction

Create a data model transaction to batch multiple data model changes.

delete_scenario

Delete the source scenario with the provided name if it exists.

endpoint

Create a custom endpoint at /atoti/pyapi/{route}.

export_translations_template

Export a template containing all translatable values in the session's cubes.

link

Link to the session.

logs_path

Path to the session logs file.

query_mdx

Execute an MDX query.

read_arrow

Read an Arrow Table into a table.

read_csv

Read a CSV file into a table.

read_numpy

Read a NumPy 2D array into a new table.

read_pandas

Read a pandas DataFrame into a table.

read_parquet

Read a Parquet file into a table.

read_spark

Read a Spark DataFrame into a table.

read_sql

Create a table from the result of the passed SQL query.

ready

Whether the session is ready or not.

scenarios

Names of the source scenarios of the session.

security

start

Start a new Atoti server subprocess and connect to it.

tables

url

URL of the session.

wait

Wait for the underlying server subprocess to terminate.

widget

Widget to visualize the data in the session interactively.