Tool to stream data into BigQuery one record at a time without running a load job. Use when you need immediate data availability or inserting small batches. Supports row-level deduplication via insertId and error handling via skipInvalidRows.
rowsRequiredarrayRequired. Array of rows to insert. Each row contains the data to be inserted as a JSON object. At least one row must be provided.
traceIdstringOptional. Unique request trace ID for debugging. Case-sensitive, up to 36 ASCII characters. A UUID is recommended.
table_idRequiredstringRequired. Table ID of the destination table.
dataset_idRequiredstringRequired. Dataset ID of the destination table.
project_idRequiredstringRequired. Project ID of the destination table.
templateSuffixstringOptional. If specified, treats the destination table as a base template and inserts rows into an instance table named '{destination}{templateSuffix}'. Useful for table sharding patterns.
skipInvalidRowsbooleanOptional. If true, insert all valid rows even if some rows are invalid. If false (default), the entire request fails if any row is invalid.
ignoreUnknownValuesbooleanOptional. If true, accept rows with values that don't match the schema and ignore the unknown values. If false (default), treat unknown values as errors.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
OAuth connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.