technology.cryptographic.token_urlsafeRandom token encoded in URL-safe Base64 (uses - and _ instead of + and /). Commonly used for auth tokens, reset links, and secure identifiers.
$ finetype infer -i "SFMyNDI5STExOjEwMQ"
→ technology.cryptographic.token_urlsafeSELECT finetype('SFMyNDI5STExOjEwMQ');
-- → 'technology.cryptographic.token_urlsafe'CAST({col} AS VARCHAR)-- 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.token_urlsafe';{
"$id": "https://meridian.online/schemas/technology.cryptographic.token_urlsafe",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Random token encoded in URL-safe Base64 (uses - and _ instead of + and /). Commonly used for auth tokens, reset links, and secure identifiers.",
"examples": [
"SFMyNDI5STExOjEwMQ",
"dGVzdC10b2tlbg",
"aGVsbG8td29ybGQ"
],
"pattern": "^[A-Za-z0-9_-]{12,128}$",
"title": "URL-Safe Base64 Token",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}SFMyNDI5STExOjEwMQdGVzdC10b2tlbgaGVsbG8td29ybGQ