This works well until it doesn't and you're incrementally adding time to the loads. Some DBs handle it better than others. What most are looking for is performa

This works well until it doesn't and you're incrementally adding time to the loads. Some DBs handle it better than others. What most are looking for is performant, less constrained materialized views. If you're running ELT then MVs are a big deal. Additionally some DBs (SQL Server) don't have an option for pure "no logging" so, even with simple, there's overhead to the large writes. I like schema swaps too for the tables rather than renames but the pattern is the same.