Re:Lesser Known Postgres Features
by janee on Tuesday August 29, 2023 @08:59PM
(#37316302)
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