Routing with logical views significantly extends the range of SQL statements that may be expressed through analytical views, and enables us to support table joins, unions, window functions, and more complex expressions in the analytical views.
One limitation to this approach is that it currently limits the opportunities for incremental refresh of analytical views.
Contrast this with Routing Queries To Analytical Views Defined on Tables.