turbot/guardrails_insights
GitHub

Query: guardrails_control_error_after_1_year

Usage

steampipe query guardrails_insights.query.guardrails_control_error_after_1_year

Plugins & Tables

SQL

with after_1_year as (
select
now() :: date - update_timestamp :: date as days
from
guardrails_control
where
update_timestamp <= now() - '1 year' :: interval
and state = 'error'
)
select
count(*) as value,
'> 1 Year' as label
from
after_1_year;

Dashboards

The query is used in the dashboards: