Comment on page

Data Quality Monitoring

You can use LogicLoop to monitor data uptime. Your company may already be using tools like Great Expectations, Monte Carlo dbt cloud for data monitoring. In addition, users have found LogicLoop useful to monitor data-driven metrics and external APIs that aren't easily captured by these systems. See below for some examples.
Alert when an API is down
Every 10 minutes, query an API your service relies on. The API can be an external or internal service.
If the request fails, LogicLoop will send you an email notifying you of the failure.
Monitor a drop in new user sign ups
Detect if number of signups on the website has been low, that could stem from data issues.
View SQL Query
SELECT
  count(*)
FROM
  user_signups
WHERE
  created_at < interval - '60 minutes'
HAVING
  count(*) < 10
Send a Slack alert to your team to investigate.
Monitor drop in a critical business unit
Similarly, you can use LogicLoop to monitor when there's a drop or change in a unit critical to your business. 
Digital health companies: monitor a drop in the number of appointments scheduled today.
Recruiting companies: monitor a drop in the number of candidates who were scheduled for interviews today.
E-commerce companies: monitor a drop in the number of orders placed in the past hour.
Ride-share marketplace: monitor the number of rides completed in the past hour.
Monitor data stuck in processing
Select all data that are still processing after a certain amount of time.
View SQL Query
SELECT
  *
FROM
  applications
WHERE
  status = 'pending'
HAVING
  AND created_at > current_date - interval '7 days'
Create an Asana ticket for an analyst to review.
Monitor invalid database fields 
Query for fields that should not be Null
View SQL Query
SELECT
  *
FROM
  users
WHERE
  email is NULL
Create a JIRA ticket for an engineer to review.
Monitor children database objects with no parent
Query for children objects that are orphaned.
View SQL Query
SELECT
  *
FROM
  children
WHERE
  parent is NULL
Create a PagerDuty alert for an engineer to review immediately. 
Data Distribution Shifts for Machine Learning Models
LogicLoop can also detect data shifts for your ML model. See a complete list of Data Quality checks supported here. 
https://demo.getlogicloop.com/dashboards/24-data-quality-checks
demo.getlogicloop.com

Templates - Previous

Systems Observability

Next - Templates

Healthcare

Last modified 5mo ago