Description: I have two connections to a Postgres DB to sync the data to Redshift. Both fail at the normalisation step, however it worked before. My log below.
hey @alafanechere. thanks for your answer. I did what you suggested and still received the same error. This line appears in every failed sync:
function json_extract_path_text(super, "unknown", boolean) does not exist
isn’t it a Redshift related problem then? I run a normalisation using slightly different syntax - the column with json is coded as super thus this trick worked: "_airbyte_data".id as id
Do you mind trying to upgrade Airbyte to its latest version and re-create your connection? If it’s still not working please open an issue on our GitHub repo and share the link here