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:
- From the left menu in Atlan, click Reporting and then click Usage & Cost.
- From the Usage & Cost dashboard, click the Queried by filter and select the user by whom you want to filter usage metrics.
- (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:
- From the left menu in Atlan, click Reporting and then click Usage & Cost.
- From the Usage & Cost dashboard, scroll down to Review your tables & views.
- (Optional) To further refine your search, click More filters.
- Click View assets for any card to view a list of suggested assets for deprecation in the sidebar.
- (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.
To filter assets by context:
- From the Usage & Cost dashboard, scroll down to Top tables & views.
- 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.