In teiid, Can we refresh the materialized view at specific time of the day say at midnight everyday instead of specifying the interval
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
Retrieving data ...