## Find assets by usage

URL: https://docs.atlan.com/product/capabilities/usage-and-popularity/how-tos/find-assets-by-usage

Data teams often lack clarity on which data assets can be considered trustworthy, whether these are frequently used, the freshness of the data itself, or how critical these are for enrichment and governance.

With Atlan's usage and popularity metadata, you'll be able to check off all these boxes! You can view usage metrics for your assets collected over the last 30 days.

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

## Filter assets by usage

Use the usage filters to filter your assets by usage metadata. For instance, you'll be able to filter assets with zero queries and archive them or find costly assets to better optimize your operations.

To filter assets by usage metadata:

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. In the _Filters_ menu in _Assets_, click **Usage** to expand the list of filters.
3. From the _Usage_ menu:
 1. For _SQL_ assets, use the following filters:
 - Click **Number of queries** to filter by the number of queries at source in the last 30 days.
 - Click **Number of users** to filter by the number of users who queried an asset at source in the last 30 days.
 - Click **Last queried** to filter by the last queried timestamp at source.
 - Click **Last row updated at** to filter by the last row updated timestamp at source.
 - To filter assets by [compute cost](https://docs.atlan.com/llms/catalog/usage-and-popularity/troubleshooting-usage-and-popularity-metrics/llms.txt), click **Snowflake credits** for Snowflake assets or click **BigQuery query cost** for Google BigQuery assets.
 2. For _BI_ assets, use the following filters:
 - Click **Views count** to filter by the number of views at source in the last 30 days.
 - Click **Number of users** to filter by the number of users who viewed an asset at source in the last 30 days.
 - Click **Last viewed** to filter by the last viewed timestamp at source.

Your search results will now be filtered by usage metadata! 🎉

## Sort assets by popularity

Sort your data assets by popularity metadata to view the most or least used tables, views, or columns. For example, sorting your assets by popularity can help you deprecate unused or stale data assets, helping you reduce operational costs for your organization.

To sort 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. 

Your assets in the search results will now be sorted by popularity of usage! 🎉

:::info **Did you know?** 
 You can also [deep dive into usage metrics](https://docs.atlan.com/llms/catalog/usage-and-popularity/interpret-usage-metrics/llms.txt) for Snowflake, Databricks, Google BigQuery, and Microsoft Power BI in Atlan.

:::

---