node-red-contrib-bigquery 0.0.1

A Node-RED node to query and insert data in Google BigQuery

npm install node-red-contrib-bigquery

A Node-RED node to query and insert data in Google BigQuery.

Install

Run the following command in your Node-RED user directory - typically ~/.node-red

npm install node-red-contrib-bigquery

Authentication

Although Google Cloud Platform provides several ways to authenticate requests, this node only supports private-key authentication of service account. New service account can be created by following link.

Usage

###BigQuery Query Node

BigQuery query node. Query data in BigQuery. The query statement(currently BigQuery only supports SELECT statement) must be specified in the node property. If the query succeeded, the results are returned in msg.payload. Currently, this node supports only single statement.

###BigQuery Insert Node

BigQuery insert node. Insert mutiple data into BigQuery table. The dataset name and the table name must be specified in the node property. The insert data is taken from msg.payload which supports both single data or multiple data.<

Node Info

Version: 0.0.1
Updated 1 year, 1 month ago
License: MIT

Downloads

0 in the last day
2 in the last week
15 in the last month

Nodes

  • bigquery query
  • bigquery insert
  • bigquery-config

Keywords

  • node-red
  • gcp
  • bigquery

Maintainers

  • noralife