Database Reference
In-Depth Information
used in computing billing
for table storage.
number
How many additional rows
of data were added to the
table.
load.outputRows
Jobs.insert()
When you insert a job into the Jobs collection, this tells BigQuery to run
a job to perform some asynchronous operation on your behalf. The only
information you need to provide is the
configuration
section. That said,
it is strongly recommended that you also provide a
jobId
in the
jobReference
section, so that it is easier to track what happened if
something goes wrong. The following commands create a job ID from the
current time and run a
curl
request to start a Query job.
$
JOB_ID=job_$(date +"%s")
$
JOB_REFERENCE="{'jobId': '${JOB_ID}', 'projectId':
'${PROJECT_ID}'}"
$
JOB_CONFIG="{'query': {'query': 'select 17'}}"
$
JOB="{'jobReference': ${JOB_REF}, 'configuration':
${JOB_CONFIG}}"
$
curl -H "$(python auth.py)" \
-
H "Content-Type: application/json" \
-
X POST \
--
data-binary "${JOB}" \
"${JOBS_URL}"
{
…
"jobReference": {
"projectId": "bigquery-e2e",
"jobId": " job_1394518034"
},
"configuration": {
"query": {
"query": "select 17",
"destinationTable": {