Explorer lista de jobs do BQ
Description
-
Design Lista de Jobs com Side Panel:
-
Query para obter dados:
SELECTcreation_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.
-