Hi, I've been having some problems with the update of the Redshift destination 0.3.32. As shown by many issues in github such as https://github.com/airbytehq/airbyte/issues/12843 , https://github.com/airbytehq/airbyte/issues/12460 and https://github.com/airbytehq/airbyte/issues/12265 . I decided to revert to 0.3.27, which was working previously. However, the same error is still showing:

function json_extract_path_text(super, "unknown", boolean) does not exist

Then

JSON schema validation failed.

Debug info: Airbyte Version: 0.35.51-alpha Source: Google Sheets (0.2.9) Destination: Redshift (0.3.27) I think the normalization (dbt file) is not being generated again when I downgrade or upgrade. I am not sure about what to do to completely rollback the configuration.

Hello @Andrés O. Arredondo we’re moving our support to Discourse. More complex issues like yours are better there to further discoveraiblity. Do you mind creating a ticket there? https://discuss.airbyte.io/

no problem, thanks

This problem can happen if normalization detected your main json field as VARCHAR but it in reality it’s type is SUPER

If you delete the raw table only (not the final normalized ones), it might fix your issue after a downgrade (they’ll be recreated with the correct type)