Performance Monitoring
Monitoring the performance of your data pipeline is critical for maintaining data quality, reliability, and operational efficiency. Proactively monitoring performance issues enables to detect bottlenecks and opportunities for optimization, prevent data delays, and avoid unnecessary costs.
Elementary monitors and logs the execution times of:
- dbt models
- dbt tests
Models performance
Navigate to the Model Duration
tab.
The table displays the latest execution time, median execution time, and execution time trend for each model. You can sort the table by these metrics and explore the execution times over time for the models with the longest durations
It is also useful to use the navigation bar to filter the results, and see run times per tag/owner/folder.
Tests performance
Navigate to the Test Execution History
tab.
On the table you can see the median execution time and fail rate per test. You can sort the table by this time column, and detect tests that are compute heavy.
It is also useful to use the navigation bar to filter the results, and see run times per tag/owner/folder.