Connect Google BigQuery to Seeka to allow events and anonymous identities to stream from Seeka to a BigQuery dataset in real time.
To complete this connection, a Google Cloud account and a Google Cloud project is required.
Enabling BigQuery
Navigate to Settings > Pipelines in your Seeka app.
Click on "Connect pipeline".
Select "Google BigQuery".
To enable the streaming features that Seeka utilises to push records to BigQuery, a billing account is required to be linked to the Google Cloud project that houses your BigQuery data.
To retrieve your "Google Cloud Project ID"
In the top left corner of your Google Cloud console next to the Google Cloud logo, click the dropdown.
Copy the value in the "ID" column where the row is prefixed with a star (the currently selected project)
To retrieve your service account credentials JSON
Navigate to your service accounts in Google Cloud console
Select the project you wish to use (must match the project in the step above)
On the top bar, select "Create Service Account"
Enter the below details
Service account name: seeka-bigquery
Service account description: Seeka connection to BigQuery
Select "Create and continue"
Click "Select Role"
Search for "BigQuery Admin"
Select "BigQuery Admin" in the right column
Click "Continue"
Click "Done"
Click the row for the new "seeka-bigquery" service account
Click the "Keys" tab on the top
Click Add Key > Create new key
Ensure key type is selected as JSON then click create
Save the downloaded file and copy the contents into the "Google Cloud Service Account credentials JSON" field in the Seeka app
Hit connect in the Seeka app and data will begin streaming into your BigQuery account.
The above "Big Query Admin" role can be filtered via IAM to restrict the Seeka Service account to minimal permissions. See this Google guide on how to implement fine grain control over permissions.