I'm processing a datetime field from tap-mssql with a value extremely close to midnight (2021-01-11 235959.998). The schema validation in the tap is complaining, saying the hour is outside the range of

0..23

. To solve this, I'm trying to override the schema and metadata properties to treat the field as a regular string instead of a

datetime

. When I update the configuration and dump the catalog, I get what I expect--the field is a string in the schema. However, when I run

elt

I get the same datetime validation. What am I missing?

I think with datetime you'll have to override the format. So I think as another property of the

CreateDateUtc

object add

format: ""

, I think that should do the trick, if not take a look at the catalog and see what the catalog is saying for the UTC time