Menu
Amazon Mobile Analytics
User Guide

Amazon Redshift Schema for Event Data

A new schema called AWSMA is created to contain the tables and views to access the data. To access events, use the AWSMA.v_event view. You can sign in to your Amazon Redshift cluster using the eventreader user and the password configured in the auto export feature. This user will have full select access to the AWSMA.v_event view.

The following table describes schema for the AWSMA.v_event view. Custom attributes and custom metric columns appear at the end.

JSON Amazon Redshift Schema for Event Data

Column Name Data Type Description
event_type varchar(256) The name that was specified when the event was recorded in the SDK or the name of a system event that was recorded by the SDK (for example, _session.start, _session.stop).
event_timestamp timestamp The UTC timestamp (of the device) when the event occurred.
arrival_timestamp timestamp The UTC timestamp (of the server) when the event was received by the AWS server.
event_version char(12) The version of the event structure (typically 3.0).
application_app_id varchar(64) The ID used to identify the app.
application_package_name varchar(256) The package name of the app.
application_version_name varchar(256) The version name associated with the app.
application_version_code varchar(256) The version code associated with the app.
application_title varchar(256) The title of the app.
application_cognito_identity_pool_id varchar(64) This is populated if you are using Amazon Cognito authentication. It is the Amazon Cognito identity pool ID.
application_sdk_name varchar(256) The AWS SDK that sent the event.
application_sdk_version varchar(256) The version of the AWS SDK that sent the event.
client_id varchar(64) An ID used to identify other events sent from the same app instance. If you used the AWS Mobile SDK to record events, all events from the same app on a device will have the same client_id. This is a GUID string. You can use this value to sample events from a random set of users.
client_cognito_id varchar(64) The Amazon Cognito client ID, this column is populated if you are using Amazon Cognito authentication. This is useful to correlate different users if you are using non-anonymous users.
device_model varchar(256) The device model.
device_make varchar(256) The device make.
device_platform_name varchar(256) The device platform (for example, iPhoneOS or Android).
device_platform_version varchar(256) The device platform version.
device_locale_code varchar(256) The locale of the device (for example, en_US).
device_locale_language varchar(64) The language part of the locale (for example, "en").
device_locale_country varchar(64) The country part of the locale (for example, "US").
session_id varchar(64) A GUID string used to identify events that came from the same app and device in the same session.
session_start_timestamp timestamp The timestamp when the session started.
session_end_timestamp timestamp The timestamp when the session stopped. Populated for _session.stop events only.
monetization_transaction_id varchar(64) An identifier for the transaction.
monetization_transaction_store varchar(64) The name of the app store used for the transaction.
monetization_transaction_item_id varchar(64) An identifier for the item purchased.
monetization_transaction_quantity FLOAT8 The quantity of items purchased.
monetization_transaction_price_reported varchar(64) A string representation of the price reported by the purchasing library. This is different for each store.
monetization_transaction_price_amount FLOAT8 The numerical price value.
monetization_transaction_price_currency_code varchar(16) The currency code for the purchase.
monetization_transaction_price_currency_symbol varchar(32) The currency symbol for the purchase.
a_levelName varchar(4000) All custom attributes start with "a_".
a_playerClass varchar(4000) All custom attributes start with "a_".
m_score FLOAT8 All custom metrics start with "m_".
m_timeToCompleteMinutes FLOAT8 All custom metrics start with "m_".