FCT_AI_ASSISTANT_SESSION_MESSAGES can be used to establish if the AI Assistant within the platform is being used, how quickly it responds and what type of questions are being asked. The table can be joined to DIM_USER_SERVICE_USER on User ID, many to 1, to show which users engaging with the AI Assistant
FCT_AI_ASSISTANT_SESSION_MESSAGES retains data based upon Session Created Timestamp, data is available for the previous two years and current calendar year only
Message/conversation text is not available within this dataset
⏰ 👀 COMING SOON - This data set is currently in development and is subject to change
COLUMN NAME | DATA TYPE (FIELD SIZE) | DESCRIPTION | CURRENT AVAILABLE VALUES | EXAMPLE |
|---|---|---|---|---|
Doc Created At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Doc Updated At | TIMESTAMP_NTZ(9) | Timestamp inherited from parent snowflake object(s) | 2025-01-01T00:00:00.000+0000 | |
Has Connector Search Source | NUMBER(1,0) | Will show 1 if the AI Assistant used connector search within its response | 1, 0 | 1 |
Has Content Source | NUMBER(1,0) | Will show 1 if the AI Assistant used content within its response | 1, 0 | 1 |
Has Web Search Source | NUMBER(1,0) | Will show 1 if the AI Assistant used web search within its response | 1, 0 | 0 |
Is Content Required For Answer | BOOLEAN | Flag to show if the AI Assistant needed to use content for the message. This is only relevant to assistant messages, user messages will display FALSE | TRUE, FALSE | TRUE |
Is Relevant Content Found | BOOLEAN | Flag to show if the AI Assistant found relevant content for the message. This is only relevant to assistant messages, user messages will display FALSE | TRUE, FALSE | FALSE |
Message Count | NUMBER(1,0) | Used for reporting, a value of 1 is shown for each row as a message count | 1 | 1 |
Message ID | VARCHAR(16777216) | Identifier for the message | 123a12b3cd4e5f67g890h1ij | |
Message Intent | VARCHAR(16777216) | Details the intent of the message. This is only relevant to assistant messages, user messages will display not applicable | action request, ambiguous question, content suggestion request, irrelevant question, not applicable, other, platform question, summary request, term definition request, translation request, work question | platform question |
Message Latency (Seconds) | NUMBER(38,2) | Message response measured in seconds. This is only relevant to assistant messages, user messages will be null | 1.73 | |
Message Role | VARCHAR(16777216) | Details who has created this message | assistant, user | assistant |
Message Source | VARCHAR(16777216) | A field to show which sources were used by the AI Assistant when responding to messages. If the row relates to a user message role this will show as not applicable, if data unavailable and the data related to an assistant message role it will show unknown | platform content, web search, connector search, unknown, not applicable | platform content and connector search |
Model | VARCHAR(16777216) | Details which AI model was used for the message. This is only relevant to assistant messages, user messages will display not applicable | gpt-4.1-2025-04-14 | |
Provider | VARCHAR(16777216) | Details which AI provider was used for the message. This is only relevant to assistant messages, user messages will display not applicable | openai | |
Session Created Date | DATE | Date the AI Assistant session started | 2025-01-01 | |
Session Created Time | VARCHAR(16777216) | Time the AI Assistant session started | 00:00:00 | |
Session Created Timestamp | TIMESTAMP_NTZ(9) | Datetime the AI Assistant session started | 2025-01-01T00:00:00.000+0000 | |
Session ID | VARCHAR(16777216) | Identifier for the session | 123a12b3cd4e5f67g890h1ij | |
Session Updated Date | DATE | Date the AI Assistant session updated | 2025-01-01 | |
Session Updated Time | VARCHAR(16777216) | Time the AI Assistant session updated | 00:00:00 | |
Session Updated Timestamp | TIMESTAMP_NTZ(9) | Datetime the AI Assistant session updated | 2025-01-01T00:00:00.000+0000 | |
Tenant ID | VARCHAR(16777216) | Identifier for the tenant | eu-west-2_abcdefGh1 | |
User ID | VARCHAR(16777216) | Identifier for the user | 123a12b3cd4e5f67g890h1ij |