MeridianMERIDIAN

JSON Object

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

JSON Object

container.object.json

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

Domain
container
Category
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

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\": \"[email protected]\", \"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": "[email protected]", "active": true}{"nested": {"key": "value"}}

Aliases

json_object

Type Registry