Changelog

​

0.9.18

​

Added

• atoti.BasicAuthenticationConfig.credentials_cache ³.
• atoti_ai.AiConfig.auto_explain_retained_run_count and atoti_ai.AiConfig.auto_explain_run_lifetime ¹.
• atoti_ai.AiConfig.chat_enabled ².
• atoti_ai.AiConfig.mcp ².
• atoti_directquery_databricks.ConnectionConfig.array_aggregation_precision ¹¹.
• atoti_directquery_snowflake.ConnectionConfig.redacted_properties, atoti_directquery_databricks.ConnectionConfig.redacted_properties, atoti_directquery_jdbc.ConnectionConfig.redacted_properties, atoti_directquery_clickhouse.ConnectionConfig.redacted_properties, atoti_directquery_mssql.ConnectionConfig.redacted_properties, atoti_directquery_redshift.ConnectionConfig.redacted_properties, and atoti_directquery_synapse.ConnectionConfig.redacted_properties ¹⁰.

​

Changed

• Upgraded Atoti Server to 6.1.25.

​

Fixed

• Joining a distributed cluster rebuilt the cube, re-feeding all aggregated data and re-issuing every aggregation query against the database, which could be very expensive in a DirectQuery setup ⁶.
• A role restricted on a slicing hierarchy holding a single level saw an empty cube instead of the restricted members ⁴. This applies to both atoti.Cube.restrictions and atoti.tables.Tables.restrictions.
• Generating a token on the MCP credentials page failed ⁵. The page was also only reachable at /mcp-credentials/index.html, not at /mcp-credentials.
• A data cube could be missing from the cluster it had joined, leaving the query cube without any of its measures ⁷. A query cube under load could drop its answer to a join request instead of sending it, and nothing sent that answer again. After ten unanswered attempts the data cube gave up and formed a cluster of its own, while the query cube had already counted it in as a member. Several cubes joining at once, typically when the cluster restarts, made it more likely.
• atoti.Table.load() raised a NullPointerException instead of a descriptive error when its transaction failed at commit time ⁹.
• atoti.agg.sum_product() rejected array columns of type float[], long[], and int[] with TypeError: Only array columns of type double[] are supported ¹¹.
• atoti.Session.logs_path named a file that was never written when the observability plugin was installed ¹³. The session logged to the standard output only, whether the file’s location came from atoti.LoggingConfig.destination or from the default one under $ATOTI_HOME.
• atoti.Table.load() hung forever when a data model change, such as assigning a measure with atoti.Cube.measures from another thread, was requested while a load was running ¹². The data model change waited for the load to end while the load waited for the change to open, and every later load or request reading the data model then hung too, until the session was restarted.
• Changing several things at once, such as updating the role_mapping of oidc with more than one entry, no longer raises TypeError: Invalid AST Node when graphql-core 3.3 is installed ⁸. The Atoti Python SDK combines these changes into a single request, and graphql-core 3.3 no longer accepted the way that request was built.

​

Security

• The repr() of the configs and authentication classes holding a secret, such as atoti.OidcConfig or atoti_ai_openai.ConnectionConfig, shows <redacted> in place of the secret ¹⁰. The attribute itself still holds the secret unchanged.

​

Internal issue tracker references

• [1] PIVOT-14121
• [2] PIVOT-14244
• [3] PIVOT-14494
• [4] PIVOT-14665
• [5] PIVOT-14805
• [6] PIVOT-14807
• [7] PIVOT-14932
• [8] PIVOT-15203
• [9] PYTHON-980
• [10] PYTHON-984
• [11] PYTHON-985
• [12] PYTHON-991
• [13] PYTHON-993

​

0.9.17

​

Added

• atoti_ai.AiConfig.dynamic_tool_discovery ¹⁵. Set it to False to send the whole tool set to the LLM on every request instead of only the tools matching it.
• atoti.Cube.shared_context’s queriesTimeLimit.max entry to cap the query time limit that users can set ¹⁶.

​

Changed

• Upgraded Atoti Server to 6.1.24.
• atoti.Session.start() raises a RuntimeError when atoti.SessionConfig.ai is passed but the started server exposes no AI service ¹⁴. This is most often a license missing the ai-essentials component, which the error message calls out. Such a session previously started successfully with atoti.Session.chat and atoti.Cube.auto_explain silently set to None. To start a session without AI, do not pass ai:
  - session_config = tt.SessionConfig(ai=ai_config)
  + session_config = tt.SessionConfig()
  
  Sessions that do not pass ai are unaffected, including those where the ai plugin is installed.
• 0.9.x versions are no longer published on PyPI ¹⁷. Only the latest version line of the Atoti Python SDK is published there, and that line is now 6.2.x. 0.9.x versions are only available from ActiveViam’s repository.

​

Security

​

Internal issue tracker references

• [14] PIVOT-14402
• [15] PIVOT-14439
• [16] PIVOT-14464
• [17] PIVOT-14565

​

0.9.16.1

​

Fixed

• Improved query interruption checks, boosting performance for large cross-joins and the descendants MDX function, including cases where the JVM heap was not freed after a query timeout or cancellation.
• Fixed an issue with query plan validation affecting specific edge cases.

​

0.9.16

​

Added

• atoti.Table.load()s error_handling parameter ^{18 19 20}.
• atoti.Cube.feeding and atoti.Session.create_cube()’s feeding parameter ³¹.
• Atoti Intelligence can be enabled without configuring an LLM provider ²². Pass AiConfig with no arguments (leaving connection and chat as None). Auto-Explain will return a default, non-AI summary, and the chat feature will be disabled.
  from atoti_ai import AiConfig
  
  with tt.experimental({"ai"}):
      session = tt.Session(ai=AiConfig())
  

​

Changed

• Upgraded Atoti Server to 6.1.23.
• Upgraded Atoti UI and Atoti Admin UI to 5.2.25.
• The Atoti UI app is served in development mode if __debug__ is True. See deployment setup.
• When atoti.SessionConfig.ai is not None, the session’s MCP server exposes an OAuth 2.1 flow, so MCP clients such as Claude Desktop or Claude Code can authenticate without a manually provisioned Bearer token. If the session delegates authentication to an OIDC provider (OidcConfig), the MCP server reuses it (external mode: clients authenticate against that provider, which already guards the MCP endpoint). Otherwise the MCP server acts as its own OAuth 2.1 authorization server (self-issued mode: a browser login and consent against the session’s own authentication). HTTP Basic authentication on the MCP endpoint keeps working, so programmatic and headless clients are unaffected. Override with the atoti.server.endpoint.mcp.oauth2.* server properties ²⁷.
• Changing atoti.Hierarchy.virtual to True does not restart the cube ²⁸.
• atoti.AiConfig has moved to atoti_ai.AiConfig ²². The ChatConfig and ConnectionConfig base classes have moved from atoti.config.ai to atoti_ai as well.
  - session_config = tt.SessionConfig(ai=tt.AiConfig(...))
  + from atoti_ai import AiConfig
  + session_config = tt.SessionConfig(ai=AiConfig(...))
  

​

Deprecated

• Publishing of Conda packages. Install the Python packages with uv (or pip) instead. It is still possible to use a Conda environment by installing the packages with pip:
    conda create --name my-env
    conda activate my-env
  - conda install atoti
  + pip install atoti
  
• atoti.Hierarchy.dimension, use atoti.Hierarchy.dimension_name instead ²⁵.
• atoti.Level.dimension, use atoti.Level.dimension_name instead ²⁵.
• atoti.Level.hierarchy, use atoti.Level.hierarchy_name instead ²⁵.

​

Fixed

• create_parameter_hierarchy_from_column() supports using the target field of a join ²¹.
• query() and query() raising an error when a LocalDate column member is outside the pandas datetime range ²³.
• LoggingCsvHealthEventHandler no longer logs spurious errors when non-CSV health events are dispatched to it ²⁴.
• JdbcPingDiscoveryProtocol backed by an embedded H2 file database intermittently failing to form the cluster, because the query and data nodes, which run in separate JVMs, could not open the discovery database concurrently. AUTO_SERVER=TRUE is enabled automatically for embedded H2 databases so that the query and data nodes can access the discovery table concurrently ²⁶.

​

Security

​

Internal issue tracker references

• [18] PIVOT-13841
• [19] PIVOT-13961
• [20] PIVOT-14160
• [21] PYTHON-851
• [22] PYTHON-859
• [23] PYTHON-909
• [24] PYTHON-913
• [25] PYTHON-921
• [26] PYTHON-926

​

0.9.15

​

Added

​

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

• [27] PIVOT-13970
• [28] PIVOT-14011
• [29] PYTHON-753
• [30] PYTHON-869
• [31] PYTHON-896

​

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

• [32] PYTHON-798
• [33] 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

• [34] PIVOT-12311
• [35] PYTHON-703
• [36] PYTHON-768
• [37] PYTHON-774
• [38] PYTHON-775
• [39] 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

• [40] PIVOT-12663
• [41] PYTHON-447
• [42] PYTHON-742
• [43] 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

• [44] PYTHON-716
• [45] PYTHON-717
• [46] PYTHON-728
• [47] PYTHON-733
• [48] PYTHON-737
• [49] PYTHON-739
• [50] 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

• [51] PYTHON-590
• [52] PYTHON-712
• [53] 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

• [54] PIVOT-12464
• [55] PYTHON-697
• [56] PYTHON-698
• [57] 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

• [58] PIVOT-12032
• [59] PIVOT-12336
• [60] PYTHON-691
• [61] 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

• [62] PIVOT-12095
• [63] PYTHON-592
• [64] PYTHON-621
• [65] PYTHON-629
• [66] PYTHON-632
• [67] PYTHON-634
• [68] PYTHON-677
• [69] 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

• [70] PYTHON-545
• [71] 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

• [72] PIVOT-11612
• [73] PIVOT-11652
• [74] PYTHON-552
• [75] PYTHON-593
• [76] PYTHON-610
• [77] PYTHON-615
• [78] 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

• [79] PYTHON-538
• [80] PYTHON-542
• [81] PYTHON-554
• [82] PYTHON-581
• [83] PYTHON-584
• [84] PYTHON-586
• [85] 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

• [86] PIVOT-11110
• [87] PYTHON-528
• [88] PYTHON-529
• [89] PYTHON-534
• [90] PYTHON-536
• [91] PYTHON-539
• [92] 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

• [93] PIVOT-10472
• [94] PIVOT-10571
• [95] PIVOT-10678
• [96] PIVOT-10995
• [97] PYTHON-190
• [98] 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.