UNION ALL Error

Troubleshooting
, ,
#1

logs-539.txt (879.2 KB)
Error union all in contacts_scd.sql Intercom

Airbyte 0.36.4-alpha

#2

Hey @ayyoub can you try syncing it again by removing the contacts stream?

#4

how to remove the contacts stream @harshith

#5

syncing intercom is too long to wait even in contacts with start date at 29 April 2022 need more than 17 hours to sync :pensive:

#6

Got it I could see contacts itself has a lot of data. Do you mind sharing one contact record here after hashing/deleting the contact details. I want to understand the values for

 "created_at": {
      "type": ["null", "integer"]
    },
    "updated_at": {
      "type": ["null", "integer"]
    },
    "signed_up_at": {
      "type": ["null", "integer"]
    },
    "last_seen_at": {
      "type": ["null", "integer"]
    },
    "last_replied_at": {
      "type": ["null", "integer"]
    },
#7

already delete old temp tabel and solved thanks @harshith