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

[rosannaman]

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

[alafanechere]

Hi @rosannaman

@rosannaman

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

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?

[rosannaman]

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

[marcosmarxm]

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.