Storage Management

Info

This feature is only available after version 2.3.2

Click on the Settings icon and select the Storage option.

On the Storage page, the admin can view all storage information.

Storage Information

• Type: Type of storage, such as S3, Azure Blob and Disk.
• Path: Path of storage.
• Query Expiration Time: SQL Query Result Expired Time.

Storage Usage

This section displays the usage of each resource type includingMaterialized View, Power BI Push Dataset, SQL Query Result and Tableau.

Depending on the type of resource, there are two update frequencies:

• Real-time updates: Materialized View and SQL Query Result
• Scheduled updates (updated every 12 hours): Power BI Push Dataset and Tableau

When hovering the bar chart, the last scan time of the resource will be displayed.

Storage Items

This section displays the usage of each resource in different workspaces. Clicking the + button can show more details.

Taking the SQL Query Result as an example, clicking the + button can expand to view the SQL statement and usage size of each query.

note

Each type displays a maximum of first 10 rows.

Taking the Materialized Views as an example, clicking the + button can expand to view the usage size of each materialized view. After clicking on the name mv_lineitem of the materialized view:

it will navigate to view this materialized view in the corresponding workspace.

Filter & Sort

In the column title, you can filter or sort to display the storage items you want to see.

• Type: Filter by resource type.

  

• Workspace Name: Filter by workspace name.

  

• Size: Sort by usage.