SQL Data Explorer queryable tables reference
Explore the tables and columns you can query in SQL Data Explorer.
읽는 시간 3분최근 업데이트: 8달 전
Through the SQL Data Explorer you have access to a number of tables.
For examples of SQL queries that can be written to access data via these tables, see the SQL Data Explorer Cookbook.
EVENTS
EVENTSThis table lists all of the events that have been sent in from your application. Event-specific parameters can be found in the 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. Examples for parsing your parameters can be seen in the samples included in this repository. You can also retrieve the syntax to parse the parameters by typing in the parameter name and pressing TAB to auto-complete the syntax. This table is updated every 1-2 hours.
EVENT_JSONColumn Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
USERS
USERSThis 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. This table is updated every 3-4 hours.
Column Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
FACT_USER_SESSIONS_DAY
FACT_USER_SESSIONS_DAYThis 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 excluding aggregate dimensions, are recorded in this table change during a session (for example, or ), a new record will be created for that session. This table is updated every 1-2 hours.
AGE_GROUPGENDERColumn Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
FACT_EVENT_TYPE_USERS_DAY
FACT_EVENT_TYPE_USERS_DAYThis 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. This table is updated every 1-2 hours.
Column Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
FACT_WAU_USERS
FACT_WAU_USERSThis table lists all of the users that have sent in an event in the last seven days. This table is updated every 1-2 hours.
Column Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
FACT_MAU_USERS
FACT_MAU_USERSThis table lists all of the users that have sent in an event in the last 30 days. This table is updated every 1-2 hours.
Column Name | Type |
|---|---|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |