Druid Architecture
Data layers in Sunbird Analytics
Telemetry data models for Druid
Telemetry Event Fields
Field in Druid | Field in Telemetry | Description | Data Type |
|---|---|---|---|
eid | eid | Event Id | String |
syncts | syncts | Sync Timestamp | Long |
@timestamp | @timestamp | String | |
user_id | actor.id | User Id of the event | String |
user_type | actor.type | Type of the user | String |
channel_id | context.channel | Channel Id | String |
producer_id | context.pdata.id | Producer Id | String |
producer_pid | context.pdata.pid | Producer Process Id | String |
context_env | context.env | Context Environment | String |
session_id | context.sid | Session Id | String |
device_id | context.did | Device Id | String |
context_correlation_data_type | context.cdata.type | Correlation Data Type | String |
context_correlation_data_id | context.cdata.id | Correlation Data Id | Array of String |
object_id | object.id | Content Id | String |
object_type | object.type | Content Type | String |
object_version | object.ver | Content Version | String |
tags | tags | Tags | Array of String |
edata_type | edata.type | Event data type | String |
edata_sub_type | edata.subtype | Event data subtype | String |
edata_mode | edata.mode | Event data mode | String |
edata_page_id | edata.pageid | Event data page id | String |
edata_uri | edata.uri | Event data uri | String |
edata_id | edata.id | Event data Id | String |
edata_duration | edata.duration | Event data duration | String |
edata_index | edata.index | Event data index | String |
edata_pass | edata.pass | Field to identify pass or fail for assessments | String |
edata_score | edata.score | Field to identify score for assessments | Double |
edata_result_values | edata.resvalues | Results for assessments | |
edata_item_id | edata.item.id | Assessment item id | String |
edata_item_title | edata.item.title | Assessment item title | String |
edata_item_max_score | edata.item.maxscore | Assessment item max score | Double |
edata_target_id | edata.target.id | Assessment item target id | String |
edata_target_type | edata.target.type | Assessment item target type | String |
edata_rating | edata.rating | Ratings from feedback event | String |
edata_comments | edata.comments | Comments from feedback event | String |
edata_dir | edata.dir | Direction specified in the Share event | String |
edata_items_id | edata.items.id | String | |
edata_items_type | edata.items.type | ||
edata_items_origin_id | edata.items.origin.id | ||
edata_items_origin_type | edata.items.origin.type | ||
edata_items_to_id | edata.items.to.id | ||
edata_items_to_type | edata.items.to.type | ||
edata_state | edata.state | ||
edata_prevstate | edata.prevstate | ||
edata_error | edata.error | ||
edata_error_type | edata.errtype | ||
edata_message | edata.message | ||
edata_level | edata.level | ||
edata_size | edata.size | ||
edata_filters_dialcodes | edata.filters.dialcodes | ||
location_state | ldata.state | State location information for the device | String |
location_state_code | ldata.state_code | State ISO code information for the device | String |
location_city | ldata.city | City location information for the device | String |
location_country_code | ldata.country_code | Country ISO code information for the device | String |
location_country | ldata.country | Country location information for the device | String |
Summary Events
Dimensions
- eid
- syncts (Druid Timestamp column)
- ver
- uid
- context_date_range_from
- context_date_range_to
- channel_id
- device_id
- producer_id
- producer_pid
- session_id
- summary_type
- sumamry_mode
- object_id
- object_type
- object_version
- time_spent
- time_difference
- interaction_count
- summary_env
- summary_env_count
- summary_env_time_spent
- summary_page_id
- summary_page_type
- summary_page_visit_count
- summary_page_time_spent
- item_responses_item_id
- item_responses_time_spent
- item_responses_pass
- item_responses_score
- item_responses_max_score
- item_responses_timestamp
- tags
Metrics
- total_interactions
- total_time_spent