Query: vcn_subnet_flow_logs

select
  case when is_enabled then 'Enabled' else 'Disabled' end as value,
  'Flow Logs' as label,
  case when is_enabled then 'ok' else 'alert' end as type
from
  oci_core_subnet as s
  left join oci_logging_log as l
  on s.id = l.configuration -> 'source' ->> 'resource'
where
  s.id = $1 and s.lifecycle_state <> 'TERMINATED';