Explorer lista de jobs do BQ

Description

  • Query para obter dados:

SELECT  creation_time, /* destaque */  start_time,  timestamp_diff(end_time, start_time, SECOND) took, /* destaque */  timestamp_diff(creation_time, start_time, SECOND) waiting_time,  (total_slot_ms/1000) slotSeconds, /* destaque */  error_result.reason as error_reason,  cache_hit,  query,  job_id,  state, /* destaque */  reservation_id,  user_email, /* destaque */  job_type,   labels /* destaque label source / requestor para looker */FROM `region-us`.INFORMATION_SCHEMA.JOBSWHERE creation_time >= TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 3 DAY)ORDER BY creation_time DESC;

  • Ajustar labels de Execution Plan (retirar os : ao final para manter o padrão):

    • Creation Time vamos chamar de Created

    • Waiting time está OK

    • Elapsed time vamos chamar de Query duration

    • Satus está OK

    • Rows returned está OK

    • Bytes shuffled está OK

    • Slot time consumed vamos chamar de Slot usage

    • Avg slots consumed vamos chamar de Avg slots usage

    • Query está OK

    • Processes está OK.