Google BigQuery

Google BigQuery Data Warehouse Setup

The Google BigQuery Data Warehouse integration with Ours Privacy provides a powerful solution for storing and analyzing large volumes of event data. BigQuery’s high-performance, scalable infrastructure allows you to efficiently process complex queries on vast datasets while ensuring privacy compliance.

With Google BigQuery, you can set up a secure, fast-access data warehouse that enables you to gain valuable insights from user event data across various sources. This integration can be used with analytics platforms, machine learning models, and data visualization tools to drive data-driven decisions with strong data privacy measures in place.

How Google BigQuery Integration Works

When configured as a data warehouse, Google BigQuery functions as the central hub for storing event data from your Ours Privacy platform. BigQuery’s SQL-based querying engine allows for fast, in-place analysis of data, removing the need for additional ETL processes and enabling instant access to actionable insights.

Getting Started with Google BigQuery Integration

To start using Google BigQuery as your data warehouse with Ours Privacy, please reach out to your account manager. They will guide you through the setup process to ensure your BigQuery environment is optimized for privacy compliance and data security.

Once configured, your Ours Privacy events will automatically be stored in your BigQuery instance, giving you a secure, scalable data warehouse solution for all your analytics and reporting needs.

Granting Ours Privacy Permission to BigQuery

  1. Go to the Google Cloud > IAM and Grant Access

Google Cloud IAM

  1. Ours Privacy will give you an email address to enter as the Principal. Please enter this email and assign the "BigQuery Data Editor" role.
  1. Enter the Google Cloud Project ID, BigQuery Dataset and Table name inside of your Ours Privacy app
  1. Add the events you wish to have sent over to BigQuery to your Allowed Events list