How to interpret usage metrics

Have more questions? Submit a request
πŸ’ͺ Did you know? Atlan currently supports usage and popularity metrics only for Snowflake and Google BigQuery assets.

Powered by Atlan’s enhanced query-mining capabilities, you can now view popularity metrics for all Snowflake and Google BigQuery tables, views, and columns:

  • The popularity score of a data 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
  • The popularity indicator is displayed for all Snowflake and Google BigQuery tables, views, and columns 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 the popularity metrics of an asset:

  1. In the left menu in Atlan, click Assets.
  2. For Connector on the Assets page, select a connector β€” for this example, we'll select Snowflake.
  3. Next to the search bar on the Assets page, click the sort icon and then click Most popular or Least popular.
  4. 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 the usage details for your assets:

  1. In the left menu in Atlan, click Assets.
  2. For Connector on the Assets page, select a connector β€” for this example, we'll select Snowflake.
  3. Next to the search bar on the Assets page, click the sort icon and then click Most popular or Least popular.
  4. In the bottom right of any asset card, click or hover over the popularity indicator to open the popularity popover. 
  5. In the popularity popover, click View usage details to view details like top and recent users, the top five queries by context, or the total compute cost for a given asset.

The usage details of your asset will now appear in the asset sidebar! πŸŽ‰

πŸ’ͺ Did you know? The compute cost for an asset is split between read and write queries, allowing you to better understand the cost breakdown for individual assets.

View and sort columns by popularity

For any Snowflake and 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 your columns by popularity:

  1. In the left menu in Atlan, click Assets.
  2. For Connector on the Assets page, select a connector β€” for this example, we'll select Snowflake.
  3. Next to the search bar on the Assets page, click the sort icon and then click Most popular or Least popular.
  4. Click on any asset to navigate to its asset profile.
  5. In the Column preview tab of the asset profile, hover over the popularity indicator to view the popularity popover for your columns.
  6. (Optional) In the search bar under Column preview, click the sort icon and then click Most popular or Least popular to sort your columns by popularity.

You'll now be able to view the popularity score, number of queries and users, and when it was 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 Insights.

 

To view and work with queries by context:

  1. In the left menu in Atlan, click Assets.
  2. For Connector on the Assets page, select a connector β€” for this example, we'll select Snowflake.
  3. Next to the search bar on the Assets page, click the sort icon and then click Most popular or Least popular.
  4. In the bottom right of any asset card, click or hover over the popularity indicator to open the popularity popover. 
  5. In the popularity popover, click View usage details.
  6. 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. 
  7. 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.
πŸ’ͺ Did you know? If you have any questions about usage and popularity metrics, head over here.

Related articles

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