check_nested_structure
Inspect nested JSON schemas to detect type inconsistencies and sparse fields, then generate flatten SQL for analysis.
Instructions
For JSON-loaded sources, walk the nested STRUCT/LIST schema.
Per leaf path: declared type + presence percentage. Flags type-drift
(DuckDB JSON fallback indicates rows have inconsistent types) and
sparse paths (<80% presence). Returns a paste-ready flatten SQL using
struct_extract.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sample | No | ||
| source_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||