Skip to content

Observability

Quick Summary

dagctl provides comprehensive monitoring and visualization tools to track job executions, identify issues, and understand model dependencies across your projects.

Framework differences

The Monitoring dashboard is optimized for SQLMesh model health tracking with interval-based scheduling. For dbt projects, use the Runs tab on your project page to view execution history. The Catalog and Lineage features work with both frameworks.

Monitoring Dashboard

Access the Monitoring dashboard from the main navigation under Get Insights > Monitoring.

Project Selection

Select a project from the dropdown to view its models and execution data. The dashboard displays:

  • Total Models - All SQLMesh models in the project
  • Active Models - Models with completed intervals (have been executed)
  • Health Score - Percentage of models executing on schedule

Model Health Status

Each model is tracked with a health status based on its execution schedule:

Status Indicator Meaning
Healthy 🟢 Green Model executed within expected timeframe
Warning 🟡 Yellow Model execution delayed but within grace period
Critical 🔴 Red Model significantly overdue for execution
Complete 🔵 Blue Model has finished processing all available data
Unknown ⚪ Gray No execution history or schedule information
N/A — Model type doesn't require scheduled execution (Views, External)

Health Calculation:

  • Health status considers the model's execution schedule (cron or interval unit)
  • Accounts for whether the model has a defined end date
  • Provides grace periods before marking models as warning or critical
  • Views and External models are excluded from health tracking

Recent Failures Alert

The dashboard prominently displays models that failed in the past 24 hours:

  • Failure count - Total failed model executions
  • Model name - Which models failed
  • Timestamp - When the failure occurred
  • Error message - Details about what went wrong
  • Interval information - Which data interval failed to process

This alert is collapsible and helps you quickly identify and address issues.

Model Details Table

The bottom section displays a paginated table of all models with:

  • Favorite toggle - Star icon to mark important models
  • Health indicator - Visual status icon
  • Model name - Cleaned, readable format
  • Type badge - Color-coded model type
  • Schedule - Cron expression or interval unit
  • Interval count - Number of completed intervals
  • Last execution - How long ago the model ran

Click on any model to view additional details in the side panel.

DAG Visualization

Access the Dependency Graph from a project's detail page: Projects > [Project Name] > DAG

Interactive Graph

The DAG visualizer displays your SQLMesh models as an interactive flow diagram:

  • Nodes - Each model is represented as a color-coded box
  • Edges - Arrows show dependencies between models
  • Layout - Automatic left-to-right layout with proper spacing
  • Colors - Nodes are colored by model type for easy identification