[SPIKE] Document data sources for DAP usage dashboard user actions

Background

For Duo Agent Platform (DAP), we are developing new Usage Dashboards that will provide visibility into customer consumption and billing. These dashboards will display:

• User actions or action categories (request categories) taken within DAP
• Associated GitLab Credit usage for each action
• Breakdown by user and timestamp
• Potential grouping by Session ID for aggregated views
• etc

Example:

The dashboards are part of the broader initiative to help customers understand their consumption patterns, track usage against their commitments, and manage overages. This data will be displayed at multiple levels, from account-level summaries down to individual user drill-downs showing specific actions taken and their associated credit consumption.

Request

We need to identify and document the data source(s) and table(s) that contain the user actions/request categories for DAP to populate the usage dashboards. Based on a conversation with Dasha, the following types of info exist:

• User actions are tracked with granular detail including:
  • Request category (chat, flow triggers, code generation, code completion, etc.)
  • Workflow ID and Session ID
  • Timestamp
  • Token consumption (input tokens, output tokens, overall tokens)
  • Model used
  • Namespace and instance ID
  • Success/failure status
  • Individual DAP features (root cause analysis, vulnerability explanation, etc.)

Data Location: The data exists in Snowflake across three main tables.

1. @dashaadu, could you please provide table names?

Question for Utilization

1. Does this data route through Clickhouse, or is there a direct path from Snowflake to the usage dashboard in CustomerDot?
2. How will utilization stay updated as new categories/actions are added during active development toward GA?