Using the Self Monitoring data mart
The Self Monitoring data mart provides insights into loaded data and entities for each ETL process, with metrics available over 1-day, 7-day, and 30-day intervals. It provides visibility into ETL execution metrics based on the data in the DatasourcesLoad business driver under Administration domains.
This data mart is not available by default, and you must install it as an add-on package from Administration > Maintenance. For more information, see Performing system maintenance tasks.
After installation, the data mart is available in the Administration > Data Marts section. The data mart is materialized by using the Self-Monitoring - Data Mart Materializer task, and is run only once per its configured schedule. For more information, see Configuring the Data Mart Materializer task.
Use the data from this data mart to create dashboards and custom views for self-monitoring ETLs and tracking ETL performance over time. You can also combine this data with other data marts, like the SQL-based data marts or Summary data marts.
The following data is available through the Self Monitoring data mart:
| Column name | Description |
|---|---|
| BYSRC_NAME | ETL name |
| BYSRC_LOADED_DATA_AVG | The average number of time series samples imported by ETL |
| BYSRC_LOADED_DATA_MAX | The maximum number of time series samples imported by ETL |
| BYSRC_LOADED_DATA_MIN | The minimum number of time series samples imported by ETL |
| BYSRC_LOADED_DATA_SUM | The total number of time series samples imported by ETL |
| BYSRC_LOADED_ENTITIES_AVG | The average number of entities imported by ETL |
| BYSRC_LOADED_ENTITIES_MAX | The maximum number of entities imported by ETL |
| BYSRC_LOADED_ENTITIES_MIN | The minimum number of entities imported by ETL |
| BYSRC_LOADED_ENTITIES_SUM | The total number of entities imported by ETL |