## Interpret usage metrics

URL: https://docs.atlan.com/product/capabilities/usage-and-popularity/how-tos/interpret-usage-metrics

Atlan currently supports usage and popularity metrics for the following connectors:

- [Amazon Redshift](https://docs.atlan.com/llms/connectors/amazon-redshift/mine-amazon-redshift/llms.txt) - tables, views, and columns. Expensive queries and compute costs for Amazon Redshift assets are currently unavailable due to limitations at source.
- [Databricks](https://docs.atlan.com/llms/connectors/databricks/extract-lineage-and-usage-from-databricks/llms.txt) - tables, views, and columns. Expensive queries and compute costs for Databricks assets are currently unavailable due to limitations of the [Databricks APIs](https://docs.databricks.com/api/workspace/queryhistory/list).
- [Google BigQuery](https://docs.atlan.com/llms/connectors/google-bigquery/mine-google-bigquery/llms.txt) - tables, views, and columns
- [Microsoft Power BI](https://docs.atlan.com/llms/connectors/microsoft-power-bi/mine-microsoft-power-bi/llms.txt) - reports and dashboards
- [Snowflake](https://docs.atlan.com/llms/connectors/snowflake/mine-snowflake/llms.txt) - tables, views, and columns
- [Tableau](https://docs.atlan.com/llms/connectors/tableau/view-based-popularity-metrics/llms.txt) - workbooks, dashboards, worksheets, published data sources, and flows. Popularity is sourced from the Tableau Cloud Content Exploration API as part of the standard crawl, so no separate miner workflow is required. Tableau Server, JWT bearer authentication, and unique-viewer counts aren't supported.

:::warning Upcoming change: Databricks SQL query text masking
Starting **August 26, 2026**, Databricks masks SQL query text by default for third-party integrations. Usage and popularity metrics for Databricks assets stop updating once this change takes effect. For full details and remediation steps, see [Databricks SQL query text masking change](https://docs.atlan.com/llms/connectors/databricks/databricks-sql-masking-change/llms.txt).
:::

Powered by Atlan's enhanced query-mining capabilities, you can view popularity metrics for supported assets:

- The **popularity score** of an asset is computed using both the number of queries and the number of users who have queried that asset in the last 30 days. The popularity score of an asset helps determine its relative popularity. All assets with a popularity score are then slotted into one of four percentile groups - _Least popular_, _Less popular_, _Popular_, and _Most popular_.
 - Popularity score is calculated using the following formula:

 ```
 number of distinct users * log (total number of read queries)
 ```

 - Time period = 30 days
- The **popularity indicator** is displayed for all supported assets that have been queried in the last 30 days. This indicator visualizes the relative popularity of an asset on a scale of 1 to 4 blue bars - 1 being the lowest score and 4 being the highest.
- A **popularity popover** will appear when hovering over the popularity indicator. It displays additional information pertaining to an asset, such as a graph for trends in the data, last queried and by whom, and when the data was last updated.

## View popularity metrics

To view popularity metrics for your assets, complete these steps.

### Identify popular assets

Being able to identify your most relevant and trusted data assets can help you increase their adoption and drive usage within your organization.

To view popularity metrics for an asset:

1. From the left menu of any screen in Atlan, click on **all assets**.

 If you are using the **Old UI (Classic)**, from the left menu of any screen in Atlan, click **Assets**.
2. For _Connector_ on the _Assets_ page, select a supported connector - for this example, we'll select _Snowflake_.
3. Next to the search bar on the _Assets_ page, click the sort button.
4. From the _Popularity_ sorting menu, click **Most popular** to view most used assets or **Least popular** to view least used assets.
5. Your assets will now have a popularity indicator. To view the popularity popover for an asset, click or hover over the **popularity** **indicator**. 

You'll now be able to see all the relevant popularity metrics for your asset! 🎉

### View usage metrics in the asset sidebar

The new _Usage_ tab in the asset sidebar helps you view usage metadata for your assets.

For example, if you'd like to appoint a data steward for your data assets, you'll be able to determine the right candidate based on the top users for that asset. You'll also be able to review popular queries or users for a particular table while checking for data compliance.

To view usage details for an asset:

1. From the left menu of any screen in Atlan, click on **all assets**.

 If you are using the **Old UI (Classic)**, from the left menu of any screen in Atlan, click **Assets**.
2. For _Connector_ on the _Assets_ page, select a supported connector - for this example, we'll select _Snowflake_.
3. Next to the search bar on the _Assets_ page, click the sort button.
4. From the _Popularity_ sorting menu, click **Most popular** to view most used assets or **Least popular** to view least used assets.
5. In the bottom right of any asset card, click or hover over the **popularity** **indicator** to open the popularity popover. 
6. In the popularity popover, click **View usage details** to view the following:
 - For _Usage_, view top and recent users in the last 30 days.
 - For _Queries_, view top five queries by context - _Popular_, _Slow_, and _Expensive_. Only read queries or `SELECT` statements are shown for these queries.
 - For _Compute_, view the total [compute cost](https://docs.atlan.com/llms/catalog/usage-and-popularity/troubleshooting-usage-and-popularity-metrics/llms.txt) for an asset. The compute cost is split between read and write queries, allowing you to better understand the cost breakdown for individual assets:
 - Read queries - `SELECT` statements.
 - Write queries - all non-`SELECT` statements, for example, `UPDATE`, `INSERT`, `CREATE`, and more.

The usage details for the asset will now appear in the asset sidebar! 🎉

### View and sort columns by popularity

For any Snowflake, Databricks, or Google BigQuery table or view sorted by popularity, you'll also be able to view and sort the columns by popularity in the asset profile.

To view column assets by popularity:

1. From the left menu of any screen in Atlan, click on **all assets**.

 If you are using the **Old UI (Classic)**, from the left menu of any screen in Atlan, click **Assets**.
2. For _Connector_ on the _Assets_ page, select a supported connector - for this example, we'll select _Snowflake_.
3. Next to the search bar on the _Assets_ page, click the sort button.
4. From the _Popularity_ sorting menu, click **Most popular** to view most used assets or **Least popular** to view least used assets.
5. Click any asset to open to its asset profile.
6. In the _Column preview_ tab of the asset profile, hover over the popularity indicator to view the popularity popover for your columns.
7. (Optional) In the search bar under _Column preview_, click the **sort icon** and then click **Most popular** or **Least popular** to sort columns by popularity.

You'll now be able to view the popularity score, number of queries and users, and timestamp for last queried for your columns! 🎉

## View queries by context

Get the context you need before querying an asset to help you optimize your queries. Query popular, slow, or expensive queries from the _Usage_ tab directly in Data Exploration.

To view and work with queries by context:

1. From the left menu of any screen in Atlan, click on **all assets**.

 If you are using the **Old UI (Classic)**, from the left menu of any screen in Atlan, click **Assets**.
2. For _Connector_ on the _Assets_ page, select a supported connector - for this example, we'll select _Snowflake_.
3. Next to the search bar on the _Assets_ page, click the sort button.
4. From the _Popularity_ sorting menu, click **Most popular** to view most used assets or **Least popular** to view least used assets.
5. In the bottom right of any asset card, click or hover over the **popularity** **indicator** to open the popularity popover. 
6. In the popularity popover, click **View usage details**.
7. In the _Usage_ tab in the asset sidebar, navigate to _Queries_ and depending on the type of query you'd like to see:
 - Click **Popular** to see the top five most popular queries. 
 - Click **Slow** to see queries sorted by average duration and last run.
 - Click **Expensive** to see the top five most expensive queries. 
8. Once you've selected the relevant query type, hover over a query card to:
 - Click the **expand icon** to see the query details.
 - Click the **copy icon** to copy the query and use it as a template for writing your own queries.
 - Click the **code icon** to open the query directly in _Insights_ and run it.

:::info **Did you know?** 
 If you have any questions about usage and popularity metrics, head over [here](https://docs.atlan.com/llms/catalog/usage-and-popularity/troubleshooting-usage-and-popularity-metrics/llms.txt).

:::

---