---
title: "GET /schema/tables/{table}"
method: GET
path: "/schema/tables/{table}"
---

# GET /schema/tables/{table}

`GET /schema/tables/{table}`

get the table schema for specific table name

## Path parameters

- `table` string, required

## Response `200`

GetTableResponse represents GetTable response.

- Table
  - `archivingSortColumns` integer[] — Fact table only. IDs of columns to sort based upon.
  - `columns` Column[] — Index to Columns also serves as column IDs.
    - `caseInsensitive` boolean — Whether to compare characters case insensitively for enum columns. It only matters for ingestion client as it's the place to concert enum strings to enum values.
    - `config` ColumnConfig — ColumnConfig defines the schema of a column config that can be mutated by UpdateColumn API call.
      - `preloadingDays` integer — ColumnEvictionConfig : For column level in-memory eviction, it’s the best effort TTL for in-memory data. Column level eviction has nothing to do with data availability, but based on how much data we pre-loaded, the major impact will be there for query performance. Here we bring in two priorities configs: Preloading days and Priority. Preloading days is defined at each column level to indicate how many recent days data we want to preload to host memory. This is best effort operation. Priority is defined at each column level to indicate the priority of each column. When data eviction happens, we will rely on column priority to decide which column will be evicted first. High number implies high priority.
      - `priority` integer
    - `defaultValue` string — We store the default value as string here since it's from user input. Nil means the default value is NULL. Actual default value of column data type should be stored in memstore.
    - `deleted` boolean — Deleted columns are kept as placeholders in Table.Columns.
    - `disableAutoExpand` boolean — Whether disable enum cases auto expansion.
    - `name` string — Immutable, columns cannot be renamed.
    - `type` string — Immutable, columns cannot have their types changed.
  - `config` TableConfig — TableConfig defines the table configurations that can be changed
    - `archivingDelayMinutes` integer — Number of minutes after event time before a record can be archived.
    - `archivingIntervalMinutes` integer — Specifies how often archiving runs.
    - `backfillIntervalMinutes` integer — Specifies how often backfill runs.
    - `backfillMaxBufferSize` integer — Upper limit of current backfill buffer size + backfilling buffer size.
    - `backfillStoreBatchSize` integer — Size of each live batch used by backfill job.
    - `backfillThresholdInBytes` integer — Backfill buffer size in bytes that will trigger a backfill job.
    - `batchSize` integer — Size of each live batch, should be sufficiently large.
    - `initPrimaryKeyNumBuckets` integer — Initial setting of number of buckets for primary key if equals to 0, default will be used
    - `maxRedoLogFileSize` integer — Specifies the size limit of a single redo log file.
    - `recordRetentionInDays` integer — Records with timestamp older than now - RecordRetentionInDays will be skipped during ingestion and backfill. 0 means unlimited days.
    - `redoLogRotationInterval` integer — Specifies how often to create a new redo log file.
    - `snapshotIntervalMinutes` integer — Specifies how often snapshot runs.
    - `snapshotThreshold` integer — Number of mutations to accumulate before creating a new snapshot.
  - `isFactTable` boolean — Whether this is a fact table.
  - `name` string — Name of the table, immutable.
  - `primaryKeyColumns` integer[] — IDs of primary key columns. This field is immutable.
  - `version` integer

## Other responses

- `default` — ErrorResponse represents error response.

---

[API](https://skmtc.net/uber/apis/provide-the-restful-apis-to-interact-with-aresdb.md) · [All operations](https://skmtc.net/uber/apis/provide-the-restful-apis-to-interact-with-aresdb/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/uber/provide-the-restful-apis-to-interact-with-aresdb/revisions/d18a58e88958/schema)