MeridianMERIDIAN

Data URI

Inline data URI scheme embedding content directly in a string. Format: data:[mediatype][;base64],data. Used for embedding small files in HTML, CSS, and API responses.

Data URI

technology.internet.data_uri

Inline data URI scheme embedding content directly in a string. Format: data:[mediatype][;base64],data. Used for embedding small files in HTML, CSS, and API responses.

Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "data:text/plain;base64,SGVsbG8gV29ybGQ="
→ technology.internet.data_uri

DuckDB

Detect
SELECT finetype('data:text/plain;base64,SGVsbG8gV29ybGQ=');
-- → 'technology.internet.data_uri'
Cast expression
CAST({col} AS VARCHAR)
Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'technology.internet.data_uri';

Struct Expansion

Expression
is_base64: CASE WHEN {col} LIKE '%base64,%' THEN true ELSE false END
media_type: REGEXP_EXTRACT({col}, '^data:([^;,]+)')

JSON Schema

finetype schema technology.internet.data_uri
{
  "$id": "https://meridian.online/schemas/technology.internet.data_uri",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Inline data URI scheme embedding content directly in a string. Format: data:[mediatype][;base64],data. Used for embedding small files in HTML, CSS, and API responses.",
  "examples": [
    "data:text/plain;base64,SGVsbG8gV29ybGQ=",
    "data:image/png;base64,iVBORw0KGgoAAAANSUhEUg==",
    "data:application/json,{\"key\":\"value\"}",
    "data:text/html,%3Ch1%3EHello%3C%2Fh1%3E"
  ],
  "pattern": "^data:(?:[a-zA-Z0-9]+/[a-zA-Z0-9\\-+.]+)?(?:;[a-zA-Z0-9\\-]+=[^;,]*)*(?:;base64)?,.+$",
  "title": "Data URI",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

data:text/plain;base64,SGVsbG8gV29ybGQ=data:image/png;base64,iVBORw0KGgoAAAANSUhEUg==data:application/json,{"key":"value"}data:text/html,%3Ch1%3EHello%3C%2Fh1%3E

Type Registry