[ https://issues.jboss.org/browse/TEIIDDES-2466?page=com.atlassian.jira.plu... ] Barry LaFond edited comment on TEIIDDES-2466 at 3/7/16 10:38 AM: ----------------------------------------------------------------- This feature could be implemented by utilizing a temporary dynamic VDB artifact rather than the current EMF VDB archive. User could select a table or view. Designer would need to construct a temporary dynamic VDB containing a simple <model> entry for each dependent model + the selected model. These models would contain DDL representing only the tables necessary to execute the query on the source(s). *Benefits* : would include removing (or drastically reducing the complexity) the whole framework around maintaining a project VDB as well a preview VDB for each model *Drawbacks* * there may be a performance hit to always deploy a VDB (and undeploy) for Preview Data * Views using UDF methods would need to include the function in the DDL. UDF jar would have to be deployed separately prior to deploying the dyn. vdb. was (Author: blafond): This feature could be implemented by utilizing a temporary dynamic VDB artifact rather than the current EMF VDB archive. User could select a table or view. Designer would need to construct a temporary dynamic VDB containing a simple <model> entry for each dependent model + the selected model. These models would contain DDL representing only the tables necessary to execute the query on the source(s). *Benefits* : would include removing (or drastically reducing the complexity) the whole framework around maintaining a project VDB as well a preview VDB for each model *Drawbacks* : there may be a performance hit to always deploy a VDB (and undeploy) for Preview Data -- This message was sent by Atlassian JIRA (v6.4.11#64026)