We've had success using DBT incremental models for this. Deletes aren't supported though, but for our use case that's fine and do a nighly refresh on the whole.

Otherwise the best alternative would be something like https://materialize.com