Skip to main content

Discover Json Paths

GET 

/api/v1/schemas/:source_name/json-paths

Discover JSON paths inside a source's _json column.

Resolves the requested version (or the source's current version). If that version defines a meta_schema it uses db.<source> only after deploy; until then discovery runs on db.<landing> filtered by the version's match rule. Versions without meta_schema always use the landing table.

Returns one record per path with observed types, a suggested column name, and whether the path is already promoted. ?samples=N adds random distinct example values. ?stats=true adds coverage + distinct counts.

A caller without a platform grant holding schema:read reads only its own orgs' rows, as the sampler holds it, and a table it cannot be held on is 403.

Request​

Responses​

Successful Response