base_tableAffinity
Identify tables frequently used together in Teradata databases to infer relationships and optimize SQL queries. Provides metadata for prepared SQL and rendered SQL with literals for enhanced query analysis.
Instructions
Get tables commonly used together by database users, this is helpful to infer relationships between tables via SQLAlchemy, bind parameters if provided (prepared SQL), and return the fully rendered SQL (with literals) in metadata.
Arguments: db_name - Database name object_name - table or view name
Returns: ResponseType: formatted response with query results + metadata
Input Schema
Name | Required | Description | Default |
---|---|---|---|
db_name | Yes | ||
obj_name | Yes |