A Node-RED node to query and insert data in Google BigQuery.
Run the following command in your Node-RED user directory - typically ~/.node-red
npm install node-red-contrib-bigquery
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.
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. 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.<