BigQuery Client for PHP


Idiomatic PHP client for Google BigQuery.

Latest Stable Version Packagist

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


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.

Next Steps

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