String Types

ClickHouse provides several string-based types optimized for different use cases.

String

Variable-length strings for general text data.

class User(BaseModel):    name: str          # String    email: str         # String

LowCardinality(String)

Optimized storage for strings with many repeated values. Use when you have fewer than ~10,000 unique values.

from typing import Annotated class Event(BaseModel):    status: Annotated[str, "LowCardinality"]     # LowCardinality(String)    country: Annotated[str, "LowCardinality"]    # LowCardinality(String)

UUID

Universally unique identifiers stored in native UUID format.

import { tags } from "typia"; interface User {  id: string & tags.Format<"uuid">;    // UUID}

Type Mapping Reference

See Also

• LowCardinality — Detailed guide for optimizing repeated string values
• Enums — Fixed categorical values
• ClickHouse String — ClickHouse official documentation