Skip to Content
Admin UICreate a Table

Create a Table in the KalamDB Admin UI

Create a table in the KalamDB Admin UI with the visual table editor, where you define the namespace, table type, table name, storage options, flush policy, compression, and fields before reviewing the generated schema change.

KalamDB Admin UI table editor showing a new agent_events table with id, agent_id, and event_type fields

Open The Table Editor

Open SQL Studio, choose the target namespace, then select New table from the explorer toolbar.

The editor starts with:

  • namespace context
  • table type selector
  • table name
  • storage ID and optional user-storage toggle
  • flush policy and compression controls
  • column rows with primary key, type, nullable, unique, and default controls
  • Discard and Review & Create actions

Define Fields

For a starter agent_events table:

  1. Set Table name to agent_events.
  2. Keep the default id primary key unless your schema needs a different key.
  3. Use Add column for each additional field.
  4. Set field names such as agent_id and event_type.
  5. Choose each field type from the type selector.
  6. Adjust nullable, unique, and default values before review.

Use Review & Create to inspect the schema change, then confirm creation. The action is disabled until required fields are valid.

Verify The Table

After creation, the table appears in the namespace explorer. Open SQL Studio and run:

SQL
SELECT id, agent_id, event_typeFROM default.agent_eventsLIMIT 20;

If you create the table in another namespace, replace default with that namespace.

Last updated on
SQL StudioStreaming