Hi, I am working on a custom connector for airbyte. I’m running into this error during the sync normalization process:

is of type timestamp without time zone but expression is of type text

. In my schema i have configured this column as follows:

"block_day": {
            "type": "string",
            "format": "date-time",
            "airbyte_type": "timestamp_without_timezone"
        },

Any ideas on how to resolve this would be appreciated. I’ve tried a couple variations of the configuration and have searched around on the airbyte github issues but haven’t found a solution.

@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2818 to ensure timely resolution!

Can you share the complete sync log here?

sure one moment

From logs:

2022-10-13 19:49:45 [44msource[0m > Setting state of ethereum_contract_calls stream to {'block_day': '2022-10-13'}

i have checked the records are returning a date formated as

YYYY-MM-DDTHH:MM:SS

my suggestion @David hatch is to first cast the block_day to string, check the output what is happening and after you can move to datetime…