Datasets & Schemas Overview

Data Warehouse holds two types of data sets:

Checkpoint Data	Pre-aggregated summaries, based on standard event categories. Each row represents a unique player’s activity for a specific date.	Aggregated daily. Up to 1 year of data.
Event Data	Raw, un-aggregated data. Each row represents a single event with its timestamp.	Not aggregated. Up to 30 days of data

info

The player_checkpoint table has the bulk of the information about the player, and can be used to join with all the other tables on the user_id, game_id or player_id.