Data Model:
...
Dimension in Druid
...
Field in Telemetry
...
Description
...
Data Type
...
eid
...
eid
...
Event Id
...
String
...
syncts
...
syncts
...
Sync Timestamp
...
Long
...
actor_id
...
actor.id
...
Actor Id of the event
...
String
...
actor_type
...
actor.type
...
Type of the actor
...
String
...
context_channel
...
context.channel
...
Channel Id
...
String
...
context_pdata_id
...
context.pdata.id
...
Producer Id
...
String
...
context_pdata_pid
...
context.pdata.pid
...
Producer Process Id
...
String
...
context_env
...
context.env
...
Context Environment
...
String
...
context_sid
...
context.sid
...
Session Id
...
String
...
context_did
...
context.did
...
Device Id
...
String
...
context_cdata_type
...
context.cdata.type
...
Correlation Data Type
...
Array[String]
...
context_cdata_id
...
context.cdata.id
...
Correlation Data Id
...
Array[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[String]
...
edata_type
...
edata.type
...
Event type
...
String
...
edata_subtype
...
edata.subtype
...
Event subtype
...
String
...
edata_mode
...
edata.mode
...
START event Mode of start
...
String
...
edata_pageid
...
edata.pageid
...
Unique pageid
...
String
...
edata_uri
...
edata.uri
...
IMPRESSION event Relative URI of the content
...
String
...
edata_id
...
edata.id
...
Event data Id
...
String
...
edata_duration
...
edata.duration
...
Duration of the event
...
Double
...
edata_index
...
edata.index
...
ASSESS event Index of the question within a content
...
Integer
...
edata_pass
...
edata.pass
...
ASSESS event Field to identify pass or fail for assessments
...
String
...
edata_score
...
edata.score
...
ASSESS event Assessment score
...
Double
...
edata_resvalues
...
edata.resvalues
...
ASSESS event Assessment results
...
Array[Object]
...
edata_item_id
...
edata.item.id
...
ASSESS event Assessment item id
...
String
...
edata_item_title
...
edata.item.title
...
ASSESS event Assessment item title
...
String
...
edata_item_maxscore
...
edata.item.maxscore
...
ASSESS event Assessment item max score
...
Double
...
edata_target_id
...
edata.target.id
...
ASSESS event Assessment item target id
...
String
...
edata_target_type
...
edata.target.type
...
ASSESS event Assessment item target type
...
String
...
edata_rating
...
edata.rating
...
FEEDBACK event Ratings
...
Integer
...
edata_comments
...
edata.comments
...
FEEDBACK event Comments
...
String
...
edata_dir
...
edata.dir
...
SHARE event direction
...
String
...
edata_items_id
...
edata.items.id
...
SHARE event shared item ids
...
Array[String]
...
edata_items_type
...
edata.items.type
...
SHAREÂ item types
...
Array[String]
...
edata_items_origin_id
...
edata.items.origin.id
...
SHAREÂ event source id
...
Array[String]
...
edata_items_origin_type
...
edata.items.origin.type
...
SHAREÂ event source type
...
Array[String]
...
edata_items_to_id
...
edata.items.to.id
...
SHAREÂ event destination id
...
Array[String]
...
edata_items_to_type
...
edata.items.to.type
...
SHARE event destination type
...
Array[String]
...
edata_state
...
edata.state
...
AUDIT event current state
...
String
...
edata_prevstate
...
edata.prevstate
...
AUDITÂ event previous state
...
String
...
edata_size
...
edata.size
...
SEARCH event result size
...
Integer
...
edata_filters_dialcodes
...
edata.filters.dialcodes
...
SEARCH event List of dialcodes
...
Array[String]
...
device_loc_state
...
devicedata.state
...
State location information for the device
...
String
...
device_loc_state_code
...
devicedata.statecode
...
State ISO code information for the device
...
String
...
device_loc_iso_state_code
...
device_loc_city
...
devicedata.city
...
City location information for the device
...
String
...
device_loc_country_code
...
devicedata.countrycode
...
Country ISO code information for the device
...
String
...
device_loc_country
...
devicedata.country
...
Country location information for the device
...
String
...
Data Model:
Dimension in Druid | Field in Telemetry | Description | Data Type | |
|---|---|---|---|---|
| 1 | ets | ets | Event timestamp | Long |
| 2 | eid | eid | Event Id | String |
| 3 | syncts | syncts | Sync Timestamp | Long |
| 4 | @timstamp | @timstamp | Sync Timestamp in String | String |
| 5 | actor_id | actor.id | Actor Id of the event | String |
| 6 | actor_type | actor.type | Type of the actor | String |
| 7 | context_channel | context.channel | Channel Id | String |
| 8 | context_pdata_id | context.pdata.id | Producer Id | String |
| 9 | context_pdata_pid | context.pdata.pid | Producer Process Id | String |
| 10 | context_pdata_ver | context.pdata.ver | Producer version number | String |
| 11 | context_env | context.env | Context Environment | String |
| 12 | context_sid | context.sid | Session Id | String |
| 13 | context_did | context.did | Device Id | String |
| 14 | context_cdata_type | context.cdata.type | Correlation Data Type | Array[String] |
| 15 | context_cdata_id | context.cdata.id | Correlation Data Id | Array[String] |
| 16 | context_rollup_l1 | context.rollup.l1 | Context level 1Â rollup | String |
| 17 | context_rollup_l2 | context.rollup.l2 | Context level 2Â rollup | String |
| 18 | context_rollup_l3 | context.rollup.l3 | Context level 3Â rollup | String |
| 19 | context_rollup_l4 | context.rollup.l4 | Context level 4Â rollup | String |
| 20 | object_id | object.id | Content Id | String |
| 21 | object_type | object.type | Content Type | String |
| 22 | object_version | object.ver | Content Version | String |
| 23 | object_rollup_l1 | object.rollup.l1 | Content level 1Â rollup | String |
| 24 | object_rollup_l2 | object.rollup.l2 | Content level 2Â rollup | String |
| 25 | object_rollup_l3 | object.rollup.l3 | Content level 3Â rollup | String |
| 26 | object_rollup_l4 | object.rollup.l4 | Content level 4Â rollup | String |
| 27 | tags | tags | Tags | Array[String] |
| 28 | edata_type | edata.type | Event type | String |
| 29 | edata_subtype | edata.subtype | Event subtype | String |
| 30 | edata_mode | edata.mode | START event Mode of start | String |
| 31 | edata_pageid | edata.pageid | Unique pageid | String |
| 32 | edata_uri | edata.uri | IMPRESSION event Relative URI of the content | String |
| 33 | edata_id | edata.id | Event data Id | String |
| 34 | edata_duration | edata.duration | Duration of the event | Double |
| 35 | edata_index | edata.index | ASSESS event Index of the question within a content | Integer |
| 36 | edata_pass | edata.pass | ASSESS event Field to identify pass or fail for assessments | String |
| 37 | edata_score | edata.score | ASSESS event Assessment score | Double |
| 38 | edata_resvalues | edata.resvalues | ASSESS event Assessment results | Array[Object] |
| 39 | edata_item_id | edata.item.id | ASSESS event Assessment item id | String |
| 40 | edata_item_title | edata.item.title | ASSESS event Assessment item title | String |
| 41 | edata_item_maxscore | edata.item.maxscore | ASSESS event Assessment item max score | Double |
| 42 | edata_target_id | edata.target.id | ASSESS event Assessment item target id | String |
| 43 | edata_target_type | edata.target.type | ASSESS event Assessment item target type | String |
| 44 | edata_rating | edata.rating | FEEDBACK event Ratings | Integer |
| 45 | edata_comments | edata.comments | FEEDBACK event Comments | String |
| 46 | edata_dir | edata.dir | SHARE event direction | String |
| 47 | edata_items_id | edata.items.id | SHARE event shared item ids | Array[String] |
| 48 | edata_items_type | edata.items.type | SHAREÂ item types | Array[String] |
| 49 | edata_items_origin_id | edata.items.origin.id | SHAREÂ event source id | Array[String] |
| 50 | edata_items_origin_type | edata.items.origin.type | SHAREÂ event source type | Array[String] |
| 51 | edata_items_to_id | edata.items.to.id | SHAREÂ event destination id | Array[String] |
| 52 | edata_items_to_type | edata.items.to.type | SHARE event destination type | Array[String] |
| 53 | edata_plugin_id | edata.plugin.id | INTERACT event plugin id on which the interaction has happened | String |
| 54 | edata_plugin_ver | edata.plugin.ver | INTERACTÂ event plugin version | String |
| 55 | edata_plugin_category | edata.plugin.category | INTERACTÂ event plugin category | String |
| 56 | edata_props | edata.props | AUDIT event updated properties | Array[String] |
| 57 | edata_state | edata.state | AUDIT event current state | String |
| 58 | edata_prevstate | edata.prevstate | AUDITÂ event previous state | String |
| 59 | edata_size | edata.size | SEARCH event result size | Integer |
| 60 | edata_filters_dialcodes | edata.filters.dialcodes | SEARCH event List of dialcodes | Array[String] |
| 61 | edata_topn_identifier | edata.topn.identifier | SEARCH event topn results | Array[String] |
| 62 | edata_visits_objid | edata.visits.objid | IMPRESSION event unique id for object visited | Array[String] |
| 63 | edata_visits_objtype | edata.visits.objtype | IMPRESSION event type of object visited | Array[String] |
| 64 | edata_visits_objver | edata.visits.objver | IMPRESSION event version of object visited | Array[String] |
| 65 | edata_visits_index | edata.visits.index | IMPRESSION event index of object within list | Array[Integer] |
| 66 | device_loc_state | devicedata.state | State location information for the device | String |
| 67 | device_loc_state_code | devicedata.statecode | State ISO code information for the device | String |
| 68 | device_loc_iso_state_code | devicedata.iso3166statecode | State ISO-3166 code information for the device | String |
| 69 | device_loc_city | devicedata.city | City location information for the device | String |
| 70 | device_loc_country_code | devicedata.countrycode | Country ISO code information for the device | String |
| 71 | device_loc_country | devicedata.country | Country location information for the device | String |
| 72 | device_loc_state_custom_code | devicedata.statecustomcode | State custom code information for the device | String |
| 73 | device_loc_state_custom_name | devicedata.statecustomname | State custom name information for the device | String |
| 74 | device_loc_district | devicedata.districtcustom | District custom information for the device | String |
| 75 | user_declared_state | devicedata.userdeclared.state | State declared by the user | String |
| 76 | user_declared_district | devicedata.userdeclared.district | District declared by the user | String |
| 77 | device_os | devicedata.devicespec.os | Device OS name | String |
| 78 | device_make | devicedata.devicespec.make | Device make and model | String |
| 79 | device_id | devicedata.devicespec.id | Physical device id if available from OS | String |
| 80 | device_mem | devicedata.devicespec.mem | Total memory in mb | Integer |
| 81 | device_idisk | devicedata.devicespec.idisk | Total interanl disk | Integer |
| 82 | device_edisk | devicedata.devicespec.edisk | Total external disk | Integer |
| 83 | device_scrn | devicedata.devicespec.scrn | Screen size in inches | Integer |
| 84 | device_camera | devicedata.devicespec.camera | Primary & secondary camera spec | String |
| 85 | device_cpu | devicedata.devicespec.cpu | Processor name | String |
| 86 | device_sims | devicedata.devicespec.sims | Number of sim cards | Integer |
| 87 | device_uaspec_agent | devicedata.uaspec.agent | User agent of the browser | String |
| 88 | device_uaspec_ver | devicedata.uaspec.ver | User agent version of the browser | String |
| 89 | device_uaspec_system | devicedata.uaspec.system | User agent system identification of the browser | String |
| 90 | device_uaspec_platform | devicedata.uaspec.platform | User agent client platform of the browser | String |
| 91 | device_uaspec_raw | devicedata.uaspec.raw | Raw user agent of the browser | String |
| 92 | device_first_access | devicedata.firstaccess | First access of the device | Long (Epoch) |
| 93 | content_name | contentdata.name | Name of the content | String |
| 94 | content_object_type | contentdata.objecttype | Type of the content | String |
| 95 | content_type | contentdata.contenttype | Type of the resource | String |
| 96 | content_media_type | contentdata.mediatype | Type of the media of the resource | String |
| 97 | content_language | contentdata.language | List of languages in the content | Array[String] |
| 98 | content_medium | contentdata.medium | Language medium of the board | Array[String] |
| 99 | content_gradelevel | contentdata.gradelevel | List of grade levels in the content | Array[String] |
| 100 | content_subjects | contentdata.subject | List of subjects in the content | Array[String] |
| 101 | content_mimetype | contentdata.mimetype | Mimetype of the resource in the content | String |
| 102 | content_created_by | contentdata.createdby | Content created by | String |
| 103 | content_created_for | contentdata.createdfor | List of orgs for whom the content is created | Array[String] |
| 104 | content_framework | contentdata.framework | String | |
| 105 | content_board | contentdata.board | Board of affiliation | String |
| 106 | content_status | contentdata.status | Status of the content - Draft, Published etc. | String |
| 107 | content_version | contentdata.pkgversion | Version of the content | Double |
| 108 | content_last_submitted_on | contentdata.lastsubmittedon | Last submitted date of the content | Long (Epoch) |
| 109 | content_last_published_on | contentdata.lastpublishedon | Last published date of the content | Long (Epoch) |
| 110 | content_last_updated_on | contentdata.lastupdatedon | Last updated date of the content | Long (Epoch) |
| 111 | user_grade_list | userdata.gradelist | List of grades taught | Array[String] |
| 112 | user_language_list | userdata.languagelist | List of languages known | Array[String] |
| 113 | user_subject_list | userdata.subjectlist | List of subjects taught | Array[String] |
| 114 | user_type | userdata.type | Type of user | String |
| 115 | user_loc_state | userdata.state | State info of the user | String |
| 116 | user_loc_district | userdata.district | District info of the user | String |
| 117 | user_loc_block | userdata.block | Block info of the user | String |
| 118 | user_roles | userdata.roles | List of user roles | Array[String] |
| 119 | user_signin_type | userdata.usersignintype | User sign-in type info | String |
| 120 | user_login_type | userdata.userlogintype | User login type info | String |
| 121 | dialcode_channel | dialcodedata.channel | Channel for which dialcode is generated | String |
| 122 | dialcode_batchcode | dialcodedata.batchcode | Batch for which dialcode belongs to | String |
| 123 | dialcode_publisher | dialcodedata.publisher | Publisher of the dialcode | String |
| 124 | dialcode_generated_on | dialcodedata.generatedon | Dialcode generated on | Long (Epoch) |
| 125 | dialcode_published_on | dialcodedata.publishedon | Dialcode published on | Long (Epoch) |
| 126 | dialcode_status | dialcodedata.status | Status of the dialcode | String |
| 127 | dialcode_object_type | dialcodedata.objecttype | Object type - DialCode as a value | String |
| 128 | collection_name | collectiondata.name | Name of the collection (Denormalised for object.rollup.l1 field) | String |
| 129 | collection_object_type | collectiondata.objecttype | Type of the collection | String |
| 130 | collection_type | collectiondata.contenttype | Type of the resource | String |
| 131 | collection_media_type | collectiondata.mediatype | Type of the media of resource | String |
| 132 | collection_language | collectiondata.language | List of languages in the collection | Array[String] |
| 133 | collection_medium | collectiondata.medium | Language medium of the board | Array[String] |
| 134 | collection_gradelevel | collectiondata.gradelevel | List of grade levels in the collection | Array[String] |
| 135 | collection_subjects | collectiondata.subjects | List of subjects in the collection | Array[String] |
| 136 | collection_mimetype | collectiondata.mimetype | Mimetype of the resource in the collection | String |
| 137 | collection_created_by | collectiondata.createdby | Resourse created By | String |
| 138 | collection_created_for | collectiondata.createdfor | List of orgs for whom the resource is created | Array[String] |
| 139 | collection_framework | collectiondata.framework | String | |
| 140 | collection_board | collectiondata.board | Board of affiliation | String |
| 141 | collection_status | collectiondata.status | Status of the collection - Draft, Published etc. | String |
| 142 | collection_version | collectiondata.pkgversion | Version of the collection | Double |
| 143 | collection_last_published_on | collectiondata.lastpublishedon | Last published date of the collection | Long(Epoch) |
| 144 | collection_last_updated_on | collectiondata.lastupdatedon | Last updated date of the collection | Long(Epoch) |
| 145 | collection_last_submitted_on | collectiondata.lastsubmittedon | Last submitted date of the collection | Long(Epoch) |
| 146 | derived_loc_state | derivedlocationdata.state | Derived location state of the user | String |
| 147 | derived_loc_district | derivedlocationdata.district | Derived location district of the user | String |
| 148 | derived_loc_from | derivedlocationdata.from | Derived location | String |
| 149 | user_declared_state | userdeclared.state | User Declared State | String |
| 150 | user_declared_district | userdeclared.district | User Declared District | String |