Fivetran works perfectly fine for syncing Postgres databases into Snowflake. My company syncs dozens of them without problems. I can only assume their Postgres database has a non standard set up.
Yeah, if you have 1 million dollars to spend every time you run a data migration or anything else that touches many rows.
I've seen some new libraries crop up for writing your own replication slot clients. I wouldn't use fivetran for PG.
Either you have a lot of data and fivetran will be too expensive or you don't, and you're better off just using a postgres OLAP plugin/extension.
Maybe it was because it was in beta, but I had a nightmare of a time with fivetrans API trying to coordinate connectors and destinations and git access.
