1. MooseStack
  2. Data Types
  3. LowCardinality

On this page

LowCardinality(String)See Also

LowCardinality

LowCardinality is a ClickHouse optimization that dictionary-encodes column values, reducing storage and improving query performance for columns with many repeated values (fewer than ~10,000 unique values).

LowCardinality(String)

import { LowCardinality } from "@514labs/moose-lib"; interface Event {  id: string;  status: string & LowCardinality;      // LowCardinality(String)  country: string & LowCardinality;     // LowCardinality(String)  category: string & LowCardinality;    // LowCardinality(String)}
When to use LowCardinality

Use for columns with fewer than ~10,000 unique values that repeat frequently—status codes, country codes, categories, or log levels. Reduces storage and improves query performance.

See Also

  • Strings — Standard string types
  • Enums — Fixed set of categorical values
  • ClickHouse LowCardinality — ClickHouse official documentation
import { LowCardinality } from "@514labs/moose-lib"; interface Event {  id: string;  status: string & LowCardinality;      // LowCardinality(String)  country: string & LowCardinality;     // LowCardinality(String)  category: string & LowCardinality;    // LowCardinality(String)}
  • Overview
  • Quick Start
  • Templates / Examples
Fundamentals
  • Moose Runtime
  • MooseDev MCP
  • Data Modeling
MooseStack in your App
  • App / API frameworks
Modules
  • Moose OLAP
  • Moose Streaming
  • Moose Workflows
  • Moose APIs
Deployment & Lifecycle
  • Moose Migrate
  • Moose Deploy
Reference
  • API Reference
  • Data Types
    • Strings
    • LowCardinality
    • Integers
    • Floats
    • Decimals
    • Booleans
    • Date & Time
    • Network
    • Arrays
    • Maps
    • Nested
    • Tuples
    • Enums
    • Geometry
    • JSON
    • Nullable
    • Aggregates
  • Table Engines
  • CLI
  • Configuration
  • Observability Metrics
  • Help
  • Changelog
Contribution
  • Documentation
  • Framework
FiveonefourFiveonefour
Fiveonefour Docs
MooseStackTemplates
Changelog
Source506