Set up a Google Cloud project with a storage bucket and a service account, then go to Settings → Integrations, click BigQuery, fill in the fields and click Connect to BigQuery. Data is loaded every 3 hours by default.
What you need
A Google Cloud project with BigQuery.
A Google Cloud Storage bucket for staging, in the same region as your BigQuery dataset.
A service account with a JSON key that can write to BigQuery and the bucket.
Connect in Nettla
Go to Settings → Integrations.
Click the BigQuery tile.
Enter the GCP Project ID.
Enter the Staging GCS Storage Bucket Name.
Paste the GCP Service Account Credentials JSON.
Choose the Sync Frequency: every 30 minutes, 1, 3, 6, 12 or 24 hours. The default is every 3 hours.
Turn on Enable cleanup of object storage files if you want staging files removed (optional).
Click Connect to BigQuery.
The tile then shows Connected.
Good to know
BigQuery receives all four categories by default: user, booking, payment and court events. Change this with the gear icon.
Setting up BigQuery and reports on top of it is technical. We recommend working with a data engineer who knows SQL and Google Cloud.
See "Included Data" for the events and fields you'll receive.
