BigQuery Client - Class ExtractJobConfiguration (1.30.1)

Reference documentation and code samples for the BigQuery Client class ExtractJobConfiguration.

Represents a configuration for an extract job. For more information on the available settings please see the Jobs configuration API documentation.

Example:

use Google\Cloud\BigQuery\BigQueryClient;

$bigQuery = new BigQueryClient();
$table = $bigQuery->dataset('my_dataset')
    ->table('my_table');
$extractJobConfig = $table->extract('gs://my_bucket/target.csv');

Namespace

Google \ Cloud \ BigQuery

Methods

__construct

Parameters
Name	Description
`projectId`	`string` The project's ID.
`config`	`array` A set of configuration options for a job.
`location`	`string\|null` The geographic location in which the job is executed.

compression

Sets the compression type to use for exported files.

Not applicable when extracting models.

Example:

$extractJobConfig->compression('GZIP');

Parameter
Name	Description
`compression`	`string` The compression type. Acceptable values include `"GZIP"`, `"NONE"`. Defaults to `"NONE"`.

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

destinationFormat

Sets the exported file format. Tables with nested or repeated fields cannot be exported as CSV.

Example:

$extractJobConfig->destinationFormat('NEWLINE_DELIMITED_JSON');

Parameter
Name	Description
`destinationFormat`	`string` The exported file format. Acceptable values for tables include `CSV`, `NEWLINE_DELIMITED_JSON`, `AVRO`. For models, acceptable values include `ML_TF_SAVED_MODEL` and `ML_XGBOOST_BOOSTER`. Defaults to `CSV` for tables, or `ML_TF_SAVED_MODEL` for models.

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

destinationUris

Sets a list of fully-qualified Google Cloud Storage URIs where the extracted table should be written.

Example:

$extractJobConfig->destinationUris([
    'gs://my_bucket/destination.csv'
]);

Parameter
Name	Description
`destinationUris`	`array` The destination URIs.

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

fieldDelimiter

Sets the delimiter to use between fields in the exported data.

Not applicable when extracting models.

Example:

$extractJobConfig->fieldDelimiter(',');

Parameter
Name	Description
`fieldDelimiter`	`string` The field delimiter. Defaults to `","`.

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

printHeader

Sets whether or not to print out a header row in the results.

Not applicable when extracting models.

Example:

$extractJobConfig->printHeader(false);

Parameter
Name	Description
`printHeader`	`bool` Whether or not to print out a header row. Defaults to `true`.

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

sourceTable

Sets a reference to the table being exported.

Cannot be used in the same job as Google\Cloud\BigQuery\ExtractJobConfiguration::sourceModel().

Example:

$table = $bigQuery->dataset('my_dataset')
    ->table('my_table');
$extractJobConfig->sourceTable($table);

Parameter
Name	Description
`sourceTable`	`Google\Cloud\BigQuery\Table`

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

sourceModel

Sets a reference to the model being exported.

Cannot be used in the same job as Google\Cloud\BigQuery\ExtractJobConfiguration::sourceTable().

Example:

$model = $bigQuery->dataset('my_dataset')
    ->model('my_model');
$extractJobConfig->sourceModel($model);

Parameter
Name	Description
`sourceModel`	`Google\Cloud\BigQuery\Model`

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`

useAvroLogicalTypes

Sets whether to use logical types when extracting to AVRO format.

If destinationFormat is set to "AVRO", this flag indicates whether to enable extracting applicable column types (such as TIMESTAMP) to their corresponding AVRO logical types (timestamp-micros), instead of only using their raw types (avro-long).

Not applicable when extracting models.

Example:

$extractJobConfig->useAvroLogicalTypes(true);

Parameter
Name	Description
`useAvroLogicalTypes`	`bool`

Returns
Type	Description
`Google\Cloud\BigQuery\ExtractJobConfiguration`