Google BigQuery for PHP

Idiomatic PHP client forGoogle BigQuery.

Latest Stable VersionPackagist

NOTE: This repository is part ofGoogle Cloud PHP. Anysupport requests, bug reports, or development contributions should be directed tothat project.

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

Installation

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

Now install this component:

$ composer require google/cloud-bigquery

Authentication

Please see ourAuthentication guide for more informationon authenticating your client. Once authenticated, you'll be ready to start making requests.

Sample

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);}

Debugging

Please see ourDebugging guidefor more information about the debugging tools.

Version

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

Next Steps

  1. Understand theofficial documentation.
  2. Take a look atin-depth usage samples.

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

Last updated 2026-01-24 UTC.