GCP BigQuery

Server Source code Package

The GCP destination package provides server-side integration for streaming events from walkerOS to Google BigQuery for data warehousing, analytics, and machine learning workloads.

Installation

Loading...

Setup

Loading...

Configuration reference

Property	Type	Description	More
client	any	Google Cloud BigQuery client instance
projectId*	string	Google Cloud Project ID
datasetId*	string	BigQuery dataset ID where events will be stored
tableId*	string	BigQuery table ID for event storage
location*	string	Geographic location for the BigQuery dataset
bigquery	any	Additional BigQuery client configuration options

* Required fields

Default Table Schema

By default, the destination sends the full walkerOS event to BigQuery. All object and array fields are JSON stringified before insertion.

Column	Type	Description
timestamp	TIMESTAMP	Event timestamp
createdAt	TIMESTAMP	Row insertion time
name	STRING	Full event name ("entity action")
id	STRING	Unique event ID
entity	STRING	Entity name
action	STRING	Action name
trigger	STRING	Event trigger
group	STRING	Event group
timing	FLOAT64	Event timing
count	INT64	Event count
data	STRING	JSON stringified data object
context	STRING	JSON stringified context
globals	STRING	JSON stringified globals
custom	STRING	JSON stringified custom data
user	STRING	JSON stringified user object
nested	STRING	JSON stringified nested entities
consent	STRING	JSON stringified consent
version	STRING	JSON stringified version
source	STRING	JSON stringified source

Create Table Query

Use this SQL query to create the default table schema in BigQuery:

Loading...

Custom Schema Mapping

You can send a custom schema by using the data configuration to map specific fields. This is useful when you only need a subset of the event data.

Example: Simple Schema

This example sends only name, id, data, and timestamp:

Loading...

With the corresponding simpler table:

Loading...