Explorer lista de jobs do BQ
Description
-
Design Lista de Jobs com Side Panel:
-
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.JOBS
WHERE 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.
-
Details
Created: 20 February 2025, 13:37
Updated:
5 May 2025, 20:05