Preprod Batch_log:

SELECT
job_id,
run_id,
source_table,
table_name,
partition_id,
-- batch_id,
-- batch_size,
write_time,
error,
success_inserts,
success_updates,
-- no_ops,
failed_inserts,
failed_updates,
skipped,
quarantine_table,

start_time,
end_time,
invalid_records,
partition_size

,from_utc_timestamp(time, 'America/Chicago') time
,DATE(from_utc_timestamp(time, 'America/Chicago')) Date
FROM ddu_quarantine.batch_log
WHERE from_utc_timestamp(time, 'America/Chicago') > (CURRENT_DATE()-7)