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 \ BigQueryMethods
__construct
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
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!';
}
bool
delete
See also:
options
array
[optional] Configuration options.
update
metadata
options
array
[optional] Configuration options.
rows
See also:
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.
Google\Cloud\Core\Iterator\ItemIterator
runJob
See also:
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
.
startJob
See also:
config
Google\Cloud\BigQuery\JobConfigurationInterface
The job configuration.
options
array
[optional] Configuration options.
copy
See also:
destination
options
array
Configuration options.
↳ configuration
↳ configuration
extract
See also:
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
↳ configuration
load
See also:
data
string|resource| Psr\Http\Message\StreamInterface
The data to load.
options
array
Configuration options.
↳ configuration
↳ configuration
loadFromStorage
See also:
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
↳ configuration
insertRow
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
insertRows
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.
info
See also:
options
array
[optional] Configuration options.
array
reload
See also:
options
array
[optional] Configuration options.
array
id
Retrieves the table's ID.
Example:
echo $table->id();
string
identity
Retrieves the table's identity.
An identity provides a description of a nested resource.
Example:
echo $table->identity()['projectId'];
array
iam
See also:
Google\Cloud\Core\Iam\Iam
Constants
MAX_RETRIES
Value: 100
INSERT_CREATE_MAX_DELAY_MICROSECONDS
Value: 60000000
