I want to ingest data from my GitHub repo with airbyte. All my connections are successful between the source (GitHub) and destination (postgres). However, I can't find the data in any of the schema loaded into postgres. Any help with this?

Are you connected to the right Database within the host? I do this a lot 🙂. i.e. I’ll be connected to

postgres

but my database is named

foo

I think I am. There are some tables being synced to my database. So I think the connection is fine

How are you checking to ensure data is loaded? Connecting via command line to the Postgres server?

I have this so far

@[DEPRECATED] Marcos Marx turned this thread into Zendesk ticket 2908 to ensure timely resolution!

Sorry - I don’t work for Airbyte, just a fan of the software and trying to help - but I would assume if the tmp schemas exist, then the replicated data would too.

Thank you for your help so far

Thanks for your help, Dusty! Stephen, could you please provide the full logs you are getting when you run a sync job?

Thanks for your help, Dusty! Stephen, could you please provide the full logs you are getting when you run a sync job?

These are the logs from the last sync that succeeded

Huh, that's weird! You're using the incremental append deduped history sync mode, right? Could you try a full refresh sync and see if you get the data?

Yes

I think this may have something to do with how your Postgres instance is setup. Could you double check that it meets all prerequisites? https://docs.airbyte.com/integrations/destinations/postgres/#prerequisites I'll keep looking into this!