BigQuery Client - Class Table (1.30.3)

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

Tables are a standard two-dimensional table with individual records organized in rows, and a data type assigned to each column (also called a field).

Namespace

Google \ Cloud \ BigQuery

Methods

__construct

Parameters
Name Description
connection Google\Cloud\BigQuery\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 table's id.

datasetId string

The dataset's id.

projectId string

The project's id.

mapper Google\Cloud\BigQuery\ValueMapper

Maps values between PHP and BigQuery.

info array

[optional] The table's metadata.

location string|null

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

exists

Check whether or not the table exists.

Example:

if ($table->exists()) {
    echo 'Table exists!';
}
Returns
Type Description
bool

delete

Parameter
Name Description
options array

[optional] Configuration options.

update

Parameters
Name Description
metadata array

The available options for metadata are outlined at the Table Resource API docs

options array

[optional] Configuration options.

rows

Parameters
Name Description
options array

Configuration options.

↳ maxResults int

Maximum number of results to return per page.

↳ resultLimit int

Limit the number of results returned in total. Defaults to 0 (return all results).

↳ pageToken string

A previously-returned page token used to resume the loading of results from a specific point.

↳ startIndex int

Zero-based index of the starting row.

Returns
Type Description
Google\Cloud\Core\Iterator\ItemIterator

runJob

Parameters
Name Description
config Google\Cloud\BigQuery\JobConfigurationInterface

The job configuration.

options array

Configuration options.

↳ maxRetries int

The number of times to retry, checking if the job has completed. Defaults to 100.

Returns
Type Description
Google\Cloud\BigQuery\Job

startJob

Parameters
Name Description
config Google\Cloud\BigQuery\JobConfigurationInterface

The job configuration.

options array

[optional] Configuration options.

Returns
Type Description
Google\Cloud\BigQuery\Job

copy

Parameters
Name Description
destination Google\Cloud\BigQuery\Table

The destination table.

options array

Configuration options.

↳ configuration array

Job configuration. Please see the API documentation for the available options.

↳ configuration array

.copy Copy job configuration. Please see the documentation for the available options.

Returns
Type Description
Google\Cloud\BigQuery\CopyJobConfiguration

extract

Parameters
Name Description
destination string|Google\Cloud\Storage\StorageObject

The destination object. May be a Google\Cloud\Storage\StorageObject or a URI pointing to a Google Cloud Storage object in the format of gs://{bucket-name}/{object-name}.

options array

Configuration options.

↳ configuration array

Job configuration. Please see the API documentation for the available options.

↳ configuration array

.extract Extract job configuration. Please see the documentation for the available options.

Returns
Type Description
Google\Cloud\BigQuery\ExtractJobConfiguration

load

Parameters
Name Description
data string|resource|Psr\Http\Message\StreamInterface

The data to load.

options array

Configuration options.

↳ configuration array

Job configuration. Please see the API documentation for the available options.

↳ configuration array

.load Load job configuration. Please see the documentation for the available options.

Returns
Type Description
Google\Cloud\BigQuery\LoadJobConfiguration

loadFromStorage

Parameters
Name Description
object string|Google\Cloud\Storage\StorageObject

The object to load data from. May be a Google\Cloud\Storage\StorageObject or a URI pointing to a Google Cloud Storage object in the format of gs://{bucket-name}/{object-name}.

options array

Configuration options.

↳ configuration array

Job configuration. Please see the API documentation for the available options.

↳ configuration array

.load Load job configuration. Please see the documentation for the available options.

Returns
Type Description
Google\Cloud\BigQuery\LoadJobConfiguration

insertRow

Parameters
Name Description
row array

Key/value set of data matching the table's schema.

options array

Please see Google\Cloud\BigQuery\Table::insertRows() for the other available configuration options.

↳ insertId string

Used to ensure data consistency.

Returns
Type Description
Google\Cloud\BigQuery\InsertResponse

insertRows

Parameters
Name Description
rows array

The rows to insert. Each item in the array must contain a data key which is to hold a key/value array with data matching the schema of the table. Optionally, one may also provide an insertId key which will be used to ensure data consistency.

options array

Configuration options.

↳ autoCreate bool

Whether or not to attempt to automatically create the table in the case it does not exist. Please note, it will be required to provide a schema through $tableMetadata['schema'] in the case the table does not already exist. Defaults to false.

↳ tableMetadata array

Metadata to apply to table to be created. The full set of metadata are outlined at the Table Resource API docs. Only applies when autoCreate is true.

↳ maxRetries int

The maximum number of times to attempt creating the table in the case of failure. Please note, each retry attempt may take up to two minutes. Only applies when autoCreate is true. Defaults to 100.

↳ skipInvalidRows bool

Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist. Defaults to false.

↳ ignoreUnknownValues bool

Accept rows that contain values that do not match the schema. The unknown values are ignored. The default value is false, which treats unknown values as errors. Defaults to false.

↳ templateSuffix string

If specified, treats the destination table as a base template, and inserts the rows into an instance table named "{destination}{templateSuffix}". BigQuery will manage creation of the instance table, using the schema of the base template table. See Creating tables automatically using template tables for considerations when working with templates tables.

Returns
Type Description
Google\Cloud\BigQuery\InsertResponse

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 table's ID.

Example:

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

identity

Retrieves the table's identity.

An identity provides a description of a nested resource.

Example:

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

iam

Returns
Type Description
Google\Cloud\Core\Iam\Iam

Constants

MAX_RETRIES

Value: 100

INSERT_CREATE_MAX_DELAY_MICROSECONDS

Value: 60000000