show_tables
Explore Snowflake databases, schemas, and tables by applying pattern-based filters and viewing a hierarchical tree with column counts.
Instructions
Browse databases, schemas, and tables using pattern-based filtering.
USE THIS WHEN: You want to explore what databases/schemas exist, or need to filter by exact patterns.
Like SQL's: SHOW TABLES IN database LIKE 'pattern'
RETURNS: Hierarchical tree structure
- database → schema → list of tables (with column counts)
HOW IT WORKS:
- Auto-refreshes cache if expired/empty (requires Snowflake auth on first use)
- Uses cached data if available (no auth needed)
- Pattern matching is case-insensitive substring search
Parameters:
- database_pattern: Filter databases (e.g., "SALES" matches "SALES_DB", "SALES_PROD")
- schema_pattern: Filter schemas (e.g., "PUBLIC")
- table_pattern: Filter tables (e.g., "CUSTOMER" matches "CUSTOMERS", "CUSTOMER_ORDERS")
Examples:
- show_tables() - Browse all databases
- show_tables(database_pattern="SALES") - Only SALES databases
- show_tables(schema_pattern="PUBLIC") - All PUBLIC schemas across databasesInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_pattern | No | ||
| schema_pattern | No | ||
| table_pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||