el_bolt_discovery_raw
el_bolt_discovery_raw Columns#
JSON Keys for Bolt Discovery Object#
Sample JSON Object for Bolt Discovery#
Bolt Discovery
{
"__v": 0,
"_id": "674fd199b6034f059a2751a1",
"_subdom": "instance",
"created_at": "2026-05-04T03:50:49.500000",
"guid": "instance.search_threads.9164",
"location": {
"timezone": "America/New_York",
"url": "https://www.instance.edu/students/",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36 Edg/129.0.0.0"
},
"messages": [
{
"answer": "If you are looking for information about obtaining or using your student ID at Example Community College, I recommend contacting the college's admissions or registrar's office directly.",
"content": [],
"created_at": "2026-05-04T03:50:49.500000",
"follow_ups": [
"How do I obtain my student ID?",
"What should I do if I lost my student ID?",
"Can I use my student ID for discounts?"
],
"images": [],
"lead_gen_follow_up": {
"question": null
},
"location": {
"timezone": "America/New_York",
"url": "https://www.instance.edu/students/",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36 Edg/129.0.0.0"
},
"queries": [],
"updated_at": "2026-05-04T03:50:49.500000",
"user_query": "student id",
"uuid": "5HYSsKMbJvVP3o4vaY",
"videos": []
},
{
"answer": "Here are the steps to obtain your student ID at Example Community College: 1. Submit Your Photo. 2. Photo Approval. 3. Pick Up Your ID Card at the Student Success Center.",
"content": [
{
"articleGuid": "instance.conversation_settings.13231",
"content": "How I can obtain a Student ID card (student ID)?",
"namespace": null,
"sequenceNumber": 0,
"subdom": "instance",
"title": "ID Card",
"type": "text",
"updatedAt": "2025-09-28T00:39:48.344Z",
"url": null
}
],
"created_at": "2024-12-04T03:50:56.385000",
"follow_ups": [
"Where can I pick up my student ID?",
"What documents do I need to bring to get my student ID?",
"Can I submit my photo online?"
],
"handoff_button": "How can I get help with obtaining my student ID?",
"images": [],
"lead_gen_follow_up": {
"question": null
},
"location": {
"timezone": "America/New_York",
"url": "https://www.instance.edu/students/student-life/student-resources/",
"user_agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36 Edg/129.0.0.0"
},
"queries": [
"how to obtain student ID at Example Community College"
],
"updated_at": "2024-12-04T03:50:56.385000",
"user_query": "How do I obtain my student ID?",
"uuid": "qFGggX83W9gepxHJe2",
"videos": []
}
],
"shared": false,
"slug": "student-id-dHnqdSoPsyEwWQatreF2kk",
"title": "student id",
"updated_at": "2024-12-04T04:30:20.081000",
"user": {
"anonymous_guid": "674fd1522cab27a40b08",
"is_anonymous": true,
"is_internal": false,
"user_id": "674fd199bf059a2751a0"
}
}el_bolt_discovery_raw Columns
6 rows
| Column | SQL Data Type | Description |
|---|---|---|
| etl_loaded_at | TIMESTAMP_NTZ | Document loaded to Snowflake timestamp |
| src | VARIANT | JSON object of bolt discovery document properties. |
| created_at | TIMESTAMP_NTZ | Document created timestamp |
| updated_at | TIMESTAMP_NTZ | Document update timestamp |
| subdom | VARCHAR | Partner school instance identifier |
| _id | VARCHAR | Unique identifier for each discovery thread. |
JSON Keys for Bolt Discovery Object
128 rows
| Description | Data Type | Key |
|---|---|---|
| Width in pixels of the default thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.default.width |
| Canonical URL meta tag from the page. | STRING | location.meta.canonical |
| Whether the user submitted a lead generation form in this thread. | BOOLEAN | lead_gen_submitted |
| Twitter card description when the message was sent. | STRING | messages[].location.meta.twitter:description |
| Client instance subdomain embedded in the source document. | STRING | _subdom |
| Open Graph title meta tag from the page. | STRING | location.meta.og:title |
| Title of the cited knowledge article or content chunk. | STRING | messages[].content[].title |
| Medium-resolution YouTube thumbnail object. | OBJECT | messages[].videos[].snippet.thumbnails.medium |
| Browser screen size when the thread was started. | STRING | location.screen_size |
| Twitter card title meta tag from the page. | STRING | location.meta.twitter:title |
| YouTube or video results returned with the AI answer. | ARRAY | messages[].videos |
| Title of a returned video result. | STRING | messages[].videos[].title |
| Meta description from the page. | STRING | location.meta.description |
| Message text from the cited knowledge content. | STRING | messages[].content[].message |
| YouTube channel ID for the video. | STRING | messages[].videos[].snippet.channelId |
| Unique identifier for the message within the thread. | STRING | messages[].uuid |
| Watch URL for a returned video. | STRING | messages[].videos[].url |
| Alternate or rewritten query strings used for retrieval. | ARRAY | messages[].queries |
| User timezone when the thread was started. | STRING | location.timezone |
| Whether the thread user is anonymous. | BOOLEAN | user.is_anonymous |
| Vector search namespace for the source citation. | NULL | messages[].sources[].namespace |
| Height in pixels of the medium thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.medium.height |
| Images returned or referenced in the AI answer. | ARRAY | messages[].images |
| Lead generation follow-up prompt shown after the answer. | OBJECT | messages[].lead_gen_follow_up |
| GUID of the RSS feed source for cited content. | NULL | messages[].content[].rssFeedGuid |
| AI-generated answer text for the message. | STRING | messages[].answer |
| Twitter card title when the message was sent. | STRING | messages[].location.meta.twitter:title |
| Width in pixels of the high-resolution thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.high.width |
| Page URL when the message was sent. | STRING | messages[].location.url |
| User or anonymous visitor associated with the thread. | OBJECT | user |
| URL of the high-resolution YouTube thumbnail. | STRING | messages[].videos[].snippet.thumbnails.high.url |
| URL of the default-size YouTube thumbnail. | STRING | messages[].videos[].snippet.thumbnails.default.url |
| Timestamp when the discovery thread was created in Element451. | STRING | created_at |
| Suggested follow-up questions generated after the answer. | ARRAY | messages[].follow_ups |
| Page context where the discovery thread was started. | OBJECT | location |
| Open Graph URL when the message was sent. | STRING | messages[].location.meta.og:url |
| YouTube video ID. | STRING | messages[].videos[].id.videoId |
| Meta keywords from the page. | STRING | location.meta.keywords |
| Timestamp of the last update to the thread. | STRING | updated_at |
| Timestamp when the source content was last updated. | STRING | messages[].sources[].updatedAt |
| Timestamp when the handoff request was submitted. | STRING | messages[].handoff_submitted_at |
| Width in pixels of the medium thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.medium.width |
| Body text of the cited knowledge article or chunk. | STRING | messages[].content[].content |
| Page title where the discovery thread was started. | STRING | location.title |
| YouTube video identifier object. | OBJECT | messages[].videos[].id |
| Canonical URL meta tag when the message was sent. | STRING | messages[].location.meta.canonical |
| Array of user queries and AI responses in the thread. | ARRAY | messages |
| Type of source citation (article, web page, etc.). | STRING | messages[].sources[].type |
| Display order number for the source citation. | INTEGER | messages[].sources[].citationNumber |
| Height in pixels of the high-resolution thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.high.height |
| User timezone when the message was sent. | STRING | messages[].location.timezone |
| YouTube API resource kind for the video result. | STRING | messages[].videos[].kind |
| Whether the user submitted the lead generation follow-up. | BOOLEAN | messages[].lead_gen_submitted |
| YouTube resource kind for the video identifier. | STRING | messages[].videos[].id.kind |
| Open Graph URL meta tag from the page. | STRING | location.meta.og:url |
| File name for file-based knowledge content. | STRING | messages[].content[].fileName |
| Content moderation flags on the cited knowledge chunk. | ARRAY | messages[].content[].moderation_flags |
| Title of the source citation. | STRING | messages[].sources[].title |
| GUID assigned to an anonymous visitor in the thread. | STRING | user.anonymous_guid |
| YouTube thumbnail images for the video. | OBJECT | messages[].videos[].snippet.thumbnails |
| Timestamp when the cited knowledge content was created. | STRING | messages[].content[].createdAt |
| Ordering sequence number for the cited content chunk. | INTEGER | messages[].content[].sequenceNumber |
| Identifier for the cited knowledge content chunk. | STRING | messages[].content[].id |
| Open Graph type when the message was sent. | STRING | messages[].location.meta.og:type |
| Scheduled publish time for the YouTube video. | STRING | messages[].videos[].snippet.publishTime |
| Thumbnail URL for a returned video. | STRING | messages[].videos[].thumbnail |
| Meta keywords when the message was sent. | STRING | messages[].location.meta.keywords |
| Page context where this individual message was sent. | OBJECT | messages[].location |
| Timestamp when the cited knowledge content was last updated. | STRING | messages[].content[].updatedAt |
| Default-size YouTube thumbnail object. | OBJECT | messages[].videos[].snippet.thumbnails.default |
| Publication timestamp for the YouTube video. | STRING | messages[].videos[].snippet.publishedAt |
| Whether the discovery thread has been shared. | BOOLEAN | shared |
| YouTube video snippet metadata object. | OBJECT | messages[].videos[].snippet |
| Browser user agent when the message was sent. | STRING | messages[].location.user_agent |
| Knowledge base articles or content chunks cited in the answer. | ARRAY | messages[].content |
| GUID of a prior thread this conversation was branched from. | STRING | conversation_started_from_thread_guid |
| Content moderation flags raised for the thread. | ARRAY | moderation_flags |
| Vector search namespace for the cited knowledge chunk. | NULL | messages[].content[].namespace |
| High-resolution YouTube thumbnail object. | OBJECT | messages[].videos[].snippet.thumbnails.high |
| Timestamp when the lead generation follow-up was submitted. | STRING | messages[].lead_gen_submitted_at |
| Browser user agent string when the thread was started. | STRING | location.user_agent |
| GUID of a knowledge article listed as a source citation. | STRING | messages[].sources[].articleGuid |
| YouTube video title from the snippet. | STRING | messages[].videos[].snippet.title |
| Client subdomain for the cited knowledge content. | STRING | messages[].content[].subdom |
| Embed URL for a returned video. | STRING | messages[].videos[].embedUrl |
| Browser screen size when the message was sent. | STRING | messages[].location.screen_size |
| Page title when the message was sent. | STRING | messages[].location.title |
| Element451 person identifier for the thread user. | STRING | user.user_id |
| Current state of the Bolt Discovery chatbot session. | STRING | chatbot_state |
| Open Graph content type meta tag from the page. | STRING | location.meta.og:type |
| GUID of a knowledge base article cited in the answer. | STRING | messages[].content[].articleGuid |
| Timestamp when the message was last updated. | STRING | messages[].updated_at |
| Live broadcast status for the YouTube video. | STRING | messages[].videos[].snippet.liveBroadcastContent |
| Categories assigned to the cited knowledge article. | ARRAY | messages[].content[].categories |
| URL of the medium-resolution YouTube thumbnail. | STRING | messages[].videos[].snippet.thumbnails.medium.url |
| Explanation for content moderation actions on the thread. | STRING | moderation_reasoning |
| Whether the user submitted a live support handoff request. | BOOLEAN | messages[].handoff_submitted |
| Client subdomain for the source citation. | STRING | messages[].sources[].subdom |
| User rating or feedback on the AI answer. | STRING | messages[].rate |
| URL slug for the discovery thread. | STRING | slug |
| Page heading when the message was sent. | STRING | messages[].location.heading |
| Meta description when the message was sent. | STRING | messages[].location.meta.description |
| URL of the page where the discovery thread was started. | STRING | location.url |
| Twitter card description meta tag from the page. | STRING | location.meta.twitter:description |
| HTML meta tags from the page where the thread started. | OBJECT | location.meta |
| Open Graph description meta tag from the page. | STRING | location.meta.og:description |
| Open Graph description when the message was sent. | STRING | messages[].location.meta.og:description |
| HTML meta tags from the page when the message was sent. | OBJECT | messages[].location.meta |
| Height in pixels of the default thumbnail. | INTEGER | messages[].videos[].snippet.thumbnails.default.height |
| YouTube video description from the snippet. | STRING | messages[].videos[].snippet.description |
| Whether the cited knowledge content is private. | BOOLEAN | messages[].content[].private |
| Open Graph title when the message was sent. | STRING | messages[].location.meta.og:title |
| YouTube channel title for the video. | STRING | messages[].videos[].snippet.channelTitle |
| MongoDB document identifier for the discovery thread. | STRING | _id |
| Excerpt text shown for the source citation. | STRING | messages[].sources[].content |
| Whether the thread was blocked by content moderation. | BOOLEAN | moderation_block |
| YouTube channel name for a returned video. | STRING | messages[].videos[].channel |
| Unique GUID for the discovery thread. | STRING | guid |
| Ordering sequence number for the source citation. | INTEGER | messages[].sources[].sequenceNumber |
| URL of the source citation. | STRING | messages[].sources[].url |
| Page heading visible when the thread was started. | STRING | location.heading |
| Description text for a returned video. | STRING | messages[].videos[].description |
| YouTube API etag for a returned video. | STRING | messages[].videos[].etag |
| Timestamp when the message was created. | STRING | messages[].created_at |
| Display title for the discovery thread. | STRING | title |
| Natural language question submitted by the user. | STRING | messages[].user_query |
| Source citations displayed with the AI answer. | ARRAY | messages[].sources |
| Whether the thread user is an internal Element451 user. | BOOLEAN | user.is_internal |
Was this page helpful?