Reference documentation and code samples for the Google BigQuery v2 API enum BigQueryInsertStatus.
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"]],[["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-08-07 UTC."],[[["\u003cp\u003eThis document provides reference information for the \u003ccode\u003eBigQueryInsertStatus\u003c/code\u003e enum within the Google BigQuery v2 API, detailing the status of data insertion attempts.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eBigQueryInsertStatus\u003c/code\u003e enum specifies if all, some, or none of the rows were successfully inserted into BigQuery, based on row validity and \u003ccode\u003eAllowUnknownFields\u003c/code\u003e settings.\u003c/p\u003e\n"],["\u003cp\u003eRow validity is determined by the \u003ccode\u003eAllowUnknownFields\u003c/code\u003e setting, where \u003ccode\u003etrue\u003c/code\u003e allows insertion of matching fields while skipping unmatching ones, and \u003ccode\u003efalse\u003c/code\u003e rejects rows with unmatching fields.\u003c/p\u003e\n"],["\u003cp\u003eThe status \u003ccode\u003eNoRowsInserted\u003c/code\u003e occurs when no rows are valid, or when \u003ccode\u003eSkipInvalidRows\u003c/code\u003e is false and at least one row is invalid.\u003c/p\u003e\n"],["\u003cp\u003eThe status \u003ccode\u003eSomeRowsInserted\u003c/code\u003e happens only when \u003ccode\u003eSkipInvalidRows\u003c/code\u003e is true and some but not all rows are invalid, and when this occurs, \u003ccode\u003eBigQueryInsertResults\u003c/code\u003e contains information about rows that were not inserted.\u003c/p\u003e\n"]]],[],null,[]]
