We currently store user information in Postgres, and our team queries this information to display analytics for UTM links (current in Klipfolio)
I’m looking to sync information between our Postgres DB and Airtable, where we can create a UTM link in Airtable and later pull in information (periodically) from Postgres to display user data originating from that link in a table.
What’s the best way to do this where we can update the information regularly with minimal manual effort?
Hey Tyler, you may have fixed this by now, but in case you haven’t:
Your problem would be simpler if you were just trying to pull data from Airtable to Postgres. For that, you could use an ETL solution like Fivetran or Airbyte (open source). If you’re a no-code guy, you could maybe even do it with Zapier.
However, it sounds like your problem is bidirectional: moving data to and from Airtable & Postgres. For this, you either need to cobble two solutions – ETL & reverse ETL – or you can use something like Bracket (https://www.usebracket.com/) which does bidirectional syncing between Airtable and Postgres.
Hope that helps!