view:
project_id.region.INFORMATION_SCHEMA.JOBS_BY_PROJECT
project_id
with the relevant project ID
region
with the relevant region; e.g., region-us; see https://cloud.google.com/bigquery/docs/information-schema-jobs#regionality
description:
This view contains metadata about BigQuery jobs under the given Google project and within the given region. Google documents this view at https://cloud.google.com/bigquery/docs/information-schema-jobs.
It is possible that not all fields in the REST API are exposed. The REST API is documented at https://cloud.google.com/bigquery/docs/reference/rest/v2/Job.
With respect to scripting and stored procedures, this view contains both parent jobs and child jobs. Care should be taken to avoid double counting metrics when aggregating. For information about standard metadata representations of jobs that contain scripting and/or stored procedures, see Section 3.5, “Scripting” and Section 3.6, “Stored Procedures”.
partitioning:
date of creation_time
primary keys: