turbot/guardrails_insights

Query: guardrails_control_error_between_90_365_days

Usage

powerpipe query guardrails_insights.query.guardrails_control_error_between_90_365_days

Steampipe Tables

SQL

with between_90_365_days as
(
select
now()::date - update_timestamp::date as days
from
guardrails_control
where
update_timestamp between symmetric (now() - '90 days'::interval) and
(
now() - '365 days'::interval
)
and state = 'error'
)
select
count(*) as value,
'90-365 Days' as label
from
between_90_365_days;

Dashboards

The query is used in the dashboards: