> ## 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).

## Basic Parameters

| 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. |

## Advanced Parameters

| 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. |

## 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)

![Workflow Library](https://mintcdn.com/blinkops-2/ojHYuDeYX5FWuN8a/img/Icons/play-box.svg?fit=max\&auto=format\&n=ojHYuDeYX5FWuN8a\&q=85\&s=b8af968e71438a9499c3223c9bd29fb2)

Preview this Workflow on desktop

[https://library.blinkops.com/workflows/insert-all-bigquery-table-data-with-gcp-and-send-results-via-email/canvas](https://library.blinkops.com/workflows/insert-all-bigquery-table-data-with-gcp-and-send-results-via-email/canvas)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.