How to report on queries

πŸ€“ Who can do this? You must be an admin user in Atlan to view the reporting center. If enabled by admins, member users can also view the assets, glossary, Insights, and usage and cost dashboards. Permission to view the governance and automations dashboards is reserved for admin users only.

The Insights dashboard in the reporting center helps you track metrics for all your queries and query runs.

You can also use a variety of filters to customize your view of query metrics β€” including query collections, folders, saved queries, and more.

πŸ’ͺ Did you know? The default date range for metrics is set to 14 days. You can also view metrics for the last 7, 30, or 45 days, or a custom date range of your choice, where applicable.

Filter by query type

Atlan allows you to write your own SQL queries or use the Visual Query Builder. This means you can also filter query metrics by query type.

 

To filter queries by type of query:

  1. From the left menu in Atlan, click Reporting and then click Insights.
  2. From the Insights dashboard, in the upper right, click Query Type.
  3. From the Query Type dropdown, click SQL Query to view metrics for your SQL queries or click Visual Query to view metrics for your visual queries.
  4. (Optional) Under Queries by certificate, click any data point to view query assets in a sidebar. In the top right of the sidebar, click the Export button to export filtered assets to a spreadsheet.

View scheduled queries by user

The Insights dashboard also offers you a breakdown of scheduled queries by individual users. You can keep track of your scheduled queries as well as view top users.

 

To view scheduled queries by user:

  1. From the left menu in Atlan, click Reporting and then click Insights.
  2. From the Insights dashboard, scroll down to Scheduled Queries
  3. Under Scheduled Queries, click Created by all users.
  4. From the Created by all users dropdown, select the user by whom you want to filter scheduled queries.

Related articles

Was this article helpful?
0 out of 0 found this helpful