Source Postgres, Destination Redshift : No table / data found after a successful sync

I can only see airbyte temp tables in the schema although it says the sync is successful and there are 104,409 committed records.

logs-16.txt (647.6 KB)

  • Is this your first time deploying Airbyte?:Yes
  • OS Version / Instance: Amazon Linux
  • Memory / Disk: you can use something like 8Gb / 30 Tb
  • Deployment: Docker
  • Airbyte Version: 0.36.3-alpha
  • Source name/version: Postgres (0.4.11)
  • Destination name/version: Redshift (0.3.32)
  • Step: Never got any data synced onto Redshift

Hi @rosannaman

According to your screenshot you do have _airbyte_raw_* tables, these are the final tables, not temporary tables. Do you have records in these tables?

I saw the data now in the _airbyte_raw_* tables. Thanks!

Hi there from the Community Assistance team.
We’re letting you know about an issue we discovered with the back-end process we use to handle topics and responses on the forum. If you experienced a situation where you posted the last message in a topic that did not receive any further replies, please open a new topic to continue the discussion. In addition, if you’re having a problem and find a closed topic on the subject, go ahead and open a new topic on it and we’ll follow up with you. We apologize for the inconvenience, and appreciate your willingness to work with us to provide a supportive community.