Google BigQuery PHP Sample Application

Description

This simple command-line application demonstrates how to invoke Google BigQuery from PHP.

Build and Run

1. Enable APIs - Enable the BigQuery API and create a new project or select an existing project.

2. 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_CREDENTIALS to the path of the JSON key that was downloaded.

3. 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.

Contributing changes

• See CONTRIBUTING.md

Licensing

• See LICENSE