find_tables
Find tables across all databases by searching table names and comments using a keyword. No need to know where the table is located.
Instructions
Search for tables by keyword across ALL databases.
USE THIS WHEN: You don't know where a table is, but know part of its name or purpose.
Searches both table names AND table comments.
RETURNS: Flat list of matching tables
- [{database, schema, table, type, full_name, columns, comment}, ...]
HOW IT WORKS:
- Auto-refreshes cache if expired/empty (requires Snowflake auth on first use)
- Uses cached data if available (no auth needed)
- Searches table names and comments for the keyword (case-insensitive)
Parameters:
- search_term: Keyword to search for (case-insensitive)
Examples:
- find_tables("customer") - Find all customer-related tables across all databases
- find_tables("revenue") - Find revenue tables anywhere
- find_tables("staging") - Find tables with "staging" in name or commentInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| search_term | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||