athena_explain_view
Get detailed information about a DataView view: columns, data types, foreign key relationships, and operational warnings. Use this before writing SQL to avoid data loss or errors.
Instructions
Returns detailed information about an athenahealth Snowflake DataView view: description, columns with data types, known enum values, FK relationships, and any operational gotchas. Use this before writing SQL against any view.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| viewName | Yes | View name, e.g. "PATIENT" or "ATHENAONE.PATIENT" or "APPOINTMENTVIEW" | |
| includeColumns | No | Include column list with data types. Defaults to true. | |
| includeGotchas | No | Include operational warnings specific to this view. Defaults to true. | |
| includeRelationships | No | Include known FK relationships from this view. Defaults to true. |