In teiid, Can we refresh the materialized view at specific time of the day say at midnight everyday

[dineshnasa]

In teiid, Can we refresh the materialized view at specific time of the day say at midnight everyday instead of specifying the interval

[rareddy]

Yes, you can use the external scheduler to kick of the refresh script whenever you want. For example in Linux you can used cron job. In Windows, you can use windows scheduler.

Teiid also has built materialization management, see if that serves your needs External Materialization · Teiid Documentation