dba_tableSpace
Shows table-level disk space usage in a Teradata database, ranked by size. Use to find which tables are consuming the most storage.
Instructions
Show table-level disk space usage within a specific Teradata database, ranked by size. Use when the user asks which tables are largest or consuming the most storage within a named database. NEVER call this tool with an empty database_name — if the user's message does not explicitly name a database, ask which database they want before calling. For space allocated to a whole database, use dba_databaseSpace. For total system-wide storage, use dba_systemSpace.
Arguments: database_name - Database name. Required — do not pass empty string. table_name - Table name filter. Leave empty for all tables. top_n - Limit results to top N largest tables by space. Set to 0 for no limit (default: 0). exclude_system - Exclude system databases and tables. Set to 'Y' to exclude, 'N' to include all (default: 'N'). persist - If True, materializes result as a volatile table and returns table name
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| top_n | No | Limit results to top N largest tables by space. Set to 0 for no limit (default: 0). | |
| persist | No | If True, materializes result as a volatile table and returns table name | |
| table_name | No | Table name filter. Leave empty for all tables. | |
| database_name | Yes | Database name. Required — do not pass empty string. | |
| exclude_system | No | Exclude system databases and tables. Set to 'Y' to exclude, 'N' to include all (default: 'N'). | N |