1) Currently both SYS and SYSADMIN are both categorized as "SOURCE" schemas, should I add another at "VIRTUAL" schema for this purpose?

2) How can I look up metadata inside the virtual procedure?

I will rewrite using "merge"

Add management features to materialization ------------------------------------------ Key: TEIID-2584 URL: https://issues.jboss.org/browse/TEIID-2584 Project: Teiid Issue Type: Feature Request Reporter: Ramesh Reddy Assignee: Ramesh Reddy Fix For: 8.5 Currently Teiid supports internal and external materialization features. The internal is managed completely by the Teiid query engine along with the infinispan cache. External materialization is completely unmanaged and left out to the user to manage it externally. This goals for this feature are unify the materialization logic for internal and external, such that both are managed similarly irrespective of the type of materialization chosen.