terraform/modules/bigquery/views/v_errors_retryable.tpl (15 lines of code) (raw):
WITH retryable AS
(
SELECT DISTINCT
jsonPayload.global_run_id AS run_id,
jsonPayload.retryable_ex_tracking_id AS tracking_id,
resource.labels.service_name AS service_name,
jsonPayload.retryable_ex_name AS exception_name,
jsonPayload.retryable_ex_msg AS exception_message,
FROM
`${project}.${dataset}.${logging_table}`
WHERE
jsonPayload.global_app_log = 'RETRYABLE_EXCEPTIONS_LOG'
ORDER BY 2
)
SELECT * FROM retryable