Skip to content

JSON Object

Type Registry

JSON Object

container.object.json

JavaScript Object Notation (JSON) object stored as VARCHAR. Represents structured key-value data that may be nested. RECURSIVE INFERENCE: When classified as container.object.json, FineType will parse the JSON and attempt to classify each field value independently. Nested objects trigger recursive classification. Example: Input: {"user": "john", "age": 30, "active": true} Output: Struct<user VARCHAR, age BIGINT, active BOOLEAN>

Domain container›object
Casts to JSON
Scope Universal

Try it

CLI 
$ finetype infer -i "{"user": "john", "age": 30}"
→ container.object.json

DuckDB

Detect 
SELECT finetype('{"user": "john", "age": 30}');
-- → 'container.object.json'
Cast expression 
PARSE_JSON({col})
Safe cast pipeline 
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS JSON) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'container.object.json';

Decompose

RECURSIVE_INFER_ON_FIELDS({col})

JSON Schema

finetype schema container.object.json 
{
  "$id": "https://noon.sh/schemas/container.object.json",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "JavaScript Object Notation (JSON) object stored as VARCHAR. Represents structured key-value data that may be nested.\nRECURSIVE INFERENCE: When classified as container.object.json, FineType will parse the JSON and attempt to classify each field value independently. Nested objects trigger recursive classification.\nExample:\n  Input:  {\"user\": \"john\", \"age\": 30, \"active\": true}\n  Output: Struct<user VARCHAR, age BIGINT, active BOOLEAN>",
  "examples": [
    "{\"user\": \"john\", \"age\": 30}",
    "{\"name\": \"Alice\", \"email\": \"[email protected]\", \"active\": true}",
    "{\"nested\": {\"key\": \"value\"}}"
  ],
  "pattern": "^\\{.*\\}$",
  "title": "JSON Object",
  "type": "string"
}

Examples

{"user": "john", "age": 30}{"name": "Alice", "email": "[email protected]", "active": true}{"nested": {"key": "value"}}

Also known as

json_object

Types in container