Google BigQuery for PHP
Idiomatic PHP client forGoogle BigQuery.
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-bigqueryAuthentication
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
- Understand theofficial documentation.
- 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.