Changelog

Documentation Index

Fetch the complete documentation index at: https://docs.activeviam.com/llms.txt

Use this file to discover all available pages before exploring further.

​

0.9.15

​

Changed

• Upgraded Atoti Server to 6.1.20.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.24.
• The Atoti UI app is served using its development build when __debug__ is True. It is strongly recommended to use Python’s optimized mode in production to avoid this development build’s overhead.
• Accept using the JDK that the JAVA_HOME environment variable points to even if its version is greater than 21.

​

Fixed

• data_model_transaction() raising IllegalStateException: Structural transaction must be committed by the thread starting it depending on the order of operations inside it ¹.
• create_cube() from an external table with mode="no_measures" and a filter sending unfiltered APPROX_COUNT_DISTINCT queries for virtual hierarchy detection ².

​

Internal issue tracker references

• [1] PYTHON-753
• [2] PYTHON-869

​

0.9.14

​

Added

• OpenTelemetry spans around the main functions and methods of the library. See atoti_observability for example traces.

​

Changed

• Upgraded Atoti Server to 6.1.19.

​

Deprecated

• atoti_directquery_databricks.ConnectionConfig.array_sum_agg_function_name, array_long_agg_function_name, array_short_agg_function_name, and array_sum_product_agg_function_name. Spark UDAFs API has been deprecated as it is not recommended by Databricks anymore, use array conversion instead ⁴.

​

Fixed

• QueryCube’s hierarchies not being visible by default. ³.
• ModuleNotFoundError raised by atoti-client when atoti-client-parquet is not installed.

​

Internal issue tracker references

• [3] PYTHON-798
• [4] PYTHON-817

​

0.9.13

​

Added

• shift()’s mode parameter ⁶.
• Documentation for atoti-observability.
• Documentation for the ROLE_MEASURE_LINEAGE role in atoti.security.Security.
• atoti_jdbc.JdbcPingDiscoveryProtocol.update_store_on_view_change ¹⁰.

​

Changed

• Upgraded Atoti Server to 6.1.18.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.20.
• Renamed cloud storage packages:
  • atoti-client-aws → atoti-client-storage-aws
  • atoti-server-aws → atoti-server-storage-aws
  • atoti-client-azure → atoti-client-storage-azure
  • atoti-server-azure → atoti-server-storage-azure
  • atoti-client-gcp → atoti-client-storage-gcp
  • atoti-server-gcp → atoti-server-storage-gcp
  The module names have also changed:
  • atoti_aws → atoti_storage_aws
  • atoti_azure → atoti_storage_azure
  • atoti_gcp → atoti_storage_gcp
  - uv add "atoti[aws]"
  + uv add "atoti[storage-aws]"
  
  - from atoti_aws import ClientSideEncryptionConfig
  + from atoti_storage_aws import ClientSideEncryptionConfig
  

​

Deprecated

• atoti-client-aws, atoti-server-aws, and the atoti_aws module. Use atoti-client-storage-aws, atoti-server-storage-aws, and atoti_storage_aws instead.
• atoti-client-azure, atoti-server-azure, and the atoti_azure module. Use atoti-client-storage-azure, atoti-server-storage-azure, and atoti_storage_azure instead.
• atoti-client-gcp, atoti-server-gcp, and the atoti_gcp module. Use atoti-client-storage-gcp, atoti-server-storage-gcp, and atoti_storage_gcp instead.

​

Fixed

• NotImplementedError raised when creating a == condition on a column operation ⁸, ⁹.
• atoti.Column.data_type and atoti.Column.default_value raising an error when accessed on a connected session using the "Object" data type ⁵.
• Setting MDX-related context values with shared_context not being reflected in subsequent access to shared_context in data cubes and raising an error in query cubes ⁷.

​

Internal issue tracker references

• [5] PIVOT-12311
• [6] PYTHON-703
• [7] PYTHON-768
• [8] PYTHON-774
• [9] PYTHON-775
• [10] PYTHON-789

​

0.9.12

​

Added

• atoti.SecurityConfig.login.

​

Changed

• Upgraded Atoti Server to 6.1.16.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.18.
• Loading Apache Parquet files requires the new atoti-client-parquet and atoti-server-parquet packages ¹¹. Installing the atoti package also installs these packages but the next breaking release will make them opt-in.
  - uv add "atoti"
  + uv add "atoti[parquet]"
  
  If you do no use Parquet files and wish to reduce the size of your dependencies, you can skip the installation of the atoti package and manually install the atoti-client and atoti-server packages instead:
  - # Also installs atoti-client-parquet and atoti-server-parquet.
  - uv add "atoti"
  + # Does not install atoti-client-parquet and atoti-server-parquet.
  + uv add "atoti-client" "atoti-server"
  
  Or, if you use some extras:
  - uv add "atoti[jdbc]"
  + uv add "atoti-client[jdbc]" "atoti-server[jdbc]"
  

​

Deprecated

• atoti.ParquetLoad ¹¹. Use atoti_parquet.ParquetLoad instead:
  - from atoti import ParquetLoad
  + from atoti_parquet import ParquetLoad
  
• read_parquet() since support for Apache Parquet will become opt-in ¹¹. Use infer_data_types(), create_table(), and load() instead:
  - table = session.read_parquet(path, table_name="Example")
  + parquet_load = ParquetLoad(path)
  + data_types = session.tables.infer_data_types(parquet_load)
  + table = session.create_table("Example", data_types=data_types)
  + table.load(parquet_load)
  
• atoti.Session.query_mdx() and atoti.Cube.query()’s timeout parameter ¹². The default value has also been changed from datetime.timedelta(seconds=30) to None to automatically use shared_context’s queriesTimeLimit . Use the context parameter to specify a custom timeout:
  - session.query_mdx(mdx, timeout=datetime.timedelta(seconds=10))
  + session.query_mdx(mdx, context={"queriesTimeLimit": 10})
  
  - cube.query(m["contributors.COUNT"], timeout=datetime.timedelta(seconds=10))
  + cube.query(m["contributors.COUNT"], context={"queriesTimeLimit": 10})
  

​

Fixed

• Atoti Admin UI connecting to wrong server due to wrong order of WebJars in the server’s classpath ¹⁴.
• Hierarchies disappearing from the Data model tree when editing the data model of a secured session ¹³.

​

Internal issue tracker references

• [11] PIVOT-12663
• [12] PYTHON-447
• [13] PYTHON-742
• [14] PYTHON-755

​

0.9.11

​

Added

• atoti.Hierarchy.description ¹⁸.
• pandas<3.0.0rc0 upper bound to avoid breaking changes from the new str dtype ²⁰.

​

Changed

• Upgraded Atoti Server to 6.1.15.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.17.
• atoti.Measure.description returns "" instead of None ¹⁸.
• Everything related to Security is kept in memory instead of being persisted in the user_content_storage ¹⁵. This makes the API more consistent since all the other methods on atoti.Session and its related classes never persisted their changes either. This improves performance, both when configuring these properties but also when executing queries.
  Basic authentication credentials are unaffected since, for security reasons, they were already only kept in memory.

​

Deprecated

• atoti.Measure.description’s deleter ¹⁸. Set the description to a blank string instead:
  - del measure.description
  + measure.description = ""
  

​

Fixed

• Data model search bar display issue in JupyterLab extension ²¹.
• Truncated response bodies when using proxy or endpoint() ¹⁶.
• This operation is not supported while batching mutations error raised when requesting an endpoint() ¹⁹.
• Users configured through basic_authentication unable to connect when the configured LDAP server is unreachable ¹⁷.

​

Internal issue tracker references

• [15] PYTHON-716
• [16] PYTHON-717
• [17] PYTHON-728
• [18] PYTHON-733
• [19] PYTHON-737
• [20] PYTHON-739
• [21] PYTHON-745

​

0.9.10

​

Added

• Support for Python 3.14 ²³.
• Dependencies page.

​

Changed

• Upgraded Atoti Server to 6.1.13.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.15.
• Installation instructions with Conda to recommend Miniforge over Anaconda’s installer to not be tied to Anaconda’s license requirements ²⁴.
• Configuring branding does not remove the By ActiveViam signature at the bottom right corner of the app anymore. It is still possible to remove this signature through a custom app extension ²².

​

Internal issue tracker references

• [22] PYTHON-590
• [23] PYTHON-712
• [24] PYTHON-715

​

0.9.9.2

​

Added

• ROLE_ADMIN to atoti.Hierarchy.viewers’s default value ²⁶.

​

Changed

• Improved planning of MDX queries requesting many specific cells of the cube ²⁵.
• Reduce number of requests made when representing (or evaluating in a Jupyter notebook cell) cubes, levels, measures, etc of a connected session ²⁷.

​

Fixed

• SSL: CERTIFICATE_VERIFY_FAILED error when requesting a custom endpoint() on a Session configured with https ²⁸.

​

Internal issue tracker references

• [25] PIVOT-12464
• [26] PYTHON-697
• [27] PYTHON-698
• [28] PYTHON-705

​

0.9.9.1

​

Changed

• Improved planning of MDX queries requesting many specific cells of the cube ²⁹.

​

Fixed

• ArrayIndexOutOfBoundsException when running some MDX queries ³⁰.
• AssertionError: Output has already been set when deleting a cube ³².
• GraphQLClientGraphQLMultiError: Structural transaction must be committed by the thread starting it when setting atoti.Measure.visible inside a data_model_transaction() ³¹.

​

Internal issue tracker references

• [29] PIVOT-12032
• [30] PIVOT-12336
• [31] PYTHON-691
• [32] PYTHON-696

​

0.9.9

​

Added

• plugin_measure() ³⁸.
• atoti.Session.client ³⁶.
• Spring Boot Admin plugin ³³.
• atoti_directquery_snowflake.ConnectionConfig.main_warehouse_name ³⁴.

​

Changed

• Upgraded Atoti Server to 6.1.12.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.13.
• Improved the logic used in atoti.Session.link and atoti.Session.widget to find the URL from which the Session can be reached from the JupyterLab extension ³⁵. For instance, if Jupyter Server is running at https://1.9.9.1:8888 and the Atoti session is running on the same machine but on port 1337, the browser will try to reach the session from https://1.9.9.1:1337.

​

Fixed

• Incorrect MdxQueryResult when disabling light crossjoin ³⁷.
• Regression introduced in version 0.9.8 where atoti.Session.endpoint would not handle URL encoded characters correctly ³⁹.
• Inability to use Basic Authentication in requests made to custom endpoints when the session is secured with OIDC ⁴⁰.

​

Internal issue tracker references

• [33] PIVOT-12095
• [34] PYTHON-592
• [35] PYTHON-621
• [36] PYTHON-629
• [37] PYTHON-632
• [38] PYTHON-634
• [39] PYTHON-677
• [40] PYTHON-678

​

0.9.8

​

Added

• atoti.Session.proxy and atoti.Session.user ⁴¹.

​

Changed

• Upgraded Atoti Server to 6.1.11.
• When atoti.JwtConfig.key_pair is None, the automatically generated key pair will use 3072 bits instead of the old 2048 bits.

​

Deprecated

• Requests to endpoints created with atoti.Session.endpoint should now use /proxy instead of /atoti/pyapi. /atoti/pyapi remains available but logs a warning when used ⁴¹.
• The atoti.pyapi module is deprecated, import its classes directly from atoti.User or atoti.endpoint.Request instead ⁴¹.

​

Fixed

• Performance regression when editing measures inside a data_model_transaction() ⁴².

​

Internal issue tracker references

• [41] PYTHON-545
• [42] PYTHON-650

​

0.9.7

​

Added

• atoti.Hierarchy.viewers ⁴⁵.
• atoti.Hierarchy.folder ⁴⁶.
• atoti.SecurityConfig.cors ⁴⁴.
• atoti.finance.irr()’s period and guess parameters ⁴⁹.

​

Changed

• Upgraded Atoti Server to 6.1.10.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.10.
• atoti.AggregateProvider.measures can be set to None to pre-aggregate all eligible measures ⁴⁸.
• Measures can no longer be defined in a data Cube once it joined a distribution cluster. The measures must be defined before setting atoti.Session.clusters, or the session must be started with atoti.SessionConfig.ready set to False with atoti.Session.ready set to True only once all measures have been defined ⁴³.

​

Deprecated

• atoti.Hierarchy.visible setter ⁴⁵. Use atoti.Hierarchy.viewers instead:
  - hierarchy.visible = False
  + hierarchy.viewers.clear()
  - hierarchy.visible = True
  + hierarchy.viewers.add("ROLE_USER")
  
• Passing multiple levels of the same hierarchy to atoti.AggregateProvider.levels. Only pass the deepest level instead:
  - tt.AggregateProvider(levels={l["Geography", "Country"], l["Geography", "City"]})
  + tt.AggregateProvider(levels={l["Geography", "City"]})
  
• Passing sequences to atoti.AggregateProvider.levels or atoti.AggregateProvider.measures. Pass sets instead:
  - tt.AggregateProvider(levels=[l["foo"]], measures=[m["bar"]])
  + tt.AggregateProvider(levels={l["foo"]}, measures={m["bar"]})
  

​

Fixed

• where() rejecting condition if it contained a ~hierarchy.isin(...) or ~level.isin(...) leaf ⁴⁷.
• atoti.finance.irr() returning nan when the actual rate was too large ⁴⁹.

​

Internal issue tracker references

• [43] PIVOT-11612
• [44] PIVOT-11652
• [45] PYTHON-552
• [46] PYTHON-593
• [47] PYTHON-610
• [48] PYTHON-615
• [49] PYTHON-623

​

0.9.6

​

Added

• allow_data_duplication and atoti.Session.create_cube()’s priority parameter ⁵¹.
• unload_members_from_data_cube() and atoti.Session.create_cube()’s id_in_cluster parameter ⁵⁰.
• Support for condition on hierarchy members (not only member paths) in atoti.Cube.query()’s filter parameter ⁵².
• atoti.date_shift()’s dense parameter ⁵⁶.
• experimental() context manager.

​

Changed

• Upgraded Atoti UI and Atoti Admin UI to 5.2.8.
• Upgraded Atoti Server to 6.1.8.
• The functions that were in the atoti.experimental subpackage have been moved outside of it and require passing their feature key to experimental():
  - tt.experimental.agg.distinct(...)
  + with tt.experimental({"agg.distinct"}):
  +   tt.agg.distinct(...)
  

​

Deprecated

• Deleting a level through atoti.Cube.levels. Redefine its hierarchy instead:
  - del l["Geography", "City"]
  + h["Geography"] = [l["Continent"], l["Country"]]
  
• atoti.date_shift()’s method parameter ⁵⁶. The new parameter name is fallback:
    tt.date_shift(
      m["Price"],
      h["Date"],
  -   method="previous",
  +   fallback="past",
      offset="P1M",
    )
  

​

Fixed

• Display of join labels in atoti.tables.Tables.schema ⁵⁴.
• atoti.where()’s returned measure evaluating incorrectly when using | within another condition ⁵³.
• Behavior of get() when setting mapping_lookup()’s check to False.
• Missing continuous query updates when using measures such as atoti.agg.sum() with CumulativeScope ⁵⁵.

​

Internal issue tracker references

• [50] PYTHON-538
• [51] PYTHON-542
• [52] PYTHON-554
• [53] PYTHON-581
• [54] PYTHON-584
• [55] PYTHON-586
• [56] PYTHON-591

​

0.9.5

​

Security

​

SSO

​

Database access

​

Dependencies

• Upgraded Atoti UI and Atoti Admin UI to 5.2.7.
• Upgraded Atoti Server to 6.1.6.

​

Fixed

​

Data loading

Cloud storage

​

Data modeling

Conditions

​

Table columns

• "LocalDate" are LocalDate.MIN and LocalDate.MAX,
• "LocalDateTime" are LocalDateTime.MIN and LocalDateTime.MAX.

​

Measures

• The type annotation of filter()’s filter parameter never allowed inverted atoti.Level.isin() conditions (e.g. ~level.isin("foo", "bar")) but, by chance, these conditions actually behaved as expected at runtime. However, 0.9.4 introduced runtime validation of condition types which lead to the rejection of these conditions. This regression is fixed: the type annotation of filter accepts these conditions and they are supported at runtime ⁶⁰.
• Passing isnull conditions to atoti.where() raised an UnknownUnderlyingMeasureRuntimeException ⁶¹.

​

Internal issue tracker references

• [57] PIVOT-11110
• [58] PYTHON-528
• [59] PYTHON-529
• [60] PYTHON-534
• [61] PYTHON-536
• [62] PYTHON-539
• [63] PYTHON-548

​

0.9.4

​

Distribution

​

Performance

​

Client/server communication

new_measure = tt.agg.sum(
    m["Foo.SUM"], # 1
    scope=tt.OriginScope({
        l["Bar"], # 2
        l["Baz"], # 3
    })
)

​

Cube queries

- cube.aggregates_cache.capacity = 200
+ cube.aggregate_cache = tt.AggregateCache(capacity=200)
- cube.aggregates_cache.capacity = -1
+ del cube.aggregate_cache

​

Hierarchy creation

​

Data modeling

​

Measures

m["8"] = 8
m["Test"] = tt.where(
    {
        m["8"] < 5: -1, # False
        m["8"] >= 5: 1, # True
        m["8"] < 10: -1, # True
    },
    default=0,
)

​

Table columns

​

Data loading

​

Transactions

​

CSV

​

Dependencies

• Atoti Server has been upgraded to 6.1.4.
• Atoti UI and Atoti Admin UI have been upgraded to 5.2.6.

​

Internal issue tracker references

• [64] PIVOT-10472
• [65] PIVOT-10571
• [66] PIVOT-10678
• [67] PIVOT-10995
• [68] PYTHON-190
• [69] PYTHON-296

​

0.9.3

​

Added

• Support for Python 3.13.
• Support for Measure conditions in query().

​

Changed

• Upgraded Atoti Server to 6.1.3.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.4.
• SessionConfig and its inner classes validate that passed Path attributes exist. It prevents situations such as passing a path containing a typo to extra_jars and being confused that the JAR’s classes still cannot be loaded.

​

Fixed

• read_parquet() and ParquetLoad not being able to load Parquet files with extension other than .parquet.
• NullPointerException returned by the server when executing some MDX queries.

​

0.9.2

​

Added

• infer_data_types(), load(), and load_async() methods. Combined with the existing create_table() and data_transaction() methods, they form the preferred way to create tables and load data into them.
• atoti_jdbc.JdbcLoad.parameters to bind variables to queries and avoid SQL injection.
• Runtime check that atoti.OidcConfig.scopes includes the required "openid" scope.

​

Documentation

• Pressing the y key after clicking on an anchor in a page under https://docs.activeviam.com/products/atoti/python-sdk/latest/ will permalink the URL by replacing latest with the corresponding version.

​

Changed

• Upgraded Atoti Server to 6.1.2.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.3.
• To support remote clusters, atoti.Session.read_spark() and atoti.Table.load_spark() convert the passed Spark DataFrame to an in-memory Pandas DataFrame instead of exporting it to a Parquet file.

​

Deprecated

• atoti.Table.append():
  - table.append(*rows)
  + table.load(pd.DataFrame(rows, columns=list(table)))
  
• atoti.Table.load_arrow():
  - table.load_arrow(arrow_table)
  + table.load(arrow_table)
  
• atoti.Table.load_csv():
  - table.load_csv(path)
  + table.load(tt.CsvLoad(path))
  
• atoti.Table.load_kafka():
  - table.load_kafka(...)
  + from atoti_kafka import KafkaStream
  + table.stream(KafkaStream(...))
  
• atoti.Table.load_numpy():
  - table.load_numpy(numpy_array)
  + table.load(pd.DataFrame(numpy_array, columns=list(table)))
  
• atoti.Table.load_pandas():
  - table.load_pandas(pandas_df)
  + table.load(pandas_df)
  
• atoti.Table.load_parquet():
  - table.load_parquet(path)
  + table.load(atoti_parquet.ParquetLoad(path))
  
• atoti.Table.load_spark()
  - table.load_spark(spark_df)
  + table.load(spark_df.toPandas())
  
• atoti.Table.load_sql():
  - table.load_sql(query, url=url)
  + from atoti_jdbc import JdbcLoad
  + table.load(JdbcLoad(query, url=url))
  
• atoti.Session.read_numpy():
  - table = session.read_numpy(numpy_array, columns=columns)
  + table = session.read_pandas(pd.DataFrame(numpy_array, columns=columns))
  
• atoti.Session.read_spark():
  - table = session.read_spark(spark_df)
  + table = session.read_pandas(spark_df.toPandas())
  
• atoti.Session.read_sql():
  - table = session.read_sql(query, table_name=table_name, url=url)
  + from atoti_jdbc import JdbcLoad
  + jdbc_load = JdbcLoad(query, url=url)
  + data_types = session.tables.infer_data_types(jdbc_load)
  + table = session.create_table(table_name, data_types=data_types)
  + table.load(jdbc_load)
  
• create_table(), read_arrow(), read_csv(), read_pandas(), read_parquet()’s types parameter. Use the data_types parameter instead.
• Inference of read_csv() and read_parquet()’s table_name parameter. Pass a table_name argument instead.

​

Fixed

• RecursionError being raised when passing more than 296 cases to where().
• KeyError being raised when using a Level as a key in switch()’s cases parameter.
• Snapshotting of widget in JupyterLab >= 4.2 by setting windowingMode to "defer".

​

0.9.1

​

Added

• Support for Live extension to atoti.Session.connect().

​

Changed

• Upgraded Atoti Server to 6.1.1.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.1.

​

Fixed

• Incorrect use of credentials when reading from S3 in atoti-storage-aws.
• atoti.Cube.query()’s include_totals not including sub totals of multilevel slicing hierarchies.

​

0.9.0

​

Added

• atoti-directquery-jdbc to connect to an external database through JDBC.
• data_model_transaction(). Batching measure creation with a data model transaction has the same performance as using Measures.update() without being limited to independent measures:
  - m.update({"foo": 13, "bar": 42})
  - m.update({"foo + 1": m["foo"] + 1, "bar + 1": m["bar"] + 1})
  + with session.data_model_transaction():
  +    m["foo"] = 13
  +    m["foo + 1"] = m["foo"] + 1
  +    m["bar"] = 42
  +    m["bar + 1"] = m["bar"] + 1
  
  Data model transactions also replace the private API relying on atoti.MeasureMetadata:
  - m["foo"] = (13, tt.MeasureMetadata(visible=True))
  - m["bar"] = (42, tt.MeasureMetadata(description="The answer"))
  + with session.data_model_transaction():
  +    m["foo"] = 13
  +    m["foo"].visible = True
  +    m["bar"] = 42
  +    m["bar"].description = "The answer"
  
• atoti_directquery_redshift.ConnectionConfig.connection_pool_size.

​

User interface

• Filters tool in the sidebar of the JupyterLab extension to see default filters.

​

Changed

​

Packaging

• The atoti package and most of its plugins (e.g. atoti-aws, atoti-directquery-directquery, atoti-kafka etc.) have been split into atoti-client-* and atoti-server-* packages. The atoti-client-* packages contain the Python code composing the API while the atoti-server-* packages mostly contain the JARs implementing the corresponding features. The advanced installation section explains the goal of this split. The atoti package still exists but has become empty, it is only there to provide a convenient way to install both client and server packages. For instance:
  • pip install atoti will install both atoti-client and atoti-server . It will actually also install jdk4py. Note: jdk4py is not a dependency of atoti-server so that projects willing to use another JDK can avoid installing jdk4py by dependending on atoti-client and atoti-server directly.
  • pip install "atoti[aws]" will install atoti-client, atoti-aws-client, atoti-aws-server, and atoti-server.
  • pip install "atoti[jupyterlab]" will install atoti-client, atoti-server, and atoti-jupyterlab (no client/server split for this package because it only contains frontend assets).
  Because Conda does not support “extras”, the installation of Atoti plugins with this package manager is more complex. For instance, the command to install atoti and its AWS plugin is: conda install atoti atoti-client-aws atoti-server-aws.

​

Session start and configuration

• atoti.Session.__init__() has been replaced with atoti.Session.start() for symmetry with atoti.Session.connect() (the removed section gives more details about that latter method):
  - session = tt.Session()
  + session = tt.Session.start()
  
  The top-level config parameters have been grouped into a SessionConfig dataclass providing better error reporting and allowing code reuse:
  - session = tt.Session(port=1337)
  + session = tt.Session.start(tt.SessionConfig(port=1337))
  
• atoti.Session.__init__()’s authentication parameter has been replaced with atoti.SessionConfig.security:
    config = tt.OidcConfig(...)
  - tt.Session(authentication=config)
  + tt.Session.start(tt.SessionConfig(security=tt.SecurityConfig(sso=config)))
  
• atoti.UserContentStorageConfig has been moved to atoti_jdbc.UserContentStorageConfig:
  - config = tt.UserContentStorageConfig(url=url)
  - tt.Session(user_content_storage=config)
  + from atoti_jdbc import UserContentStorageConfig
  + config = UserContentStorageConfig(url)
  + tt.Session.start(tt.SessionConfig(user_content_storage=config))
  
  It makes it obvious that storing user content in an external database requires atoti-jdbc to be installed.

​

DirectQuery

• DirectQuery *ConnectionInfo and *TableOptions classes have been renamed ConnectionConfig and TableConfig.
  - from atoti_directquery_clickhouse import ClickhouseConnectionInfo
  + from atoti_directquery_clickhouse import ConnectionConfig
  
  - from atoti_directquery_clickhouse import ClickhouseTableOptions
  + from atoti_directquery_clickhouse import TableConfig
  
• The cache attribute controlling whether DirectQuery connections should use caching has been moved from the connection instance to the connection config:
  - from atoti_directquery_snowflake import SnowflakeConnectionInfo
  + from atoti_directquery_snowflake import ConnectionConfig
  - connection_config = SnowflakeConnectionInfo(url=...)
  + connection_config = ConnectionConfig(url=..., cache=True)
    external_database = session.connect_to_external_database(connection_config)
  - external_database.cache = True
  
• The DatabricksConnectionInfo.heavy_load_url attribute has been renamed feeding_url.

​

Other

• Upgraded jdk4py dependency to 21.0.4 which adds support for Linux Arm64.
• atoti_aws.AwsKeyPair, atoti_aws.AwsKmsConfig, and atoti_azure.AzureKeyPair have been renamed KeyPair, KmsConfig, and KeyPair.
• The atoti-sql package has been renamed atoti-jdbc.
• atoti.Session.explain_mdx_query() and atoti.Cube.explain_query() have been replaced with an explain parameter to atoti.Session.query_mdx() and atoti.Cube.query():
  - session.explain_mdx_query(mdx)
  + session.query_mdx(mdx, explain=True)
  
• atoti.Table.keys returns a tuple instead of a list. It communicates that keys cannot be changed once the table exists.
• create_cube()’s base_table parameter has been renamed fact_table.

​

User interface

• Upgraded Atoti UI and Admin UI to 5.2.0.

​

Deprecated

• atoti.Session.port. Use atoti.Session.url instead:
  - url = f"http://localhost:{session.port}"
  + url = session.url
  
  - port = session.port
  + from urllib.parse import urlparse
  + port = urlparse(session.url).port
  
• atoti.Session.start_transaction(). Use atoti.tables.Tables.data_transaction() instead:
  - with session.start_transaction(): ...
  + with session.tables.data_model_transaction(): ...
  
• atoti.Session.security.basic. Use basic_authentication:
  - session.security.basic.credentials
  + session.security.basic_authentication.credentials
  
• atoti.Table.columns and atoti.ExternalTable.columns. Use list(table) to list column names and for column_name in table: ... to iterate on column names:
  - column_names = table.columns
  + column_names = list(table)
  
• atoti.Hierarchy.levels. Iterate on the Hierarchy instead:
  - level_names = list(h["Geography"].levels)
  + level_names = list(h["Geography"])
  
  - h["Date parts"] = {**h["Date parts"].levels, "Date": table["Date"]}
  + h["Date parts"] = {**h["Date parts"], "Date": table["Date"]}
  

​

Removed

• Support for Java 17, 18, 19, and 20.
• The atoti-query package and its QuerySession class. Use atoti.Session.connect() instead:
  - pip install atoti-query
  + pip install atoti-client
  
  - from atoti_query import QuerySession
  + from atoti as tt
  - existing_session = QuerySession(url)
  + existing_session = tt.Session.connect(url)
    existing_session.query_mdx(...)
  
• atoti.Table.__len__(). It was ambiguous because it could be interpreted as counting either rows or columns. Instead, use atoti.Table.row_count to count rows and len(list(table)) to count columns:
  - row_count = len(table)
  + row_count = table.row_count
  

​

Previously deprecated

• Support for Python 3.9.
• Support for pandas 1.
• Support for JupyterLab 3.
• atoti.UserServiceClient.
• atoti.Cube.schema.
• Support for passing an int to atoti.Table.load_kafka()’s batch_duration parameter.
• Support for passing a tuple as a case key to switch().
• Variadic constructor of OriginScope.
• Support for calling atoti.Session.link().
• atoti.Session.visualize() and atoti.QuerySession.visualize().
• Support for array constants mixing int and float values.
• Support for passing a Set to:
  • atoti.Session()’s extra_jars or java_options parameters
  • atoti.Cube.query()’s levels parameter
  • atoti.Cube.create_parameter_simulation()’s levels parameter
  • atoti.Cube.create_parameter_hierarchy_from_members()’s members parameter
• Support for passing a Sequence to:
  • DirectQuery TableConfig classes’ clustering_columns attribute
  • atoti.MultiColumnArrayConversion.column_prefixes
  • atoti.MultiRowArrayConversion.array_columns
  • atoti.OidcConfig.roles_claims
  • atoti.OidcConfig.scopes
• atoti.Session.security.users.
• atoti.Session.security.basic.users and atoti.Session.security.basic.create_user().
• atoti.Session.security.roles and atoti.Session.security.create_role().
• In-place mutation of atoti.Security.security.ldap.role_mapping and atoti.Security.security.oidc.role_mapping’s values.
• In-place mutation of atoti.Security.security.individual_roles’ values.