Data Access available views

Explore the tables and columns available in Snowflake for querying your Analytics data through Data Access.

阅读时间5 分钟

最后更新于 10 个月前

Through the Data Access feature, you gain access to a number of views containing your account's data.

注意

The Data Access views use multiple timestamps:

```
EVENT_TIMESTAMP
```
: The time when the event was created on the client device.
```
LOADED_TIMESTAMP
```
: The time when the event was loaded into the data warehouse.

ACCOUNT_EVENTS

This table lists all of the events that have been sent in from your application. Event-specific parameters can be found in the

EVENT_JSON

column as a JSON object. As the parameters are stored as a JSON object, you'll need to parse the content in order to query it.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`LOAD_ID`	`NUMBER`
`EVENT_ID`	`NUMBER`
`EVENT_TIMESTAMP`	`TIMESTAMP`
`EVENT_NAME`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`ACQUISITION_CHANNEL`	`TEXT`
`USER_COUNTRY`	`TEXT`
`USER_ID`	`TEXT`
`EVENT_JSON`	`VARIANT`
`LOADED_TIMESTAMP`	`TIMESTAMP`

ACCOUNT_EVENT_JSON_KEYS

This table contains data on the event fields that are used for your games.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`FIELD_NAME`	`TEXT`
`INSERTED_TIMESTAMP`	`TIMESTAMP`

ACCOUNT_GAMES

This table lists all of the games that exist under your account.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`UNITY_PROJECT_ID`	`TEXT`

ACCOUNT_USERS

This table lists all the users who have sent in an event in the past. For each user, the columns contain a variety of useful metrics.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`USER_ID`	`TEXT`
`BIRTH_YEAR`	`NUMBER`
`LAST_SESSION_ID`	`TEXT`
`LAST_EVENT_TIMESTAMP`	`TIMESTAMP`
`LAST_PLATFORM`	`TEXT`
`COUNTRY`	`TEXT`
`GENDER`	`TEXT`
`START_DATE`	`DATE`
`ACQUISITION_CHANNEL`	`TEXT`
`LAST_LOCALE`	`TEXT`

ACCOUNT_FACT_EVENT_TYPE_USERS_DAY

This table lists all of the events a user has recorded in one day and how many times they have sent in each of those events.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`EVENT_NAME`	`TEXT`
`NUMBER_OF_EVENTS`	`NUMBER`
`INSERTED_TIMESTAMP`	`TIMESTAMP`

ACCOUNT_FACT_WAU_USERS

This table lists all of the users that have sent in an event in the last week.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

ACCOUNT_FACT_MAU_USERS

This table lists all of the users that have sent in an event in the last 30 days.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

ACCOUNT_FACT_MISSION_USERS_DAY

This counts how often a user has started, completed, failed and abandoned missions.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`MISSION_NAME`	`TEXT`
`MISSIONS_STARTED`	`NUMBER`
`MISSIONS_COMPLETED`	`NUMBER`
`MISSIONS_FAILED`	`NUMBER`
`MISSIONS_ABANDONED`	`NUMBER`
`INSERTED_TIMESTAMP`	`TIMESTAMP`

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY

This table contains data on Users retained after installing in the last 7 days.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY

This table contains data on Users retained after installing in the last 14 days.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

`ACCOUNT_FACT_PRODUCT_USERS_DAY

This table contains the number of products bought split out by the standard filter parameters. The data comes from the

productsReceived

object in the

transaction

event.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`PRODUCT_CATEGORY`	`TEXT`

ACCOUNT_FACT_RETAINED_USERS_7_DAY

This table contains data on users retained after installing in the last 7 days.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

ACCOUNT_FACT_RETAINED_USERS_14_DAY

This table contains data on users retained after installing in the last 14 days.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`

ACCOUNT_FACT_USER_SESSIONS_DAY

This table has a record for each user session. Each record contains a variety of user level aggregate KPIs for that session. If any of the dimensions in this table, excluding aggregate dimensions, change during a session (for example,

AGE_GROUP

GENDER

), a new record will be created for that session.

Column Name	Type
`ACCOUNT_NAME`	`TEXT`
`GAME_NAME`	`TEXT`
`GAME_ID`	`NUMBER`
`ENVIRONMENT_NAME`	`TEXT`
`ENVIRONMENT_ID`	`NUMBER`
`EVENT_DATE`	`DATE`
`USER_ID`	`TEXT`
`AGE_GROUP`	`TEXT`
`GENDER`	`TEXT`
`USER_COUNTRY`	`TEXT`
`ACQUISITION_CHANNEL`	`TEXT`
`PLAYER_START_DATE`	`DATE`
`PLATFORM`	`TEXT`
`CLIENT_VERSION`	`TEXT`
`SESSION_ID`	`TEXT`

Data Access available views

ACCOUNT_EVENTS

Column Name

Type

ACCOUNT_EVENT_JSON_KEYS

Column Name

Type

ACCOUNT_GAMES

Column Name

Type

ACCOUNT_USERS

Column Name

Type

ACCOUNT_FACT_EVENT_TYPE_USERS_DAY

Column Name

Type

ACCOUNT_FACT_WAU_USERS

Column Name

Type

ACCOUNT_FACT_MAU_USERS

Column Name

Type

ACCOUNT_FACT_MISSION_USERS_DAY

Column Name

Type

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY

Column Name

Type

ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY

Column Name

Type

`ACCOUNT_FACT_PRODUCT_USERS_DAY

Column Name

Type

ACCOUNT_FACT_RETAINED_USERS_7_DAY

Column Name

Type

ACCOUNT_FACT_RETAINED_USERS_14_DAY

Column Name

Type

ACCOUNT_FACT_USER_SESSIONS_DAY

Column Name

Type

`ACCOUNT_EVENTS`

`ACCOUNT_EVENT_JSON_KEYS`

`ACCOUNT_GAMES`

`ACCOUNT_USERS`

`ACCOUNT_FACT_EVENT_TYPE_USERS_DAY`

`ACCOUNT_FACT_WAU_USERS`

`ACCOUNT_FACT_MAU_USERS`

`ACCOUNT_FACT_MISSION_USERS_DAY`

`ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_7_DAY`

`ACCOUNT_FACT_POTENTIAL_RETAINED_USERS_14_DAY`

`ACCOUNT_FACT_RETAINED_USERS_7_DAY`

`ACCOUNT_FACT_RETAINED_USERS_14_DAY`

`ACCOUNT_FACT_USER_SESSIONS_DAY`