0.7.1 (October 12, 2022)#
Added#
atoti-directquery-redshift
plugin.atoti.Session.read_arrow()
andatoti.Table.load_arrow()
to load Arrow tables.lookup()
to run a get-by-key query on a givenTable
(discussion #603).Ability to index an
array
measure with aTuple[int, ...]
or a measure of typeINT_ARRAY
orLONG_ARRAY
to create another array measure containing the values at the passed indices.Support for all comparison operators in
drop()
.atoti.shift()
’s partitioning parameter.Calling
where()
with aMapping
of conditions to values.atoti.Column.isnull()
,atoti.Level.isnull()
andatoti.Measure.isnull()
to replace comparison againstNone
raising static type checker warnings.LdapConfig
’smanager_dn
andmanager_password
attributes to log into directory services requiring authentication (issue #664).
Changed#
Support more DataType in
ColumnCondition
when used inwhere()
.
User interface#
Upgraded Atoti UI to 5.0.17.
Deprecated#
Comparing a
Column
,Level
, orMeasure
againstNone
. Use the correspondingisnull()
method instead.- m["Example"] == None + m["Example"].isnull() - m["Example"] != None + ~m["Example"].isnull()
Passing a
Mapping
toat()
’s coordinates parameter. Pass aCondition
instead.at( m["Price"], - {l["Company"]: l["Competitor"]}, + l["Company"] == l["Competitor"], )
Passing a
Mapping
todrop()
’s coordinates parameter. Pass aCondition
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 aColumn
from a joinedTable
(issue #702).link()
andvisualize()
’s support of sessions created with anHttpsConfig
.Inability to use
join()
after a scenario had been created.Error message when calling
create_date_hierarchy()
with a non temporalColumn
(discussion #683).Error when creating a
Measure
twice from the sameatoti.MeasureDescription
.Wrong result when combining
atoti.where()
andCumulativeScope
.