How to interpret usage metrics

Have more questions? Submit a request
๐Ÿ’ช Did you know? Atlan currently supports usage and popularity metrics only for Snowflake tables, views, and columns.

Powered by Atlanโ€™s enhanced query-mining capabilities, you can now view popularity metrics for all Snowflake 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.
  • The popularity indicator is displayed for all Snowflake 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 Snowflake 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, click 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, click 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! ๐ŸŽ‰

View and sort columns by popularity

For any Snowflake 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, click 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, click 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