DLT can incrementally update live tables when the underlying data sources and transformations allow it, unlike Redshift materialized views, which often require full refreshes when using complex joins.

The code you mentioned needs to be fully re-computed every time.