I am very new to TEIID developement
I have the requirement to refresh the materialized view everyday at 12 AM.
I am creating foreign table and materialized view on those table in the vdb.
Using the following options
This refreshes the view everyday after strat but have no idea how to first refresh at eod.
Can anyone please help me to list down the steps to achieve this. Else I need to restart the server at midnight.
Neither the loadMatView call is working
and not able to delete the view and insert into the view
I am using teiid version 8.13.1
Thanks in advance
Have you followed steps here External Materialization · Teiid Documentation? However these are for full server version, however there are extensions for this to work in embedded too. Look for MaterializationManager class, and follow and see what is not working for you.