In the last 12 months, I have dealt with three different projects that involved moving companies' analytical workloads, from MongoDB to analytical platforms like Snowflake, BigQuery. Additionally, there was one project where I had hoped to integrate a solution like Rockset or Tinybird since they can quickly be implemented without creating an entire data warehouse(in the end, they still went with Snowflake).
I’m fond of staying with Postgres until it starts to hurt. You can bring in data using foreign data wrappers and use material views for most things.
Makes a lot of sense. Thanks for sharing your experience.
Thank you for this wonderful content,
I'm trying to get this right: can I have my NoSQL and SQL ... data and simply use an alternative to what is offered by MongoDB like Rockset?