kumologica-contrib-bigquery
A Kumologica node to query and insert data in Google BigQuery.
Install
Available via Kumologica Designer.
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.
This property support dynamic expression, which allows you to concatenate dynamic values into the field: msg, vars, env.
BigQuery Insert Node
Insert multiple 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.