Skip to content

Instantly share code, notes, and snippets.

@pentium10

pentium10/bigquery_biengine_job_statistics.sql

Created October 20, 2022 20:41
Show Gist options
  • Save pentium10/84a4ee3c60115e248c93885578256ec8 to your computer and use it in GitHub Desktop.
Save pentium10/84a4ee3c60115e248c93885578256ec8 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
bigquery_biengine_job_statistics.sql
select creation_time, job_id, bi_engine_statistics
from `prj_id.region-us`.INFORMATION_SCHEMA.JOBS_BY_PROJECT
where creation_time BETWEEN TIMESTAMP_SUB(CURRENT_TIMESTAMP(), INTERVAL 1 DAY) AND CURRENT_TIMESTAMP()
and job_type = "QUERY"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment