# Data Access available views

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

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

> **Note:**
>
> 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` or `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`   |