Query: dms_replication_task_source_database_logging_enabled

with replication_task_logging as (
  select
    arn,
    bool_or(
      o ->> 'Id' = 'SOURCE_CAPTURE'
      and o ->> 'Severity' in (
        'LOGGER_SEVERITY_DEFAULT',
        'LOGGER_SEVERITY_DEBUG',
        'LOGGER_SEVERITY_DETAILED_DEBUG'
      )
    ) as capture_logging_enabled,
    bool_or(
      o ->> 'Id' = 'SOURCE_UNLOAD'
      and o ->> 'Severity' in (
        'LOGGER_SEVERITY_DEFAULT',
        'LOGGER_SEVERITY_DEBUG',
        'LOGGER_SEVERITY_DETAILED_DEBUG'
      )
    ) as unload_logging_enabled
  from
    aws_dms_replication_task,
    jsonb_array_elements(
      replication_task_settings -> 'Logging' -> 'LogComponents'
    ) as o
  group by
    arn
)
select
  t.arn as resource,
  (
    replication_task_settings -> 'Logging' ->> 'EnableLogging'
  ) :: bool as logging_enabled,
  case
    when (
      replication_task_settings -> 'Logging' ->> 'EnableLogging'
    ) :: bool
    and l.capture_logging_enabled
    and l.unload_logging_enabled then 'ok'
    else 'alarm'
  end as status,
  case
    when (
      replication_task_settings -> 'Logging' ->> 'EnableLogging'
    ) :: bool
    and l.capture_logging_enabled
    and l.unload_logging_enabled then title || ' source database logging enabled.'
    else title || ' source database logging disabled.'
  end as reason,
  region,
  account_id
from
  aws_dms_replication_task as t
  left join replication_task_logging as l on l.arn = t.arn;