drewipson
New Contributor III

Make sure you are using the aggregates and SQL restrictions outlined in this article. https://docs.databricks.com/en/optimizations/incremental-refresh.html

If a SQL function is non-deterministic (current_timestamp() is a common one) you will have a COMPLETE_RECOMPUTE every time.