Bigquery Insert Rows

import googleCloud from "../../google_cloud.app.mjs"; import utils from "../../common/utils.mjs"; export default { name: "Bigquery Insert Rows", version: "0.0.3", key: "google_cloud-bigquery-insert-rows", type: "action", description: "Inserts rows into a BigQuery table. [See the docs](https://github.com/googleapis/nodejs-bigquery) and for an example [here](https://github.com/googleapis/nodejs-bigquery/blob/main/samples/insertRowsAsStream.js).", props: { googleCloud, datasetId: { propDefinition: [ googleCloud, "datasetId", ], }, tableId: { propDefinition: [ googleCloud, "tableId", ({ datasetId }) => ({ datasetId, }), ], }, rows: { type: "string[]", label: "Rows", description: "The rows to insert into the table. Each row is a JSON object with column names as keys and rows as values. E.g. `{\"name\": \"John\", \"age\": 20}`", }, }, async run({ $ }) { const { datasetId, tableId, rows, } = this; if (!Array.isArray(rows)) { throw new Error("Rows must be an array"); } const rowsParsed = rows.map(utils.parse); try { const response = await this.googleCloud .getBigQueryClient() .dataset(datasetId) .table(tableId) .insert(rowsParsed); $.export("$summary", `Successfully inserted ${rows.length} rows into ${datasetId}.${tableId}`); return response; } catch (error) { console.log(JSON.stringify(error.errors, null, 2)); throw error; } }, };

Label	Prop	Type	Description
Google Cloud	`googleCloud`	`app`	This component uses the Google Cloud app.
Dataset ID	`datasetId`	`string`	Select a value from the drop down menu.
Table Name	`tableId`	`string`	Select a value from the drop down menu.
Rows	`rows`	`string[]`	The rows to insert into the table. Each row is a JSON object with column names as keys and rows as values. E.g. `{"name": "John", "age": 20}`

Label

Prop

Type

Description

Google Cloud

googleCloud

app

This component uses the Google Cloud app.

Dataset ID

datasetId

string

Select a value from the drop down menu.

Table Name

tableId

string

Select a value from the drop down menu.

Rows

rows

string[]

The rows to insert into the table. Each row is a JSON object with column names as keys and rows as values. E.g. {"name": "John", "age": 20}

Bigquery Insert Rows with Google Cloud API

Pipedream makes it easy to connect APIs for Google Cloud and 2,500+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

Integrations#

Details#

Code#

Configuration#

Authentication#

About Google Cloud#

More Ways to Use Google Cloud#

Triggers#

Actions#

Explore Other Apps#

1
-
24
of
2,500+
apps by most popular

Bigquery Insert Rows with Google Cloud API

Pipedream makes it easy to connect APIs for Google Cloud and 2,500+ other apps remarkably fast.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

1-24of2,500+apps by most popular

1
-
24
of
2,500+
apps by most popular