Control: Turbot > Workspace > Health Control

Description

DB Queries health summary.

Usage

Run the control in your terminal:

powerpipe control run guardrails_insights.control.workspace_health_control

Snapshot and share results via Turbot Pipes:

powerpipe login
powerpipe control run guardrails_insights.control.workspace_health_control --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/workspaceHealthControl'
order by
  workspace;