'2018-07-01T00:00:00+00:00' is not a 'date'

Question

'2018-07-01T00:00:00+00:00' is not a 'date'

Closed this issue a year ago · 3 comments

I have a field with the Postgres type of date Date like 2018-07-01

The issue is that the date is being parsed like this by the tap jsonschema.exceptions.ValidationError: '2018-07-01T00:00:00+00:00' is not a 'date'

When it shouldn't have the timestamp information (Or at least I"d think it shouldn't)

Answer 1 · 2023-07-11T18:38:44.000Z

Probably related to meltano/sdk#1831?

Answer 2 · 2023-07-11T18:45:31.000Z

The SDK adds timestamp to datetime.date on these lines: https://github.com/meltano/sdk/blob/b02d698c15c1fff8667e18e5301c65a0fd0247b5/singer_sdk/helpers/_typing.py#L477-L478

Answer 3 · 2023-07-11T18:47:20.000Z

@edgarrmondragon seems like it!

The SDK adds timestamp to datetime.date on these lines: https://github.com/meltano/sdk/blob/b02d698c15c1fff8667e18e5301c65a0fd0247b5/singer_sdk/helpers/_typing.py#L477-L478

Hmm I wonder why that would be there in the SDK. We could definitely just override that function for this tap and give it a go.