Default value for dates

[HuifangYeo]

Hi,

with v0.7.0, dates are assigned default values of 1970-01-01:

In my use case, having a date doesn't make sense but I don't want to filter member away either. It should be as follows as I still want to see the NCD:

Can we still set the date to N/A if it's not applicable?

[Skyscimitar]

Hi Huifang,

As of version 0.7.0 you can set the default_value attribute on the columns of your table when creating it, or directly on the column. See https://docs.atoti.io/latest/lib/atoti/atoti.column.html#atoti.Column.default_value and https://docs.atoti.io/latest/lib/atoti/atoti.column.html#atoti.Column.default_value for more information. Note that the default_value parameter has also been added to all the read_* methods.

So in your case when creating your table you could add session.read_*(..., default_values={"CLAIM_DATE": "N/A"})