Skip to main content

How to configure the Data Warehouse

  1. Connect your Big Query Project in GameAnalytics: Navigate to the PipelineIQ configuration page → Add your Google Group Email account and hit Save.
  2. Wait for activation: The setup may take up to 30 minutes to become active.
  3. Start querying in Google BigQuery: You can access your project by clicking “” in the PipelineIQ or directly in BigQuery’s project selector.
info

Access to your Google BigQuery project is granted via the Google group, not individual email addresses. This allows your team to manage permissions by adding or removing members from the group. Data only starts populating once Data Warehouse is activated.

Google BigQuery Introduction​

GameAnalytics uses GoogleBigQuery to power the Data Warehouse. If you’re new to BigQuery, you can explore it using Google’s Get Started Guide and try queries in a free sandbox.

Key Concepts in BigQuery​

ProjectYour organization’s main GCP entity.
DatasetA grouping of tables and views. You are free to create other datasets, for example if you wish to store the results of common queries.
TableContains data formatted in rows and columns. Tables in the Data Warehouse are managed by GameAnalytics–you can’t add to them, but you can copy them in your own datasets.
ViewA virtual table based on a SQL query. It doesn’t store data, but displays results from other tables.