This simple command-line application demonstrates how to invoke Google BigQuery from PHP.
-
Enable APIs - Enable the BigQuery API and create a new project or select an existing project.
-
Download The Credentials - Click "Go to credentials" after enabling the APIs. Click "New Credentials" and select "Service Account Key". Create a new service account, use the JSON key type, and select "Create". Once downloaded, set the environment variable
GOOGLE_APPLICATION_CREDENTIALSto the path of the JSON key that was downloaded. -
Clone the repo and cd into this directory
$ git clone https://github.com/GoogleCloudPlatform/php-docs-samples $ cd php-docs-samples/bigquery/api
4. **Install dependencies** via [Composer](http://getcomposer.org/doc/00-intro.md).
Run `php composer.phar install` (if composer is installed locally) or `composer install`
(if composer is installed globally).
5. Run `php bigquery.php`. The following commands are available:
```sh
browse-table Browse a BigQuery table
datasets List BigQuery datasets
export Export data from a BigQuery table into a Cloud Storage bucket
import Import data into a BigQuery table
projects List BigQuery projects
query Run a BigQuery query
schema Create or delete a table schema in BigQuery
tables List BigQuery tables
6. Run `php bigquery.php COMMAND --help` to print information about the usage of each command.
- See CONTRIBUTING.md
- See LICENSE