Skip to main content
AI Data Engine

Investigate structured data in AI Data Engine

Contributors netapp-dbagwell
PDFs

When database storage is growing unexpectedly, filter by table metadata to find which tables are oversized or have shown no activity since they were first discovered. For example, a storage administrator can identify large tables that haven't changed since an early scan, then coordinate with the database owner to evaluate whether they are still needed.

Before you begin

  • You have connected at least one database data source, and it is scanning. Refer to Connect a data source.

Review the database table listing

See the database tables that AI Data Engine has discovered across your connected database servers.

Steps

  1. From the AI Data Engine UI, select Investigation.

  2. Select the Structured tab.

    The table displays database table name, schema, DB server, discovered time, table dimensions, and table size.

Identify oversized or unused tables

Use filters to narrow the listing to tables most likely to offer reclamation opportunities.

Steps

  1. Select Add filter, then select Discovered time.

  2. Set the range to show tables that have been present across multiple scan cycles, for example, tables first discovered more than a year ago.

  3. To narrow further, select Add filter again and filter by DB server or schema to focus on a specific system.

    Applied filters appear as tags below the filter bar. The results update as you add each filter.

Review table details

Assess whether a table is a reclamation candidate. Select a table row to open the detail panel.

The detail panel shows the DB server, schema, table dimensions, table size, and discovered time. Use this information to check whether the table has grown since discovery or stayed the same.

Note Before acting on database tables, coordinate with the database owner to confirm the table is no longer needed.

Save findings as a policy

After applying filters that identify tables of interest, save the criteria for ongoing monitoring.

Steps

  1. Select Create policy in the filter toolbar.

  2. Complete the policy form. Refer to Create a policy.

To download the filtered results from the Structured tab, select Download.