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!