$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> <strong>define("CLIENT_ID", 'CLIENT ID');</strong></p>
/** * 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; } } }