select tbNameStatus, count(*)
from (
    select 
        (case 
            when tbName is null then 'empty'  
            when tbName = '' then 'empty' 
            else 'defined' 
        end) as tbNameStatus
    from (
        select trim(data ->> 'temporaryTableName') as tbName, id
        from task ta
        where ta.task_type in ('BIGQUERY_PROCESS_DATA')
        and ta.created BETWEEN (now() at time zone 'utc') - INTERVAL '3 DAY' AND (now() at time zone 'utc')
    ) ta
) t
group by 1

select task.id, JSON_VALUE(task.data, '$.processedRecords') processedRecords, task.* except (id), taskLog.logmessage
from `labs-app-mdm-production.mdm_tasks.mdm_tasks` task
inner join (
  select *
  FROM (SELECT jsonPayload.tasklog.* FROM `labs-app-mdm-production.mdm_tasks.stdout` where timestamp > timestamp_add(current_timestamp(), interval -2 DAY))
  where logmessage like '%Number of records processed:%'
) taskLog on taskLog.taskid = task.id
where capturedatetime = (select max(capturedatetime) from `labs-app-mdm-production.mdm_tasks.mdm_tasks`)
and task_type = 'BIGQUERY_PROCESS_DATA'
and (JSON_VALUE(task.data, '$.processedRecords') is null or cast((JSON_VALUE(task.data, '$.processedRecords')) as int64) < 0)
order by created
limit 1000