findQueriesByColumn
findQueriesByColumnLocate stored SQL queries referencing a specific column, and identify its use in SELECT, WHERE, JOIN, ORDER BY, or HAVING clauses.
Instructions
Find stored application/report queries that actually reference one column and show whether it appears in SELECT, WHERE, JOIN, ORDER BY or HAVING. Use describeTable to discover declared columns; schema/table filters are optional and case-insensitive.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | No | ||
| column | Yes | ||
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| count | Yes | Number of matching catalog queries returned for the column. | |
| table | No | Table containing the searched column. | |
| column | No | ||
| schema | No | ||
| matches | No | Usage-catalog matches returned for the requested table, column, or filter. |