0.7.1 (October 12, 2022)

Added

• atoti-directquery-redshift plugin.

• atoti.Session.read_arrow() and atoti.Table.load_arrow() to load Arrow tables.

• lookup() to run a get-by-key query on a given Table (discussion #603).

• Ability to index an array measure with a Tuple[int, ...] or a measure of type INT_ARRAY or LONG_ARRAY to create another array measure containing the values at the passed indices.

• Support for all comparison operators in drop().

• Ability to make a Hierarchy virtual.

• atoti.shift()’s partitioning parameter.

• Calling where() with a Mapping of conditions to values.

• atoti.Column.isin().

• atoti.Column.isnull(), atoti.Level.isnull() and atoti.Measure.isnull() to replace comparison against None raising static type checker warnings.

• LdapConfig’s manager_dn and manager_password attributes to log into directory services requiring authentication (issue #664).

Changed

• Support more DataType in ColumnCondition when used in where().

User interface

• Upgraded Atoti UI to 5.0.17.

Deprecated

• Comparing a Column, Level, or Measure against None. Use the corresponding isnull() method instead.

  - m["Example"] == None
  + m["Example"].isnull()
  - m["Example"] != None
  + ~m["Example"].isnull()
  

• Passing a Mapping to at()’s coordinates parameter. Pass a Condition instead.

    at(
      m["Price"],
  -   {l["Company"]: l["Competitor"]},
  +   l["Company"] == l["Competitor"],
    )
  

• Passing a Mapping to drop()’s coordinates parameter. Pass a Condition instead:

    table.drop(
  -   {"id": 1, "city": "London"}, {"city": "Paris"}
  +   ((table["id"] == 1) & (table["city"] == "London")) | (table["city"] == "Paris")
    )
  

Fixed

• Restrictions when using partial joins.

• Widgets created with visualize() not blocking the execution of the following notebook cells and thus leading to unexpected query results (issue #670).

• Data loaded into tables created by create_parameter_simulation() not being propagated to all source simulation scenarios.

• atoti.agg.single_value() on a Column from a joined Table (issue #702).

• link() and visualize()’s support of sessions created with an HttpsConfig.

• Inability to use join() after a scenario had been created.

• Error message when calling create_date_hierarchy() with a non temporal Column (discussion #683).

• Error when creating a Measure twice from the same atoti.MeasureDescription.

• Wrong result when combining atoti.where() and CumulativeScope.