Using SQL to gather information about a query job can be easier than using the command line. However, by using SQL, you are limited to the fields that Google has chosen to make available through the INFORMATION_SCHEMA jobs views. Moreover, you are dependent on BigQuery slots to get information. So, depending on the slots available to the project to which the query job assessment query job is billed, using SQL could delay the availability of information.

For queries to obtain information about query jobs, see Section 6.2, “Query Jobs” and Section 6.3, “Query Job Stages”.