Idiomatic PHP client for Google BigQuery.

• API Documentation

NOTE: This repository is part of Google Cloud PHP. Any support requests, bug reports, or development contributions should be directed to that project.

Allows you to create, manage, share and query data.

To begin, install the preferred dependency manager for PHP, Composer.

Now install this component:

$ composer require google/cloud-bigquery

Please see our Authentication guide for more information on authenticating your client. Once authenticated, you'll be ready to start making requests.

require 'vendor/autoload.php';
use Google\Cloud\BigQuery\BigQueryClient;
$bigQuery = new BigQueryClient();
// Get an instance of a previously created table.
$dataset = $bigQuery->dataset('my_dataset');
$table = $dataset->table('my_table');
// Begin a job to import data from a CSV file into the table.
$loadJobConfig = $table->load(
    fopen('/data/my_data.csv', 'r')
);
$job = $table->runJob($loadJobConfig);
// Run a query and inspect the results.
$queryJobConfig = $bigQuery->query(
    'SELECT * FROM `my_project.my_dataset.my_table`'
);
$queryResults = $bigQuery->runQuery($queryJobConfig);
foreach ($queryResults as $row) {
    print_r($row);
}

Please see our Debugging guide for more information about the debugging tools.

This component is considered GA (generally available). As such, it will not introduce backwards-incompatible changes in any minor or patch releases. We will address issues and requests with the highest priority.

1. Understand the official documentation.
2. Take a look at in-depth usage samples.