Created on May 11, 2022
Everytime a work-order is created, everytime a picture is sent to analysis, everytime a work-order is reviewed, the data is stored in the engage DB (also called Vulcain DB).
Insights DB creation
To create our dashboards, we never use the data directly from the engage DB.
To feed our client DB, we need to set up a cloud function. This cloud function will run everynight to export and aggregate the data (generated during the previous day) from a replica of the engage DB to our client DB.
The data in the client DB is stored into three tables: work-orders, task-groups and tasks.
Access the data
To create Insights Dashboards, we need data !
- work-orders- task-groups- tasks