MeridianMERIDIAN

Binary Boolean (0/1)

Boolean value represented as a binary digit: "0" for false, "1" for true. Common in CSV exports, database dumps, and flag columns. Transforms to DuckDB BOOLEAN type.

Binary Boolean (0/1)

representation.boolean.binary

Boolean value represented as a binary digit: "0" for false, "1" for true. Common in CSV exports, database dumps, and flag columns. Transforms to DuckDB BOOLEAN type.

Domain
representation
Category
boolean
Casts to
BOOLEAN
Scope
Universal

Try it

CLI
$ finetype infer -i "0"
→ representation.boolean.binary

DuckDB

Detect
SELECT finetype('0');
-- → 'representation.boolean.binary'
Cast expression
CAST({col} AS BOOLEAN)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS BOOLEAN) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'representation.boolean.binary';

JSON Schema

finetype schema representation.boolean.binary
{
  "$id": "https://meridian.online/schemas/representation.boolean.binary",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Boolean value represented as a binary digit: \"0\" for false, \"1\" for true. Common in CSV exports, database dumps, and flag columns. Transforms to DuckDB BOOLEAN type.",
  "enum": [
    "0",
    "1"
  ],
  "examples": [
    "0",
    "1"
  ],
  "title": "Binary Boolean (0/1)",
  "type": "string",
  "x-finetype-broad-type": "BOOLEAN",
  "x-finetype-transform": "CAST({col} AS BOOLEAN)"
}

Examples

01

Aliases

binary_boolbit

Type Registry