findQueriesByTable
findQueriesByTableFind stored application and report queries that reference a specific table. Reveal actual filters, joins, and business usage through case-insensitive matching, instead of inspecting table structure.
Instructions
Find stored application/report queries that actually reference one known table. Use to learn observed filters, joins and business usage, not to inspect declared table structure; resolved names are matched case-insensitively.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | 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 table. | |
| table | No | Table searched in the usage catalog. | |
| schema | No | ||
| matches | No | Usage-catalog matches returned for the requested table, column, or filter. |