Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from http://cloud.google.com/php/docs/reference/cloud-bigquery/latest/BigQueryClient below:

BigQuery Client - Class BigQueryClient (1.34.0) | PHP Client Libraries

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

• 1.34.0 (latest)
• 1.33.1
• 1.32.0
• 1.31.1
• 1.30.3
• 1.29.0
• 1.28.3
• 1.27.0
• 1.26.1
• 1.25.1
• 1.24.2
• 1.23.10

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

Google Cloud BigQuery allows you to create, manage, share and query data.

Find more information at the Google Cloud BigQuery Docs.

Example:

use Google\Cloud\BigQuery\BigQueryClient;

$bigQuery = new BigQueryClient();

Create a BigQuery client.

Configuration options.

The hostname with optional port to use in place of the default service endpoint. Example: foobar.com or foobar.com:1234.

The project ID from the Google Developer's Console.

A cache for storing access tokens. Defaults to a simple in memory implementation.

Cache configuration options.

A handler used to deliver Psr7 requests specifically for authentication.

A credentials fetcher instance.

A handler used to deliver Psr7 requests. Only valid for requests sent over REST.

The contents of the service account credentials .json file retrieved from the Google Developer's Console. Ex: json_decode(file_get_contents($path), true).

The full path to your service account credentials .json file retrieved from the Google Developers Console.

Seconds to wait before timing out the request. Defaults to 0 with REST and 60 with gRPC.

Number of retries for a failed request. Defaults to 3.

Scopes to be used for the request.

Specifies a user project to bill for access charges associated with the request.

If true, 64 bit integers will be returned as a Google\Cloud\Core\Int64 object for 32 bit platform compatibility. Defaults to false.

If provided, determines the default geographic location used when creating datasets and managing jobs. Please note: This is only required for jobs started outside of the US and EU regions. Also, if location metadata has already been fetched over the network it will take precedent over this setting (by calling Table::reload(), for example).

Returns a BigQuery job configuration.

The job configuration is passed to either BigQueryClient::runQuery() or BigQueryClient::startQuery(). A configuration can be built using fluent setters or by providing a full set of options at once.

Unless otherwise specified, all configuration options will default based on the query job configuration except for configuration.query.useLegacySql, which defaults to false in this client.

Example:

$queryJobConfig = $bigQuery->query(
    'SELECT commit FROM `bigquery-public-data.github_repos.commits` LIMIT 100'
);

// Set create disposition using fluent setters.
$queryJobConfig = $bigQuery->query(
    'SELECT commit FROM `bigquery-public-data.github_repos.commits` LIMIT 100'
)->createDisposition('CREATE_NEVER');

// This is equivalent to the above example, using array configuration
// instead of fluent setters.
$queryJobConfig = $bigQuery->query(
    'SELECT commit FROM `bigquery-public-data.github_repos.commits` LIMIT 100',
    [
        'configuration' => [
            'query' => [
                'createDisposition' => 'CREATE_NEVER'
            ]
        ]
    ]
);

// Set a region to run the job in.
$queryJobConfig = $bigQuery->query(
    'SELECT name FROM `my_project.users_dataset.users` LIMIT 100'
)->location('asia-northeast1');

A BigQuery SQL query.

Configuration options.

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

Query job configuration. Please see the documentation for the available options.

Returns a BigQuery job configuration.

The job configuration is passed to either BigQueryClient::runQuery() or BigQueryClient::startQuery(). A configuration can be built using fluent setters or by providing a full set of options at once.

Unless otherwise specified, all configuration options will default based on the query job configuration except for configuration.query.useLegacySql, which defaults to false in this client.

As this method is an alias, please see BigQueryClient::query() for usage examples.

A BigQuery SQL query.

Configuration options.

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

Query job configuration. Please see the documentation for the available options.

A BigQuery SQL query configuration.

Configuration options.

The maximum number of rows to return per page of results. Setting this flag to a small value such as 1000 and then paging through results might improve reliability when the query result set is large.

Zero-based index of the starting row.

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

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

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.

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

A BigQuery SQL query configuration.

[optional] Configuration options.

Lazily instantiates a job.

There are no network requests made at this point. To see the operations that can be performed on a job please see Job.

Example:

$job = $bigQuery->job('myJobId');

The id of the already run or running job to request.

Configuration options.

The geographic location of the job. Required for jobs started outside of the US and EU regions. Defaults to a location specified in the client configuration.

Configuration options.

Whether to display jobs owned by all users in the project. Defaults to false.

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.

Filter for job state. Maybe be either done, pending, or running.

Milliseconds since the POSIX epoch. If set, only jobs created before or at this timestamp are returned.

Milliseconds since the POSIX epoch. If set, only jobs created after or at this timestamp are returned.

If set, show only child jobs of the specified parent. Otherwise, show all top-level jobs.

Lazily instantiates a dataset.

There are no network requests made at this point. To see the operations that can be performed on a dataset please see Dataset.

If the dataset is owned by a different project than the project used to authenticate the client, provide the project ID as the second argument.

Example:

$dataset = $bigQuery->dataset('myDatasetId');

// Reference a dataset from other project.
$dataset = $bigQuery->dataset('samples', 'bigquery-public-data');

The id of the dataset to request.

The id of the project. Defaults to current project id.

Configuration options.

Whether to list all datasets, including hidden ones. Defaults to false.

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.

An expression for filtering the results of the request by label. The syntax is "labels.

The id of the dataset to create.

Configuration options.

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

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.

Create a Bytes object.

Example:

$bytes = $bigQuery->bytes('hello world');

The bytes value.

Create a Date object.

Example:

$date = $bigQuery->date(new \DateTime('1995-02-04'));

The date value.

Create an Int64 object. This can be used to work with 64 bit integers as a string value while on a 32 bit platform.

Example:

$int64 = $bigQuery->int64('9223372036854775807');

The 64 bit integer value in string format.

Create a Time object.

Example:

$time = $bigQuery->time(new \DateTime('12:15:00.482172'));

The time value.

Create a Timestamp object.

Example:

$timestamp = $bigQuery->timestamp(new \DateTime('2003-02-05 11:15:02.421827Z'));

The timestamp value.

Create a Numeric object.

Numeric represents a value with a data type of Numeric.

It supports a fixed 38 decimal digits of precision and 9 decimal digits of scale, and values are in the range of -99999999999999999999999999999.999999999 to 99999999999999999999999999999.999999999.

Example:

$numeric = $bigQuery->numeric('99999999999999999999999999999999999999.999999999');

The Numeric value.

Create a BigNumeric object.

Numeric represents a value with a data type of BIGNUMERIC.

It supports 76.76 (the 77th digit is partial) decimal digits of precision and 38 decimal digits of scale. Values are in the range of -5.7896044618658097711785492504343953926634992332820282019728792003956564819968E+38 to 5.7896044618658097711785492504343953926634992332820282019728792003956564819967E+38.

Example:

$bigNumeric = $bigQuery->bigNumeric('999999999999999999999999999999999999999999999.99999999999999');

The Numeric value.

Create a Geography object.

Example:

$geography = $bigQuery->geography('POINT(10 20)');

The geography data in WKT format.

Create a BigQuery Json object.

Json represents a value with a data type of JSON

Example:

use Google\Cloud\BigQuery\BigQueryClient;

$bigQuery = new BigQueryClient();
$json = $bigQuery->json('{"key":"value"}');

The JSON string value.

Get a service account for the KMS integration.

Example:

$serviceAccount = $bigQuery->getServiceAccount();

[optional] Configuration options.

Configuration options.

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

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

Configuration options.

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

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

Configuration options.

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

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

Value: 'https://www.googleapis.com/auth/bigquery'

Value: 'https://www.googleapis.com/auth/bigquery.insertdata'

Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-08-07 UTC.

[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[],[]]

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4