View frequent queries and users of a table
You can use the Insights tab in Data Explorer to view the most frequent recent queries and users of any table registered in Unity Catalog. The Insights tab reports on frequent queries and user access for the past 30 days.
This information can help you answer questions like:
Can I trust this data?
What are some good ways to use this data?
Which users can answer my questions about this data?
The queries and users listed on the Insights tab are limited to queries performed using Databricks SQL.
Before you begin
You must have the following permissions to view frequent queries and user data on the Insights tab.
In Unity Catalog:
SELECTprivilege on the table.
USE SCHEMAprivilege on the table’s parent schema.
USE CATALOGprivilege on the table’s parent catalog.
Metastore admins have these privileges by default. See Manage privileges in Unity Catalog.
In Databricks SQL:
Can Viewpermissions on the queries. You will not see queries that you do not have permission to view. See Query access control.
View the Insights tab
In your Databricks workspace, click Data to open Data Explorer.
Search for or navigate to the table you want insights on.
On the table page, click the Insights tab.
Queries made on the table and users who accessed the table in the past 30 days are listed in order of frequency, with the most frequent on top.