MeltanoLabs/tap-snowflake

bug: Dates fail validation because theyre in timestamps format `'2021-03-19T00:00:00+00:00' is not a 'date'`

Opened this issue · 1 comments

The snowflake table definition shows that the columns are date types but when the tap extracts them it returns a string in the format of a timestamp '2021-03-19T00:00:00+00:00' so target validation fails. The json schema for the record looks to be correct {'format': 'date', 'type': ['string', 'null']}.

Screen Shot 2023-07-18 at 1 22 25 PM