Implement data update in the background process for the new DETER tables in the AMS database.
Two tables are affected by this process:
deter.deter_all - data published in TerraBrasilis for authenticated users and extra columns of the aggregation;
deter.deter_public - data published on TerraBrasilis for anonymous users and extra columns of the aggregation;
Three steps are required:
Truncate table data;
Enter data from SQL View;
Update aggregate attributes using another SQL view;
The background process must be scheduled to run every day before the other existing process.
New DETER tables must be created as a precondition to start this task.
Implement data update in the background process for the new DETER tables in the AMS database. Two tables are affected by this process:
Three steps are required:
The background process must be scheduled to run every day before the other existing process. New DETER tables must be created as a precondition to start this task.