Control: Turbot > Cache > Health Check

Description

Check Cache health status.

Usage

Run the control in your terminal:

powerpipe control run guardrails_insights.control.cache_health_check

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run guardrails_insights.control.cache_health_check --share

SQL

This control uses a named query:

select
  id as resource,
  case 
    when state in ('tbd', 'invalid') then 'info'
    else state
  end as status,
  case
    when state = 'ok' then split_part(workspace, '//', 2) || ' is healthy.' 
    else split_part(workspace, '//', 2) || ' ' || reason || '.' 
  end as reason 
  , split_part(workspace, '//', 2) as workspace 
from
  guardrails_control 
where
  control_type_uri = 'tmod:@turbot/turbot#/control/types/cacheHealthCheck' 
order by
  workspace;