Class InsertAllRequest (2.55.2)
Version 2.55.2keyboard_arrow_down
public final class InsertAllRequest implements Serializable
Google Cloud BigQuery insert all request. This class can be used to stream data into BigQuery one
record at a time without needing to run a load job. This approach enables querying data without
the delay of running a load job. There are several important trade-offs to consider before
choosing an approach.
See Also: Streaming Data into BigQuery
Inheritance
Object >
InsertAllRequest
Static Methods
newBuilder(TableId table)
public static InsertAllRequest . Builder newBuilder ( TableId table )
Returns a builder for an InsertAllRequest object given the destination table.
Parameter
Name Description
tableTableId
newBuilder(TableId table, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest . Builder newBuilder ( TableId table , InsertAllRequest . RowToInsert [] rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
newBuilder(TableId table, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest . Builder newBuilder ( TableId table , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
newBuilder(TableInfo tableInfo, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest . Builder newBuilder ( TableInfo tableInfo , InsertAllRequest . RowToInsert [] rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
newBuilder(TableInfo tableInfo, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest . Builder newBuilder ( TableInfo tableInfo , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
newBuilder(String datasetId, String tableId)
public static InsertAllRequest . Builder newBuilder ( String datasetId , String tableId )
Returns a builder for an InsertAllRequest object given the destination table.
newBuilder(String datasetId, String tableId, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest . Builder newBuilder ( String datasetId , String tableId , InsertAllRequest . RowToInsert [] rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
newBuilder(String datasetId, String tableId, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest . Builder newBuilder ( String datasetId , String tableId , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a builder for an InsertAllRequest object given the destination table and the
rows to insert.
of(TableId tableId, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest of ( TableId tableId , InsertAllRequest . RowToInsert [] rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
of(TableId tableId, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest of ( TableId tableId , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
of(TableInfo tableInfo, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest of ( TableInfo tableInfo , InsertAllRequest . RowToInsert [] rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
of(TableInfo tableInfo, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest of ( TableInfo tableInfo , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
of(String datasetId, String tableId, InsertAllRequest.RowToInsert[] rows)
public static InsertAllRequest of ( String datasetId , String tableId , InsertAllRequest . RowToInsert [] rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
of(String datasetId, String tableId, Iterable<InsertAllRequest.RowToInsert> rows)
public static InsertAllRequest of ( String datasetId , String tableId , Iterable<InsertAllRequest . RowToInsert > rows )
Returns a InsertAllRequest object given the destination table and the rows to insert.
Methods
equals(Object obj)
public boolean equals ( Object obj )
Parameter
Name Description
objObject
Overrides
getOtelAttributes()
public Attributes getOtelAttributes ()
Returns
Type Description
io.opentelemetry.api.common.Attributes
getRows()
public List<InsertAllRequest . RowToInsert > getRows ()
Returns the rows to be inserted.
getTable()
public TableId getTable ()
Returns the destination table for rows insert request.
getTemplateSuffix()
public String getTemplateSuffix ()
If specified, the destination table is treated as a base template. Rows are inserted into an
instance table named "{destination}{templateSuffix}". BigQuery will manage the creation of the
instance table, using the schema of the base template table. Table creation might take some
time. To obtain table's information after BigQuery#insertAll(InsertAllRequest) is
called use:
String suffixTableId = ...;
TableInfo suffixTable = bigquery . getTable ( DATASET , suffixTableId );
while ( suffixTable == null ) {
Thread . sleep ( 1000L );
suffixTable = bigquery . getTable ( DATASET , suffixTableId );
}
See Also: Template Tables
Returns
Type Description
String
hashCode()
Returns
Type Description
int
Overrides
ignoreUnknownValues()
public Boolean ignoreUnknownValues ()
Returns whether to accept rows that contain values that do not match the schema. The unknown
values are ignored. If not set, rows with unknown values are considered to be invalid.
skipInvalidRows()
public Boolean skipInvalidRows ()
Returns whether to insert all valid rows of a request, even if invalid rows exist. If not set
the entire insert request will fail if it contains an invalid row.
toString()
Returns
Type Description
String
Overrides
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License , and code samples are licensed under the Apache 2.0 License . For details, see the Google Developers Site Policies . Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-10-29 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-10-29 UTC."],[],[]]
