External Data Processing - Google BigQuery Analytics - page 483

"tableId": "shakespeare",
"datasetId": "samples"
}
}
},
"id": "bigquery-e2e:job_1395596963",
"selfLink": "https://www.googleapis.com/bigquery/v2/
projects/…"
}
PENDING 1s
PENDING 7s
PENDING 12s
PENDING 17s
RUNNING 23s
RUNNING 29s
DONE 35s
JOB COMPLETED
Downloading:
gs://bigquery-e2e/output/
samples.shakespeare_1395596964.json to
/tmp/bigquery/output/
samples.shakespeare_1395596964.json
The default extract format, like the default in Load jobs, is CSV. If you have
tables with nested and repeated fields, CSV won't work because you can't
represent a repeated field as a comma-separated row without introducing
new formatting—at which point it isn't actually CSV anymore. If you don't
want to export your data as CSV, you can specify a destinationFormat of
NEWLINE_DELIMITED_JSON , which outputs each row as a JSON element,
with each row separated by a newline character ( \n ). Table 12.1 lists all the
configuration options for an Extract job.