search_tables
Search for tables and views across all Datasphere spaces by name or description, with case-insensitive partial matching and optional space filtering.
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 |
|---|---|---|---|
| space_id | No | Optional: Filter results to a specific space (e.g., 'SALES_ANALYTICS'). Leave empty to search all spaces. | |
| search_term | Yes | Keyword to search for in table names and descriptions (e.g., 'customer', 'sales', 'order'). Case-insensitive, partial matches work. |