MeridianMERIDIAN

JSON Web Token

JSON Web Token (JWT) consisting of three base64url-encoded segments separated by dots: header.payload.signature. Used for authentication and information exchange.

JSON Web Token

technology.cryptographic.jwt

JSON Web Token (JWT) consisting of three base64url-encoded segments separated by dots: header.payload.signature. Used for authentication and information exchange.

Domain
technology
Category
cryptographic
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c"
→ technology.cryptographic.jwt

DuckDB

Detect
SELECT finetype('eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c');
-- → 'technology.cryptographic.jwt'
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.cryptographic.jwt';

Struct Expansion

Expression
header: REGEXP_EXTRACT({col}, '^([A-Za-z0-9_-]+)\.')
payload: REGEXP_EXTRACT({col}, '^\.([A-Za-z0-9_-]+)\.')
signature: REGEXP_EXTRACT({col}, '\.([A-Za-z0-9_-]+)$')

JSON Schema

finetype schema technology.cryptographic.jwt
{
  "$id": "https://meridian.online/schemas/technology.cryptographic.jwt",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "JSON Web Token (JWT) consisting of three base64url-encoded segments separated by dots: header.payload.signature. Used for authentication and information exchange.",
  "examples": [
    "eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5c",
    "eyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJhdXRoLmV4YW1wbGUuY29tIn0.dBjftJeZ4CVP-mB92K27uhbUJU1p1r_wW1gFWFOEjXk"
  ],
  "pattern": "^[A-Za-z0-9_-]{10,}\\.[A-Za-z0-9_-]{10,}\\.[A-Za-z0-9_-]{10,}$",
  "title": "JSON Web Token",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "CAST({col} AS VARCHAR)"
}

Examples

eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiIxMjM0NTY3ODkwIiwibmFtZSI6IkpvaG4gRG9lIiwiaWF0IjoxNTE2MjM5MDIyfQ.SflKxwRJSMeKKF2QT4fwpMeJf36POk6yJV_adQssw5ceyJhbGciOiJSUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJhdXRoLmV4YW1wbGUuY29tIn0.dBjftJeZ4CVP-mB92K27uhbUJU1p1r_wW1gFWFOEjXk

Aliases

json_web_token

Type Registry