Sqlserver ingestion using JTDS driver will create Infoworks ZIW audit columns with string datatype instead of timestamp datatype.
This is an issue with the JTDS driver. JTDS Driver does not support date and datetime2 datatypes and these datatypes will be brought as a string in the hive.
Set this "" configuration to true at the source level, truncate the table, recrawl schema and re-ingest the table. This should resolve the issue.
Applicable IWX versions: