looker-health-pulse

“looker-health-pulse” performs health checks on a Looker instance, with multiple actions available (e.g., checking database connections, dashboard performance, etc).

About

The looker-health-pulse tool performs health checks on a Looker instance. The action parameter selects the type of check to perform:

  • check_db_connections: Checks all database connections, runs supported tests, and reports query counts.
  • check_dashboard_performance: Finds dashboards with slow running queries in the last 7 days.
  • check_dashboard_errors: Lists dashboards with erroring queries in the last 7 days.
  • check_explore_performance: Lists the slowest explores in the last 7 days and reports average query runtime.
  • check_schedule_failures: Lists schedules that have failed in the last 7 days.
  • check_legacy_features: Lists enabled legacy features. (To note, this function is not available in Looker Core. You will get an error running this command with a Core instance configured.)

Parameters

fieldtyperequireddescription
kindstringtrueMust be “looker-health-pulse”
sourcestringtrueLooker source name
actionstringtrueThe health check to perform

Example

tools:
  pulse:
    kind: looker-health-pulse
    source: looker-source
    description: |
      Pulse Tool

      Performs health checks on Looker instance.
      Specify the `action` parameter to select the check.
    parameters:
      action: check_dashboard_performance

Reference

actiondescription
check_db_connectionsChecks all database connections and reports query counts and errors
check_dashboard_performanceFinds dashboards with slow queries (>30s) in the last 7 days
check_dashboard_errorsLists dashboards with erroring queries in the last 7 days
check_explore_performanceLists slowest explores and average query runtime
check_schedule_failuresLists failed schedules in the last 7 days
check_legacy_featuresLists enabled legacy features