search_tables
Search for tables and views by name or description across all Datasphere spaces. Use keywords to find tables even with partial matches.
Instructions
Search for tables and views across all Datasphere spaces by name or description.
Use this tool when:
User asks "Find tables with customer data"
Looking for tables containing specific keywords
Don't know exact table name but know the domain
Searching across multiple spaces
Search behavior:
Searches both table names and descriptions
Case-insensitive matching
Returns results from all spaces (or specific space if filtered)
Includes table metadata (type, columns, row counts)
Search tips:
Use domain keywords: "customer", "sales", "order", "finance"
Partial matches work: "cust" finds "CUSTOMER_DATA"
Filter by space_id to narrow results
Example queries:
"Find all tables related to customers"
"Search for sales order tables"
"Show me all tables with 'finance' in the name"
Next steps:
Use get_table_schema() for detailed column information
Use execute_query() to retrieve actual data
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| search_term | Yes | Keyword to search for in table names and descriptions (e.g., 'customer', 'sales', 'order'). Case-insensitive, partial matches work. | |
| space_id | No | Optional: Filter results to a specific space (e.g., 'SALES_ANALYTICS'). Leave empty to search all spaces. |