base_tableAffinity
Identify tables commonly used together in Teradata databases to infer relationships and generate fully rendered SQL queries with metadata for 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: 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"
],
"type": "object"
}