Clojurians Log v2

Hey @stephen676 interesting, we haven't experimented with Fivetran before. In theory it would be ideal to be able to use the standard Postgres adapter, however we haven't attempted to implement logical replication / xmin CDC compatibility so it's not going to work out of the box. What kind of timescale are you working towards? We can potentially spend some time looking at the various other Snowflake integration options too. FlightSQL may be the better bet

yep - I'd probably be looking at other methods of replication from XT -> Snowflake rather than a tool that's specific to Postgres's replication - we might be close to Postgres in a lot of ways but low-level replication behaviour isn't one of them 🙂

Yeah I was afraid of that. Especially in a schemaless world. Gonna look into FlightSQL! Thanks for the info!!

As for timescale — this is likely a large-ish rewrite. 12-18 months until feature parity. But of course I’m trying my best to push back on kitchen sink syndrome. ☺️

Given our budget and so forth we might have to settle for MySQL with bitemporal tables. 🤷‍♂️

the other avenue I might look into would be an XT Kafka connector that Snowflake could then read from - if it's a big enough project that requires it it's something we could raise up our prios

I will keep that in mind!