How to 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 — tables, views, and columns. Expensive queries and compute costs for Amazon Redshift assets are currently unavailable due to limitations at source.
• Databricks — tables, views, and columns. Expensive queries and compute costs for Databricks assets are currently unavailable due to limitations of the Databricks APIs.
• Google BigQuery — tables, views, and columns
• Microsoft Power BI — reports and dashboards
• Snowflake — 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 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, 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 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! 🎉