Hey AJ, leaving this here in case it’s still a problem for you or anyone else that stumbles along this post.
You can use Bracket to do a two-way data sync between Airtable and Postgres (or any database / data warehouse). And it’s built to move data securely via SSH as well.
All you have to do is submit your Airtable API key and link it up to your Postgres with those credentials (via SSH if you choose), and you’re done. We also support SQL queries from Postgres into Airtable to make your syncs fully customizable.
Disclaimer: I’m the founder and built for this use case because I needed a solution myself.
you can go here to get started right away: https://app.usebracket.com/