We are looking to create a Genie usage report covering natural language querying activity across three channels — the Genie One web app, Genie One Teams app, and Genie One mobile app. The report is intended to surface insights around user activity, question types, query patterns, feedback, and session behaviour.

What we are currently able to extract via system tables (across all channels)

- User email
- Number of questions asked
- Source breakdown by channel (Web App / Teams / Mobile) with question counts
- First and last active date
- Feedback count

What we are unable to extract

For questions asked across all three channels (web app, Teams, and mobile), we are currently unable to retrieve:

- Actual question text asked by the user
- SQL queries executed in response to the question
- Tables and assets queried
- Feedback type (thumbs up / thumbs down) and associated feedback text where provided

Questions

1. Is there a system table that currently stores this information, or a mapping that would allow us to extract it?
2. If not, is there an alternative approach recommended by Databricks to access this data?