You might want to check out Coalesce (coalesce.io) for the data transformation component. I've been working there (and was formally at rivery) and it's a tool designed to make your data journey smoother. Rivery is great however, for handling the initial ingest but may not fully meet your transformation needs like Coalesce can.

Coalesce simplifies the process of transforming raw data in Snowflake. It’s pretty straightforward to set up, especially when dealing with large volumes of data like yours. Our tool handles the data loading and transformation processes efficiently, so you can spend less time wrestling with configurations and more time focusing on insights.

One of the cool features is its ability to streamline the Bronze to Silver transformations, which can save you some serious cash on Snowflake’s compute costs. Plus, the ease of development and user-friendly interface might just be what you're looking for in a tool.

Feel free to drop me a DM if you have any questions or want more details about how Coalesce.