> ## Documentation Index
> Fetch the complete documentation index at: https://docs.blinkops.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Insert All BigQuery Table Data

Streams data into BigQuery one record at a time without needing to run a load job. Requires the WRITER dataset role.

<Note>
  External Documentation

  To learn more, visit the [GCP documentation](https://cloud.google.com/bigquery/docs/reference/rest/v2/tabledata/insertAll).
</Note>

## Basic Parameters

<div className="integrations-table">
  | Parameter  | Description                          |
  | ---------- | ------------------------------------ |
  | Dataset ID | Dataset ID of the destination table. |
  | Project ID | Project ID of the destination table. |
  | Rows       | The rows to insert.                  |
  | Table ID   | Table ID of the destination table.   |
</div>

## Advanced Parameters

<div className="integrations-table">
  | Parameter             | Description                                                                                                                                                                                                                                                                                                                                                                                                                                                                     |
  | --------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
  | Ignore Unknown Values | \[Optional] Accept rows that contain values that do not match the schema. The unknown values are ignored. Default is false, which treats unknown values as errors.                                                                                                                                                                                                                                                                                                              |
  | Kind                  | The resource type of the response.                                                                                                                                                                                                                                                                                                                                                                                                                                              |
  | Skip Invalid Rows     | \[Optional] Insert all valid rows of a request, even if invalid rows exist. The default value is false, which causes the entire request to fail if any invalid rows exist.                                                                                                                                                                                                                                                                                                      |
  | Template Suffix       | If specified, treats the destination table as a base template, and inserts the rows into an instance table named "{destination}{templateSuffix}". BigQuery will manage creation of the instance table, using the schema of the base template table. See [https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables](https://cloud.google.com/bigquery/streaming-data-into-bigquery#template-tables) for considerations when working with templates tables. |
</div>

## Example Output

```json theme={"dark"}
{
	"insertErrors": [
		{
			"errors": [
				{
					"debugInfo": "Debugging information. This property is internal to Google and should not be used.",
					"location": "Specifies where the error occurred, if present.",
					"message": "A human-readable description of the error.",
					"reason": "A short error code that summarizes the error."
				}
			],
			"index": 0
		}
	],
	"kind": "bigquery#tableDataInsertAllResponse"
}
```

## Workflow Library Example

[Insert All Bigquery Table Data with Gcp and Send Results Via Email](https://library.blinkops.com/workflows/insert-all-bigquery-table-data-with-gcp-and-send-results-via-email)

<div className="iframe-wrapper">
  <div className="iframe-media">
    <img src="https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max&auto=format&n=ojHYuDeYX5FWuN8a&q=85&s=b8af968e71438a9499c3223c9bd29fb2" alt="Workflow Library" width="16" height="16" data-path="img/Icons/play-box.svg" />

    Preview this Workflow on desktop
  </div>

  <iframe className="iframe" src="https://library.blinkops.com/workflows/insert-all-bigquery-table-data-with-gcp-and-send-results-via-email/canvas" />
</div>