[loginx]

Haven't used it personally, but I would suggest looking into Apache Hudi

[zoogeny]

Good to know about but looks more like an open source snowflake (e.g. data lake). Fivetran and Census are the in/out process layers that bookend the data lake. Although, Hudi does look like it has some of that functionality baked in.