representation.text.entity_nameNon-person named entity: organisation names, product names, venue names, song/movie/book titles, brand names. Distinguished from full_name by containing business suffixes (Inc, Corp, Ltd), numbers, ampersands, or other non-personal-name patterns.
$ finetype infer -i "The Olive Garden"
→ representation.text.entity_nameSELECT finetype('The Olive Garden');
-- → 'representation.text.entity_name'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) = 'representation.text.entity_name';{
"$id": "https://meridian.online/schemas/representation.text.entity_name",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Non-person named entity: organisation names, product names, venue names, song/movie/book titles, brand names. Distinguished from full_name by containing business suffixes (Inc, Corp, Ltd), numbers, ampersands, or other non-personal-name patterns.",
"examples": [
"The Olive Garden",
"iPhone 15 Pro",
"Game of Thrones",
"Spotify",
"McKinsey & Company",
"Toyota Motor Corp",
"Harvard University",
"Super Bowl LVIII"
],
"maxLength": 200,
"minLength": 2,
"title": "Entity Name",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)"
}The Olive GardeniPhone 15 ProGame of ThronesSpotifyMcKinsey & CompanyToyota Motor CorpHarvard UniversitySuper Bowl LVIII