Data Refresh for a set of tables
To set up a set of tables for a full reload of data from source to target.
-
Open the Configure -> Details -> Table Router screen.
Add the Data Refresh column to the current view (using the gear-shaped button on the right). -
Edit the router entry for each table in question.
Set the [Data Refresh Type] = FULL and save. -
On the Configure -> Details -> Jobs screen, edit the "Data Refresh" job.
Set desired schedule, like midnight: schedule = 0 0 0 *