Calculate availability in a period of time in Databricks with python and sql

Job ID: 35280531

Budget: $10 – $30 USD

Using a database where have the time when ocurrs the errors in service calculate availability using the formula:
Availability: MTBF /(MTBF+MTTR)
MTBF = Uptime / Number of System Failures
MTTR = CM Downtime / Number of System Failures

- The time is saved as string
- Is necessary send 2 parameters (start time, end time, orquest, metod)
- orquest is the service type
- metod is relative to orquest
the result of function or procedure will be availability in that period
Related categories: Python SQL PySpark Apache Spark