Specifies the status of an insert attempt depending on the validity of the rows.
Note that the validity of a row is determined by whether AllowUnknownFields
is set to true or not.
If AllowUnknownFields is set to true, then rows containing fields
that do not match any on the destination table will, otherwise, be considered valid rows.
All matching fields in these rows will be inserted, while unmatching fields will be silently skipped.
If AllowUnknownFields is not set to true, then rows containing fields
that do not match any on the destination table will be considered invalid and won't be inserted.
All rows were inserted successfully.
This only happens if all rows are valid rows.
NoRowsInserted
No rows were inserted. In that case the BigQueryInsertResults
returned by the insert operation will contain error information about the invalid rows.
This can happen when:
No rows are valid.
SkipInvalidRows is not set to true and at least
one row is invalid.
SomeRowsInserted
Some rows were inserted but not others. In that case the BigQueryInsertResults
returned by the insert operation will contain error information about the rows that were not inserted.
This happens only when SkipInvalidRows is set to true and some,
but not all of the rows, are invalid.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-04-17 UTC."],[[["The `BigQueryInsertStatus` enum indicates the outcome of a BigQuery insert operation, specifically whether rows were inserted based on their validity."],["The validity of rows is determined by the `AllowUnknownFields` setting, where true allows for fields not matching the destination table to be skipped rather than invalidating the entire row, while false will invalidate any row with unmatched fields."],["There are three possible statuses: `AllRowsInserted`, indicating all rows were successfully added; `NoRowsInserted`, indicating no rows were added due to invalidity; and `SomeRowsInserted`, indicating that only some rows were added due to others being deemed invalid."],["The `NoRowsInserted` and `SomeRowsInserted` statuses return a `BigQueryInsertResults` object containing error information regarding the rows that were invalid, which would detail why they were not inserted into the table."],["The `SkipInvalidRows` option determines if any rows are inserted even if some are invalid, and this status is only achievable when this option is set to true."]]],[]]
