String Types

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

String

Variable-length strings for general text data.

interface User {  name: string;        // String  email: string;       // String}

LowCardinality(String)

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

import { LowCardinality } from "@514labs/moose-lib"; interface Event {  status: string & LowCardinality;     // LowCardinality(String)  country: string & 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