JSON Object

container.object.json

JavaScript Object Notation (JSON) object stored as VARCHAR. Represents structured key-value data that may be nested.

Domain

container

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

Expression

RECURSIVE_INFER_ON_FIELDS({col})

JSON Schema

finetype schema container.object.json

{
  "$id": "https://meridian.online/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\": \"alice@example.com\", \"active\": true}",
    "{\"nested\": {\"key\": \"value\"}}"
  ],
  "pattern": "^\\{.*\\}$",
  "title": "JSON Object",
  "type": "string",
  "x-finetype-broad-type": "JSON",
  "x-finetype-transform": "PARSE_JSON({col})"
}

Examples

{"user": "john", "age": 30}{"name": "Alice", "email": "alice@example.com", "active": true}{"nested": {"key": "value"}}

Aliases

json_object