Add support for creating partitioned views ------------------------------------------ Key: TEIIDDES-1198 URL: https://issues.jboss.org/browse/TEIIDDES-1198 Project: Teiid Designer Issue Type: Feature Request Components: Modeling Reporter: Steven Hawkins As an alternative to multi-source models, Teiid supports updatable views defined as union alls that serve the same purpose. It would be good if there was something that could guide the user in creating a partitioned view layer. For example after source A and source B have been imported (of course there could be more than two sources) there could be a modeling option in the new model wizard that creates a view layer not from a single source, but multiple sources. The views would be defined as select 'sourceA' as source_name, ... from sourceA.tbl union all select 'sourceB' as source_name, ... from sourceB.tbl. Obviously without a reconciliation step we would expect tables and column names to match exactly. Procedures are a special case and don't quite fit cleanly in this approach (or in mulit-source logic either).