Class InsertAllRequest (2.36.0)

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

Implements

Serializable

Static Methods

newBuilder(TableId table)

public static InsertAllRequest.Builder newBuilder(TableId table)

Returns a builder for an InsertAllRequest object given the destination table.

Parameter
NameDescription
tableTableId
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
tableTableId
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
tableTableId
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
tableInfoTableInfo
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
tableInfoTableInfo
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
datasetIdString
tableIdString
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
datasetIdString
tableIdString
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
datasetIdString
tableIdString
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest.Builder

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.

Parameters
NameDescription
tableIdTableId
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest

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.

Parameters
NameDescription
tableIdTableId
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest

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.

Parameters
NameDescription
tableInfoTableInfo
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest

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.

Parameters
NameDescription
tableInfoTableInfo
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest

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.

Parameters
NameDescription
datasetIdString
tableIdString
rowsRowToInsert[]
Returns
TypeDescription
InsertAllRequest

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.

Parameters
NameDescription
datasetIdString
tableIdString
rowsIterable<RowToInsert>
Returns
TypeDescription
InsertAllRequest

Methods

equals(Object obj)

public boolean equals(Object obj)
Parameter
NameDescription
objObject
Returns
TypeDescription
boolean
Overrides

getRows()

public List<InsertAllRequest.RowToInsert> getRows()

Returns the rows to be inserted.

Returns
TypeDescription
List<RowToInsert>

getTable()

public TableId getTable()

Returns the destination table for rows insert request.

Returns
TypeDescription
TableId

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
TypeDescription
String

hashCode()

public int hashCode()
Returns
TypeDescription
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.

Returns
TypeDescription
Boolean

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.

Returns
TypeDescription
Boolean

toString()

public String toString()
Returns
TypeDescription
String
Overrides