PBI queries 2
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)
Updated 4 months ago