BigQuery

Storing and querying massive datasets can be time-consuming and expensive without the right hardware and infrastructure. Google BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google's infrastructure. Simply move your data into BigQuery and let us handle the hard work. You can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data. Source: Google

Command

The BigQuery command start a stream insert into a dataset table.

rhub add:action <group.eventId> <filterId> GCP BIQUERY

Param

Description

eventId

The event that will receive te action.

Example: payment.payment-fulfilled

filterId

The filter/trigger in the event that will process the action.

Example: on-event

Prompt Questions

Question

Description

Dataset Name

The dataset name.

Table Name

The table name of the informed dataset.

IMPORTANT

The dataset and table MUST exist.

YAML

-
id: my-action-id
async: false
type: GCP
action: BIGQUERY
serviceAccountId: my-google-cloud-project-account
template:
dataset: my-dataset
table: my-table
schema:
keyName: '{keyName}'

YAML PARAMS

Params

Description

id, async, type, action, operation, serviceAccountId

The action default parameters, see more.

dataset

The dataset name.

table

The table name .

schema

Key / Value object:

Key = The table column name

Value = The value to insert into the column