Database Reference
In-Depth Information
Figure 4.6
Job states and errors
You can use the
bq
tool to inspect job state by using the
show -j
command.
The following code snippet creates a load job that will fail because the data
doesn't match the schema, and get the status of the job during each of the
three job phases.
$
JOB_ID=job_$(date +"%s")
$
bq --nosync -job_id=${JOB_ID} \
load scratch.table1 temp.csv "f1,f2"
Successfully started load bigquery-e2e:job_1394420275
$
bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration Bytes
Processed
---------- --------- ------------ ----------
-----------------
load PENDING
$
bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration
Bytes Processed
---------- --------- ----------------- ----------
-----------------
load RUNNING 21 Jul 15:32:14
$
bq show -j ${JOB_ID}
Job bigquery-e2e:job_1394420275
Job Type State Start Time Duration
Bytes Processed
---------- --------- ----------------- ----------
-----------------
load DONE 21 Jul 15:32:14 0:00:05