describe_table
Retrieve column details including names, data types, and constraints for a Snowflake table to build accurate queries.
Instructions
Get detailed column information for a specific table.
USE THIS WHEN: You need column names, types, and constraints to write a query.
Like SQL's: DESCRIBE TABLE database.schema.table
RETURNS: Detailed column information
- For each column: name, data_type, nullable, position, default, comment, is_primary_key
HOW IT WORKS:
- Looks up table in cache; fetches column details on-demand if not yet loaded
- First call for a table queries Snowflake live (~200ms), subsequent calls use cache
- If table not in cache at all, returns error (use show_tables or find_tables first)
Note: To get sample data rows, use execute_query tool separately.
Parameters:
- database: Database name
- schema: Schema name
- table: Table name
Examples:
- describe_table("SALES_DB", "PUBLIC", "CUSTOMERS")
- describe_table("GDC", "STAGING", "ADMIN__CATEGORIES")Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | ||
| schema | Yes | ||
| table | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||