BigQuery Client - Class Table (1.31.1)

Stay organized with collections Save and categorize content based on your preferences.

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

The table's id.

The dataset's id.

The project's id.

Maps values between PHP and BigQuery.

[optional] The table's metadata.

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

[optional] Configuration options.

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

[optional] Configuration options.

Configuration options.

Maximum number of results to return per page.

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

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

Zero-based index of the starting row.

The job configuration.

Configuration options.

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

The job configuration.

[optional] Configuration options.

The destination table.

Configuration options.

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

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

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}.

Configuration options.

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

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

The data to load.

Configuration options.

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

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

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}.

Configuration options.

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

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

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

Please see Table::insertRows() for the other available configuration options.

Used to ensure data consistency.

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.

Configuration options.

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.

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.

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.

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.

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.

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.

[optional] Configuration options.

[optional] Configuration options.