We (estuary.dev) recently launched an open-source and no-code new feature for real-time ETL & CDC between MongoDB and Snowflake (or other DW like BQ, Redshift, Databricks, etc…).
In addition to real-time capture and delivery of events from Mongo, you can now contiously and automatically flatten nested documents as you replicate to the RDBMS. After pointing a no-code or open-source connector to Mongo, Estuary will automatically detect any nested schema changes, and unpack them en route to the DW (or ignore if you choose).
Would love the communities feedback for when simplifying no-sql → SQL replication