Databricks Assistant system table reference and example
Preview
This system table is in Public Preview. To access the table, the schema must be enabled in your system
catalog. For more information, see Enable system table schemas.
This article provides an overview of the Databricks Assistant events system table and an example that uses the data in a dashboard. Each row in this system table represents a message sent by a user in either the Assistant window or in-cell Assistant.
This system table is located at system.access.assistant_events
.
For more information on the Databricks Assistant, see What is Databricks Assistant?.
Assistant events schema
The Databricks assistant events system table uses the following schema:
Event |
Data type |
Description |
Example |
---|---|---|---|
|
string |
A unique ID for this event. |
|
|
string |
ID of the account. |
|
|
string |
ID of the workspace. |
|
|
timestamp |
Time that the event happened. Timezone information is recorded at the end of the value with |
|
|
string |
Date that the event happened. |
|
|
string |
Origination of request. |
|
|
string |
Email of the user initiating the request. |
|
Assistant usage dashboard
Use system table data to monitor adoption of Databricks Assistant. The dashboard shows the following:
Active users by day and month
Active users per workspace
Top users overall
Submissions data: per workspace and total
![Example of a dashboard showing usage data for Databricks Assistant](../../_images/assistant-usage-dashboard-org.png)
To visualize the system table activity for Databricks Assistant, download the Assistant events dashboard file from GitHub.
After you download the JSON file, import the dashboard into your workspace. For instructions on importing dashboards, see Import a dashboard file.