Issue with failing Redshift dbt normalisation

Troubleshooting
, ,
#1
  • Is this your first time deploying Airbyte?: No
  • OS Version / Instance: EC2 t2.large
  • Memory / Disk:
  • Deployment: Docker
  • Airbyte Version: 0.35.47 - alpha
  • Source name/version: Postgres
  • Destination name/version: Redshift
  • Step: Normalisation, fetching JSON works fine
  • 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.

logs-224.txt (137.0 KB)

#2

Hey @jablonskijakub,
Do you think its possible that your source schema changed?
Do you mind trying to:

  • reset the data on the destination
  • run a schema refresh on the source
#4

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

#5

Do you mean you run a custom version of the normalization?
Did you change the raw table data types to SUPER?

#6

no, I ran the normalisation in dbbeaver, not a custom one via Airbyte. No, haven’t change anything and it was a first sync.

#7

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 :pray: