⏰ From the end of April 2026 as we move to AI Assistant V2 reporting will update to be interaction (turn) based rather than message based. One interaction (turn) = 1 AI Assistant and 1 User Message, this would previously have shown as two messages
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
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 | TRUE, FALSE | TRUE |
Is Relevant Content Found | BOOLEAN | Flag to show if the AI Assistant found relevant content for the message | TRUE, FALSE | FALSE |
Message Count Interaction Count in platform Insights | NUMBER(1,0) | Used for reporting, a value of 1 is shown for each row as an interaction count | 1 | 1 |
Message ID Interaction ID in platform Insights | VARCHAR(16777216) | Identifier for the interaction | 123a12b3cd4e5f67g890h1ij | |
Message Intent Interaction Intent in platform Insights | VARCHAR(16777216) | Details the intent of the interaction Where multiple topics are recorded against the interaction the first will be surfaced | platform question | |
Message Latency (Seconds) Interaction Latency (Seconds) in platform Insights | NUMBER(38,2) | Interaction response measured in seconds | 1.73 | |
Message Source Interaction Source in platform Insights | VARCHAR(16777216) | A field to show which sources were used by the AI Assistant when responding. If data is unavailable it will show unknown | platform content, web search, connector search, unknown | platform content and connector search |
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 |