Following up with a recommendation from Databricks:

For tables that need incremental processing - 

SQL Server →  Lakeflow Connect → Bronze SCD2 Streaming Table (CDF enabled → consume CDF, not base table using AUTO CDC → Silver SCD2 Streaming Table → Downstream MVs or Streaming Tables