Data type

SUPERWISE® supports out of the box the following data types:

• String - Any categorical or non-ordinal field. E.g. “Color: Red, Blue, Green, ...”
• Boolean - Any binary field. E.g. “Is fraud: True, False”
• Numeric - Any ordinal numerical type of field. E.g. “Age: 50, 65.5, 12.7, ...”
• Date - Date field according to the following format:
  • YYYY-[M]M-[D]D
  • YYYY/[M]M/[D]D
• Datetime - Datetime field according to the following format ("date_part" refers to date format above):
  • date_part[time_part [time_zone]] |
  • date_part[time_part[time_zone_offset]] |
  • date_part[time_part[utc_time_zone]]
  • time_part: { |T|t}[H]H:[M]M:[S]S[.F]
• JSON - Any JSON object. Please note that the platform doesn't support the extended formalization of JSON types (e.g., string or int) but does support any JSON object.

📘

Date and Datetime format encoding

YYYY: Four-digit year.

YY:M: One or two digit month.

]M:D: One or two digit day.

{ |T|t}: A space or a T or t separator. The T and t separators are flags for time.

|T|H: One or two digit hour (valid values from 00 to 23).

]H:M: One or two digit minutes (valid values from 00 to 59).

]M:S: One or two digit seconds (valid values from 00 to 60).

]S: : Up to six fractional digits (microsecond precision).

[time_zone]: String representing the time zone. When a time zone is not explicitly specified, the default time zone, UTC, is used (supported time zones taken from tz database)