Set default MatView Extension Properties for JDG materialization ---------------------------------------------------------------- Key: TEIIDDES-2970 URL: https://issues.jboss.org/browse/TEIIDDES-2970 Project: Teiid Designer Issue Type: Enhancement Components: Modeling Affects Versions: 10.0.2 Reporter: Van Halbert Assignee: Barry LaFond Labels: release_notes, verified_jbdsis-9.0.3 Fix For: 10.0.2 When a view is being materialized for JDG, set the following extension properties: teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT - {code} execute {jdgsourcemodelname}.native(''swap cache names''); {code} teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT - {code} execute {jdgsourcemodelname}.native(''truncate cache''); {code} teiid_rel:MATERIALIZED_STAGE_TABLE - {code} {jdgsourcemodelname}.{stagingTable} {code} where {jdgsourcemodelname} as the new JDG Source Model that is created. note: do not add tic's around these, like 'execute......),' but do add the double tic's inside the native call