Database Reference
In-Depth Information
Table 12.1
Extract Configuration Fields
Field Type Description
sourceTable.tableid string
Table ID of the source table
sourceTable.datasetId string
Dataset ID of the dataset
containing the table to export
datasetReference.projectId string
Project ID of the project that
owns the table to be exported
Where to write the output
destinationUris
string
array
string
Either
CSV
or
NEWLINE_DELIMITED_JSON
,
depending on the wanted
format of the output. The
default is
CSV
.
destinationFormat
boolean
Whether to include a header
row with the names of the
fields. This is only valid for
destinationFormat =
CSV
.
printHeader
string
Single character to use to
separate fields. This is only
valid when
destinationFormat
= CSV.
The default is “
,
.”
fieldDelimiter
Most of these parameters are relatively straightforward; however, the
destinationUris
could benefit from a little bit of extra explanation. The
destinationUris
value should contain a path that the user running the
job has write access to in GCS. GCS paths look like
gs://bucketname/
objectname
. Although you can specify additional slashes in the name to
make it look like a directory, there is no real directory hierarchy. A path
like
gs://bucket/directory/subdir/object
just refers to an object
named
directory/subdir/object
in bucket
bucket
. This is