find_assets_by_column
Search across spaces to find tables/views containing a specific column name for data lineage and impact analysis.
Instructions
Find all assets (tables/views) containing a specific column name across SAP Datasphere spaces.
Use this tool when:
User asks "Which tables contain CUSTOMER_ID?"
Performing data lineage analysis
Impact analysis before schema changes
Finding datasets for specific use cases
Locating related data across spaces
What you'll get:
Asset names and types (View, Table, etc.)
Space IDs where assets are located
Column information (name, type, position)
Total column count per asset
Consumption URLs for data access
Use cases:
Data lineage discovery (find all uses of a column)
Impact analysis (before renaming/removing columns)
Dataset discovery (find tables with specific fields)
Cross-space data exploration
Schema relationship mapping
Example queries:
"Find all tables with CUSTOMER_ID column"
"Which views contain SALES_AMOUNT?"
"Show me assets with COUNTRY_CODE in SAP_CONTENT space"
"List tables that have ORDER_DATE column"
Performance notes:
Searches across multiple spaces by default
Uses intelligent caching for better performance
Results limited to 50 assets by default (configurable)
Case-insensitive search by default
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| column_name | Yes | Column name to search for (case-insensitive by default). Examples: 'CUSTOMER_ID', 'SALES_AMOUNT', 'ORDER_DATE' | |
| space_id | No | Optional: Limit search to specific space (e.g., 'SAP_CONTENT'). Leave empty to search all spaces. | |
| max_assets | No | Optional: Maximum number of matching assets to return (1-200). Default: 50 | |
| case_sensitive | No | Optional: Perform case-sensitive column name matching. Default: false |