base_tableAffinity
Analyze and identify tables frequently used together in Teradata databases to infer relationships, generate SQL queries, and return metadata for better data management and insights.
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: database_name - Database name object_name - table or view name
Returns: ResponseType: formatted response with query results + metadata
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | Yes | ||
| obj_name | Yes |
Input Schema (JSON Schema)
{
"properties": {
"database_name": {
"title": "Database Name",
"type": "string"
},
"obj_name": {
"title": "Obj Name",
"type": "string"
}
},
"required": [
"database_name",
"obj_name"
],
"title": "handle_base_tableAffinityArguments",
"type": "object"
}