Element451Integrations Guide

el_bolt_discovery_raw

Updated Article

el_bolt_discovery_raw Columns#

JSON Keys for Bolt Discovery Object#

Sample JSON Object for Bolt Discovery#

Bolt Discovery

json
{
  "__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
el_bolt_discovery_raw Columns
ColumnSQL Data TypeDescription
etl_loaded_atTIMESTAMP_NTZDocument loaded to Snowflake timestamp
srcVARIANTJSON object of bolt discovery document properties.
created_atTIMESTAMP_NTZDocument created timestamp
updated_atTIMESTAMP_NTZDocument update timestamp
subdomVARCHARPartner school instance identifier
_idVARCHARUnique identifier for each discovery thread.
JSON Keys for Bolt Discovery Object
128 rows
JSON Keys for Bolt Discovery Object
DescriptionData TypeKey
Width in pixels of the default thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.default.width
Canonical URL meta tag from the page.STRINGlocation.meta.canonical
Whether the user submitted a lead generation form in this thread.BOOLEANlead_gen_submitted
Twitter card description when the message was sent.STRINGmessages[].location.meta.twitter:description
Client instance subdomain embedded in the source document.STRING_subdom
Open Graph title meta tag from the page.STRINGlocation.meta.og:title
Title of the cited knowledge article or content chunk.STRINGmessages[].content[].title
Medium-resolution YouTube thumbnail object.OBJECTmessages[].videos[].snippet.thumbnails.medium
Browser screen size when the thread was started.STRINGlocation.screen_size
Twitter card title meta tag from the page.STRINGlocation.meta.twitter:title
YouTube or video results returned with the AI answer.ARRAYmessages[].videos
Title of a returned video result.STRINGmessages[].videos[].title
Meta description from the page.STRINGlocation.meta.description
Message text from the cited knowledge content.STRINGmessages[].content[].message
YouTube channel ID for the video.STRINGmessages[].videos[].snippet.channelId
Unique identifier for the message within the thread.STRINGmessages[].uuid
Watch URL for a returned video.STRINGmessages[].videos[].url
Alternate or rewritten query strings used for retrieval.ARRAYmessages[].queries
User timezone when the thread was started.STRINGlocation.timezone
Whether the thread user is anonymous.BOOLEANuser.is_anonymous
Vector search namespace for the source citation.NULLmessages[].sources[].namespace
Height in pixels of the medium thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.medium.height
Images returned or referenced in the AI answer.ARRAYmessages[].images
Lead generation follow-up prompt shown after the answer.OBJECTmessages[].lead_gen_follow_up
GUID of the RSS feed source for cited content.NULLmessages[].content[].rssFeedGuid
AI-generated answer text for the message.STRINGmessages[].answer
Twitter card title when the message was sent.STRINGmessages[].location.meta.twitter:title
Width in pixels of the high-resolution thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.high.width
Page URL when the message was sent.STRINGmessages[].location.url
User or anonymous visitor associated with the thread.OBJECTuser
URL of the high-resolution YouTube thumbnail.STRINGmessages[].videos[].snippet.thumbnails.high.url
URL of the default-size YouTube thumbnail.STRINGmessages[].videos[].snippet.thumbnails.default.url
Timestamp when the discovery thread was created in Element451.STRINGcreated_at
Suggested follow-up questions generated after the answer.ARRAYmessages[].follow_ups
Page context where the discovery thread was started.OBJECTlocation
Open Graph URL when the message was sent.STRINGmessages[].location.meta.og:url
YouTube video ID.STRINGmessages[].videos[].id.videoId
Meta keywords from the page.STRINGlocation.meta.keywords
Timestamp of the last update to the thread.STRINGupdated_at
Timestamp when the source content was last updated.STRINGmessages[].sources[].updatedAt
Timestamp when the handoff request was submitted.STRINGmessages[].handoff_submitted_at
Width in pixels of the medium thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.medium.width
Body text of the cited knowledge article or chunk.STRINGmessages[].content[].content
Page title where the discovery thread was started.STRINGlocation.title
YouTube video identifier object.OBJECTmessages[].videos[].id
Canonical URL meta tag when the message was sent.STRINGmessages[].location.meta.canonical
Array of user queries and AI responses in the thread.ARRAYmessages
Type of source citation (article, web page, etc.).STRINGmessages[].sources[].type
Display order number for the source citation.INTEGERmessages[].sources[].citationNumber
Height in pixels of the high-resolution thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.high.height
User timezone when the message was sent.STRINGmessages[].location.timezone
YouTube API resource kind for the video result.STRINGmessages[].videos[].kind
Whether the user submitted the lead generation follow-up.BOOLEANmessages[].lead_gen_submitted
YouTube resource kind for the video identifier.STRINGmessages[].videos[].id.kind
Open Graph URL meta tag from the page.STRINGlocation.meta.og:url
File name for file-based knowledge content.STRINGmessages[].content[].fileName
Content moderation flags on the cited knowledge chunk.ARRAYmessages[].content[].moderation_flags
Title of the source citation.STRINGmessages[].sources[].title
GUID assigned to an anonymous visitor in the thread.STRINGuser.anonymous_guid
YouTube thumbnail images for the video.OBJECTmessages[].videos[].snippet.thumbnails
Timestamp when the cited knowledge content was created.STRINGmessages[].content[].createdAt
Ordering sequence number for the cited content chunk.INTEGERmessages[].content[].sequenceNumber
Identifier for the cited knowledge content chunk.STRINGmessages[].content[].id
Open Graph type when the message was sent.STRINGmessages[].location.meta.og:type
Scheduled publish time for the YouTube video.STRINGmessages[].videos[].snippet.publishTime
Thumbnail URL for a returned video.STRINGmessages[].videos[].thumbnail
Meta keywords when the message was sent.STRINGmessages[].location.meta.keywords
Page context where this individual message was sent.OBJECTmessages[].location
Timestamp when the cited knowledge content was last updated.STRINGmessages[].content[].updatedAt
Default-size YouTube thumbnail object.OBJECTmessages[].videos[].snippet.thumbnails.default
Publication timestamp for the YouTube video.STRINGmessages[].videos[].snippet.publishedAt
Whether the discovery thread has been shared.BOOLEANshared
YouTube video snippet metadata object.OBJECTmessages[].videos[].snippet
Browser user agent when the message was sent.STRINGmessages[].location.user_agent
Knowledge base articles or content chunks cited in the answer.ARRAYmessages[].content
GUID of a prior thread this conversation was branched from.STRINGconversation_started_from_thread_guid
Content moderation flags raised for the thread.ARRAYmoderation_flags
Vector search namespace for the cited knowledge chunk.NULLmessages[].content[].namespace
High-resolution YouTube thumbnail object.OBJECTmessages[].videos[].snippet.thumbnails.high
Timestamp when the lead generation follow-up was submitted.STRINGmessages[].lead_gen_submitted_at
Browser user agent string when the thread was started.STRINGlocation.user_agent
GUID of a knowledge article listed as a source citation.STRINGmessages[].sources[].articleGuid
YouTube video title from the snippet.STRINGmessages[].videos[].snippet.title
Client subdomain for the cited knowledge content.STRINGmessages[].content[].subdom
Embed URL for a returned video.STRINGmessages[].videos[].embedUrl
Browser screen size when the message was sent.STRINGmessages[].location.screen_size
Page title when the message was sent.STRINGmessages[].location.title
Element451 person identifier for the thread user.STRINGuser.user_id
Current state of the Bolt Discovery chatbot session.STRINGchatbot_state
Open Graph content type meta tag from the page.STRINGlocation.meta.og:type
GUID of a knowledge base article cited in the answer.STRINGmessages[].content[].articleGuid
Timestamp when the message was last updated.STRINGmessages[].updated_at
Live broadcast status for the YouTube video.STRINGmessages[].videos[].snippet.liveBroadcastContent
Categories assigned to the cited knowledge article.ARRAYmessages[].content[].categories
URL of the medium-resolution YouTube thumbnail.STRINGmessages[].videos[].snippet.thumbnails.medium.url
Explanation for content moderation actions on the thread.STRINGmoderation_reasoning
Whether the user submitted a live support handoff request.BOOLEANmessages[].handoff_submitted
Client subdomain for the source citation.STRINGmessages[].sources[].subdom
User rating or feedback on the AI answer.STRINGmessages[].rate
URL slug for the discovery thread.STRINGslug
Page heading when the message was sent.STRINGmessages[].location.heading
Meta description when the message was sent.STRINGmessages[].location.meta.description
URL of the page where the discovery thread was started.STRINGlocation.url
Twitter card description meta tag from the page.STRINGlocation.meta.twitter:description
HTML meta tags from the page where the thread started.OBJECTlocation.meta
Open Graph description meta tag from the page.STRINGlocation.meta.og:description
Open Graph description when the message was sent.STRINGmessages[].location.meta.og:description
HTML meta tags from the page when the message was sent.OBJECTmessages[].location.meta
Height in pixels of the default thumbnail.INTEGERmessages[].videos[].snippet.thumbnails.default.height
YouTube video description from the snippet.STRINGmessages[].videos[].snippet.description
Whether the cited knowledge content is private.BOOLEANmessages[].content[].private
Open Graph title when the message was sent.STRINGmessages[].location.meta.og:title
YouTube channel title for the video.STRINGmessages[].videos[].snippet.channelTitle
MongoDB document identifier for the discovery thread.STRING_id
Excerpt text shown for the source citation.STRINGmessages[].sources[].content
Whether the thread was blocked by content moderation.BOOLEANmoderation_block
YouTube channel name for a returned video.STRINGmessages[].videos[].channel
Unique GUID for the discovery thread.STRINGguid
Ordering sequence number for the source citation.INTEGERmessages[].sources[].sequenceNumber
URL of the source citation.STRINGmessages[].sources[].url
Page heading visible when the thread was started.STRINGlocation.heading
Description text for a returned video.STRINGmessages[].videos[].description
YouTube API etag for a returned video.STRINGmessages[].videos[].etag
Timestamp when the message was created.STRINGmessages[].created_at
Display title for the discovery thread.STRINGtitle
Natural language question submitted by the user.STRINGmessages[].user_query
Source citations displayed with the AI answer.ARRAYmessages[].sources
Whether the thread user is an internal Element451 user.BOOLEANuser.is_internal