BigQuery Client - Class Job (1.34.0)

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

Jobs are objects that manage asynchronous tasks such as running queries, loading data, and exporting data.

Namespace

Google \ Cloud \ BigQuery

Methods

__construct

Parameters
Name
Description
connection
Connection\ConnectionInterface

Represents a connection to BigQuery. This object is created by BigQueryClient, and should not be instantiated outside of this client.

id
string

The job's ID.

projectId
string

The project's ID.

mapper
ValueMapper

Maps values between PHP and BigQuery.

info
array

[optional] The job's metadata.

location
string|null

[optional] A default geographic location, used when no job metadata exists.

exists

Check whether or not the job exists.

Example:

 echo $job->exists(); 
Returns
Type
Description
bool

cancel

Parameter
Name
Description
options
array

[optional] Configuration options.

queryResults

Parameters
Name
Description
options
array

Configuration options.

↳ maxResults
int

Maximum number of results to read per page.

↳ startIndex
int

Zero-based index of the starting row.

↳ initialTimeoutMs
int

How long, in milliseconds, to wait for query results to become available before timing out. Defaults to 0 milliseconds (0 seconds). Please note that this option is used only for the initial call to get query results. To control the timeout for any subsequent calls while polling for query results to complete, please see the $timeoutMs option.

↳ timeoutMs
int

How long, in milliseconds, each API call will wait for query results to become available before timing out. Depending on whether the $maxRetries has been exceeded, the results will be polled again after the timeout has been reached. Defaults to 10000 milliseconds (10 seconds). Please note that this option is used when iterating on the returned class, and will not apply immediately upon calling of this method.

↳ maxRetries
int

The number of times to poll the Job status, until the job is complete. By default, will poll indefinitely. Please note that this option is used when iterating on the returned class, and will not block immediately upon calling of this method.

↳ returnRawResults
bool

Returns the raw data types returned from BigQuery without converting their values into native PHP types or the custom type classes supported by this library. Default is false

↳ formatOptions.useInt64Timestamp
boolean

Optional. Output timestamp as usec int64. Default is false.

Returns
Type
Description

waitUntilComplete

Blocks until the job is complete.

Example:

 $job->waitUntilComplete(); 
Parameters
Name
Description
options
array

Configuration options.

↳ maxRetries
int

The number of times to poll the Job status, until the job is complete. By default, will poll indefinitely.

isComplete

Checks the job's completeness.

Useful in combination with Job::reload() to poll for job status.

Example:

 $isComplete = $job->isComplete();

while (!$isComplete) {
    sleep(1); // let's wait for a moment...
    $job->reload();
    $isComplete = $job->isComplete();
}

echo 'Query complete!'; 
Parameter
Name
Description
options
array

[optional] Configuration options.

Returns
Type
Description
bool

info

Parameter
Name
Description
options
array

[optional] Configuration options.

Returns
Type
Description
array

reload

Parameter
Name
Description
options
array

[optional] Configuration options.

Returns
Type
Description
array

id

Retrieves the job's ID.

Example:

 echo $job->id(); 
Returns
Type
Description
string

identity

Retrieves the job's identity.

An identity provides a description of a nested resource.

Example:

 echo $job->identity()['projectId']; 
Returns
Type
Description
array

Constants

MAX_RETRIES

  Value: PHP_INT_MAX 
 
Design a Mobile Site
View Site in Mobile | Classic
Share by: