Insert rows with no IDs

  import 
  
 com.google.cloud.bigquery. BigQuery 
 
 ; 
 import 
  
 com.google.cloud.bigquery. BigQueryError 
 
 ; 
 import 
  
 com.google.cloud.bigquery. BigQueryException 
 
 ; 
 import 
  
 com.google.cloud.bigquery. BigQueryOptions 
 
 ; 
 import 
  
 com.google.cloud.bigquery. InsertAllRequest 
 
 ; 
 import 
  
 com.google.cloud.bigquery. InsertAllResponse 
 
 ; 
 import 
  
 com.google.cloud.bigquery. TableId 
 
 ; 
 import 
  
 com.google.common.collect.ImmutableList 
 ; 
 import 
  
 java.util.HashMap 
 ; 
 import 
  
 java.util.List 
 ; 
 import 
  
 java.util.Map 
 ; 
 // Sample to insert rows without row ids in a table 
 public 
  
 class 
 TableInsertRowsWithoutRowIds 
  
 { 
  
 public 
  
 static 
  
 void 
  
 main 
 ( 
 String 
 [] 
  
 args 
 ) 
  
 { 
  
 // TODO(developer): Replace these variables before running the sample. 
  
 String 
  
 datasetName 
  
 = 
  
 "MY_DATASET_NAME" 
 ; 
  
 String 
  
 tableName 
  
 = 
  
 "MY_TABLE_NAME" 
 ; 
  
 tableInsertRowsWithoutRowIds 
 ( 
 datasetName 
 , 
  
 tableName 
 ); 
  
 } 
  
 public 
  
 static 
  
 void 
  
 tableInsertRowsWithoutRowIds 
 ( 
 String 
  
 datasetName 
 , 
  
 String 
  
 tableName 
 ) 
  
 { 
  
 try 
  
 { 
  
 // Initialize client that will be used to send requests. This client only needs to be created 
  
 // once, and can be reused for multiple requests. 
  
 final 
  
 BigQuery 
  
 bigquery 
  
 = 
  
 BigQueryOptions 
 . 
 getDefaultInstance 
 (). 
 getService 
 (); 
  
 // Create rows to insert 
  
 Map<String 
 , 
  
 Object 
>  
 rowContent1 
  
 = 
  
 new 
  
 HashMap 
<> (); 
  
 rowContent1 
 . 
 put 
 ( 
 "stringField" 
 , 
  
 "Phred Phlyntstone" 
 ); 
  
 rowContent1 
 . 
 put 
 ( 
 "numericField" 
 , 
  
 32 
 ); 
  
 Map<String 
 , 
  
 Object 
>  
 rowContent2 
  
 = 
  
 new 
  
 HashMap 
<> (); 
  
 rowContent2 
 . 
 put 
 ( 
 "stringField" 
 , 
  
 "Wylma Phlyntstone" 
 ); 
  
 rowContent2 
 . 
 put 
 ( 
 "numericField" 
 , 
  
 29 
 ); 
  
 InsertAllResponse 
  
 response 
  
 = 
  
 bigquery 
 . 
 insertAll 
 ( 
  
 InsertAllRequest 
 . 
 newBuilder 
 ( 
 TableId 
 . 
 of 
 ( 
 datasetName 
 , 
  
 tableName 
 )) 
  
 // No row ids disable de-duplication, and also disable the retries in the Java 
  
 // library. 
  
 . 
 setRows 
 ( 
  
 ImmutableList 
 . 
 of 
 ( 
  
 InsertAllRequest 
 . 
 RowToInsert 
 . 
 of 
 ( 
 rowContent1 
 ), 
  
 InsertAllRequest 
 . 
 RowToInsert 
 . 
 of 
 ( 
 rowContent2 
 ))) 
  
 . 
 build 
 ()); 
  
 if 
  
 ( 
 response 
 . 
 hasErrors 
 ()) 
  
 { 
  
 // If any of the insertions failed, this lets you inspect the errors 
  
 for 
  
 ( 
 Map 
 . 
 Entry<Long 
 , 
  
 List<BigQueryError> 
>  
 entry 
  
 : 
  
 response 
 . 
 getInsertErrors 
 (). 
 entrySet 
 ()) 
  
 { 
  
 System 
 . 
 out 
 . 
 println 
 ( 
 "Response error: \n" 
  
 + 
  
 entry 
 . 
 getValue 
 ()); 
  
 } 
  
 } 
  
 System 
 . 
 out 
 . 
 println 
 ( 
 "Rows successfully inserted into table without row ids" 
 ); 
  
 } 
  
 catch 
  
 ( 
 BigQueryException 
  
 e 
 ) 
  
 { 
  
 System 
 . 
 out 
 . 
 println 
 ( 
 "Insert operation not performed \n" 
  
 + 
  
 e 
 . 
 toString 
 ()); 
  
 } 
  
 } 
 } 
 

  use Google\Cloud\BigQuery\BigQueryClient; 
 /** 
 * Insert rows into the given table with explicitly giving row ids. 
 * 
 * @param string $projectId The project Id of your Google Cloud Project. 
 * @param string $datasetId The BigQuery dataset ID. 
 * @param string $tableId The BigQuery table ID. 
 * @param string $rowData1 Json encoded data to insert. 
 * @param string $rowData2 Json encoded data to insert. For eg, 
 *    $rowData1 = json_encode([ 
 *        "field1" => "value1", 
 *        "field2" => "value2" 
 *    ]); 
 *    $rowData2 = json_encode([ 
 *        "field1" => "value1", 
 *        "field2" => "value2" 
 *    ]); 
 */ 
 function table_insert_rows_explicit_none_insert_ids( 
 string $projectId, 
 string $datasetId, 
 string $tableId, 
 string $rowData1, 
 string $rowData2 
 ): void { 
 $bigQuery = new BigQueryClient([ 
 'projectId' => $projectId, 
 ]); 
 $dataset = $bigQuery->dataset($datasetId); 
 $table = $dataset->table($tableId); 
 $rowData1 = json_decode($rowData1, true); 
 $rowData2 = json_decode($rowData2, true); 
 // Omitting insert Id's in following rows. 
 $rows = [ 
 ['data' => $rowData1], 
 ['data' => $rowData2] 
 ]; 
 $insertResponse = $table->insertRows($rows); 
 if ($insertResponse->isSuccessful()) { 
 printf('Rows successfully inserted into table without insert ids' . PHP_EOL); 
 } else { 
 foreach ($insertResponse->failedRows() as $row) { 
 foreach ($row['errors'] as $error) { 
 printf('%s: %s' . PHP_EOL, $error['reason'], $error['message']); 
 } 
 } 
 } 
 } 
 

  from 
  
 google.cloud 
  
 import 
  bigquery 
 
 # Construct a BigQuery client object. 
 client 
 = 
  bigquery 
 
 . 
  Client 
 
 () 
 # TODO(developer): Set table_id to the ID of table to append to. 
 # table_id = "your-project.your_dataset.your_table" 
 rows_to_insert 
 = 
 [ 
 { 
 "full_name" 
 : 
 "Phred Phlyntstone" 
 , 
 "age" 
 : 
 32 
 }, 
 { 
 "full_name" 
 : 
 "Wylma Phlyntstone" 
 , 
 "age" 
 : 
 29 
 }, 
 ] 
 errors 
 = 
 client 
 . 
  insert_rows_json 
 
 ( 
 table_id 
 , 
 rows_to_insert 
 , 
 row_ids 
 = 
 [ 
 None 
 ] 
 * 
 len 
 ( 
 rows_to_insert 
 ) 
 ) 
 # Make an API request. 
 if 
 errors 
 == 
 []: 
 print 
 ( 
 "New rows have been added." 
 ) 
 else 
 : 
 print 
 ( 
 "Encountered errors while inserting rows: 
 {} 
 " 
 . 
 format 
 ( 
 errors 
 ))