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

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