get_table_schema
Retrieve column names and data types for a specific table in the Panther data lake. Use this tool in conjunction with get_panther_log_type_schema() to optimize queries by understanding nested structures and field mappings.
Instructions
Get column details for a specific data lake table.
IMPORTANT: This returns the table structure in Snowflake. For writing optimal queries, ALSO call get_panther_log_type_schema() to understand:
- Nested object structures (only shown as 'object' type here)
- Which fields map to p_any_* indicator columns
- Array element structures
Example workflow:
- get_panther_log_type_schema(["AWS.CloudTrail"]) - understand structure
- get_table_schema("panther_logs.public", "aws_cloudtrail") - get column names/types
- Write query using both: nested paths from log schema, column names from table schema
Returns: Dict containing: - success: Boolean indicating if the query was successful - name: Table name - display_name: Table display name - description: Table description - log_type: Log type - columns: List of columns, each containing: - name: Column name - type: Column data type - description: Column description - message: Error message if unsuccessful
Permissions:{'all_of': ['Query Data Lake']}
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database_name | Yes | The name of the database where the table is located | |
| table_name | Yes | The name of the table to get columns for |