Query: dms_replication_task_target_database_logging_enabled

with replication_task_target_apply as (
  select
    arn
  from
    aws_dms_replication_task,
    jsonb_array_elements(
      replication_task_settings -> 'Logging' -> 'LogComponents'
    ) as o
  where
    o ->> 'Id' = 'TARGET_APPLY'
    and o ->> 'Severity' in (
      'LOGGER_SEVERITY_DEFAULT',
      'LOGGER_SEVERITY_DEBUG',
      'LOGGER_SEVERITY_DETAILED_DEBUG'
    )
),
replication_task_target_load as (
  select
    arn
  from
    aws_dms_replication_task,
    jsonb_array_elements(
      replication_task_settings -> 'Logging' -> 'LogComponents'
    ) as o
  where
    o ->> 'Id' = 'TARGET_LOAD'
    and o ->> 'Severity' in (
      'LOGGER_SEVERITY_DEFAULT',
      'LOGGER_SEVERITY_DEBUG',
      'LOGGER_SEVERITY_DETAILED_DEBUG'
    )
)
select
  t.arn as resource,
  (
    replication_task_settings -> 'Logging' ->> 'EnableLogging'
  ) :: bool,
  case
    when (
      replication_task_settings -> 'Logging' ->> 'EnableLogging'
    ) :: bool
    and a.arn is not null
    and l.arn is not null then 'ok'
    else 'alarm'
  end as status,
  case
    when (
      replication_task_settings -> 'Logging' ->> 'EnableLogging'
    ) :: bool
    and a.arn is not null
    and l.arn is not null then title || ' target database logging enabled.'
    else title || 'target database logging disabled.'
  end as reason,
  region,
  account_id
from
  aws_dms_replication_task as t
  left join replication_task_target_apply as a on a.arn = t.arn
  left join replication_task_target_load as l on l.arn = t.arn;