define("CLIENT_ID", 'CLIENT ID');
$key = file_get_contents(KEY_FILE);
$client = new Google_Client();
$client->setAssertionCredentials(new Google_Auth_AssertionCredentials(SERVICE_ACCOUNT_NAME, array('https://www.googleapis.com/auth/bigquery'), $key));
$client->setClientId(CLIENT_ID);
// Instantiate a new BigQuery Client
$service = new Google_Service_Bigquery($client);
$fields = array(array('name' => 'user_id', 'type' => 'integer', 'mode' => 'required'), array('name' => 'order_id', 'type' => 'integer', 'mode' => 'required'), array('name' => 'status', 'type' => 'integer', 'mode' => 'nullable'), array('name' => 'timestamp', 'type' => 'timestamp', 'mode' => 'nullable'));
$table_reference = new Google_Service_Bigquery_TableReference();
$table_reference->setProjectId(PROJECT_ID);
$table_reference->setDatasetId(DATASET_ID);
$table_reference->setTableId(TABLE_ID);
$schema = new Google_Service_Bigquery_TableSchema();
$schema->setFields($fields);
$table = new Google_Service_Bigquery_Table();
$table->setTableReference($table_reference);
$table->setSchema($schema);
try {
    $result = $service->tables->insert(PROJECT_ID, DATASET_ID, $table);
    print_r($result);
} catch (Google_Service_Exception $e) {
    echo $e->getMessage();
}
?>
</pre>
<p><span style="color: #339966;"><em><strong>Understanding the code</strong></em></span></p>
<p><strong>define("KEY_FILE", 'KEY FILE NAME');</strong></p>
<p>You will have to put your downloaded key file in the directory same as your php file. And provide a name to your key file here. </p>
<p><strong>define("SERVICE_ACCOUNT_NAME", 'SERVICE ACCOUNT NAME');</strong></p>
<p>This is the service account name for your account. If you are not getting a thing about this service account, Please see <a href="http://webtutplus.com/bigquery-basic-setup/" target="_blank">http://webtutplus.com/bigquery-basic-setup/</a> </p>
<p>
Example #2
0
 /**
  * Create a new table
  *
  * @param string $tableName
  * @param string $description
  * @param array  $fields Array of fields where each field is in this format:
  *                       ['name' => 'fieldName', 'type' => 'integer', 'mode' => 'required']
  *
  * @throws \Exception
  */
 public function createTable($tableName, $description, $fields)
 {
     $tableReference = $this->getTableReference($tableName);
     $this->_debug("Creating table " . $this->getDataSet() . '.' . $tableName);
     $service = $this->getService();
     $tableSchema = new \Google_Service_Bigquery_TableSchema();
     $tableSchema->setFields($fields);
     $bqTable = new \Google_Service_Bigquery_Table();
     $bqTable->setDescription($description);
     $bqTable->setTableReference($tableReference);
     $bqTable->setSchema($tableSchema);
     $options = [];
     try {
         $service->tables->insert($this->bigQueryProject(), $this->getDataSet(), $bqTable, $options);
     } catch (\Exception $e) {
         if (!stristr($e->getMessage(), 'Already Exists: Table')) {
             throw $e;
         }
     }
 }