BigQuery
Stream Teachfloor xAPI events into BigQuery as native JSON. Choose streaming inserts for near-real-time dashboards or free load jobs for cost-optimized batches — both feed the same table your analytics team already queries.
Features
Native BigQuery JSON, no schema migrations
Events are stored using BigQuery's native JSON type. Query nested fields with JSON_VALUE and JSONPath, join against your dimensional tables, feed Looker Studio and Tableau — all without a schema migration when Teachfloor's payload evolves.
Two ingest modes, one destination
Streaming inserts for ~10-second latency dashboards, or load jobs for free batch writes that work on any GCP project — sandbox included. Switch modes anytime; the destination table stays put.
Canonical xAPI, ready for BI
Every row is a full xAPI statement — actors, verbs, activities, results, context. Build learner-activity dashboards in minutes, or pipe into your ML feature store for predictive completion models.
Permissions
Once installed, BigQuery will be permitted access to your Teachfloor data as described below.
- ProfileRead-only
- OpenidRead-only
- EmailRead-only
- Courses:ReadRead-only