Update Materialize View without redeploy the VDB

[jchidiac]

Hi,

I'm using Teiid EmbeddedServer

i create a Model that contains all my materialize views

and i deployed this Model inn a VDB

my question, if there is a way to manage one of the views[ Change the SQL, remove, add a new VIEW]

without redeploy the VDB ?

Thx.

[rareddy]

Any metadata changes can not be done dynamically without re-deploy. You can change the view's transformation currently, but not definition of the view itself. See EventDistributor.java those all the events you can modify currently at runtime

[shawkins]

Metadata properties changes can be done at runtime, but require a metadata repository to be persistent.  However the materialization logic is not fully reactive to properties changes. Some properties, such as ttl, are only looked at them at load time.