SQL Data Explorer queryable tables#

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#

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. 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.

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. This table is updated every 3-4 hours.

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 excluding aggregate dimensions, are recorded in this table change during a session (for example, AGE_GROUP or GENDER), a new record will be created for that session. This table is updated every 1-2 hours.

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. This table is updated every 1-2 hours.

FACT_WAU_USERS#

This 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.

FACT_MAU_USERS#

This 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.