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
 
Search WWH ::




Custom Search