How to report on usage and cost

πŸ€“ Who can do this? You must be an admin user in Atlan to view the reporting center. If enabled by admins, member users can also view the assets, glossary, Insights, and usage and cost dashboards. Permission to view the governance and automations dashboards is reserved for admin users only.

The usage and cost dashboard in the reporting center can help you better understand asset usage and optimize your operations accordingly. You can track storage consumption for your assets, sort asset metrics by popularity, and filter assets by context β€” all in one dashboard.

The reporting center in Atlan currently supports usage and cost 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 for Databricks assets are currently unavailable due to limitations of the Databricks APIs.
  • Google BigQuery β€” tables, views, and columns
  • Snowflake β€” tables, views, and columns

Usage and cost metrics for Microsoft Power BI will be added in the future.

Filter asset usage by users

You can track total assets queried and storage consumption by users in your organization.

 

To filter asset usage by a user:

  1. From the left menu in Atlan, click Reporting and then click Usage & Cost.
  2. From the Usage & Cost dashboard, click the Queried by filter and select the user by whom you want to filter usage metrics.
  3. (Optional) To further refine your search, click More filters.

You will now be able to view usage and cost metrics for a specific user! πŸŽ‰

View least used assets

You can find suggestions for deprecating assets based on the following factors:

  • Tables and views without any lineage
  • Asset size less than 100 GB
  • Assets not queried at source in the last 30 days
  • Less popular assets not updated at source in the last 3 or 6 months

 

To view least used assets:

  1. From the left menu in Atlan, click Reporting and then click Usage & Cost.
  2. From the Usage & Cost dashboard, scroll down to Review your tables & views.
  3. (Optional) To further refine your search, click More filters.
  4. Click View assets for any card to view a list of suggested assets for deprecation in the sidebar.
  5. (Optional) In the top right of the sidebar, click the Export button to export filtered assets to a spreadsheet.

Filter assets by context

Discover the top 25 most popular, most expensive, and most queried tables and views from the usage and cost dashboard. This can provide you with additional context regarding asset usage across the organization.

πŸ’ͺ 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.

 

To filter assets by context:

  1. From the Usage & Cost dashboard, scroll down to Top tables & views.
  2. In the Top tables & views section, click the filters menu, and depending on the type of asset metrics you'd like to view:
    • Click Most Popular to view the top 25 most popular assets. 
    • Click Most Expensive to view the top 25 most expensive assets.
    • Click Most Queried to view the top 25 most queried assets. 
πŸ’ͺ 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