---
title: "Get table"
method: GET
path: "/table/show/{database_name}/{table_name}"
tags: ["Tables"]
---

# Get table

`GET /table/show/{database_name}/{table_name}`

Shows a table according to specified database and table.

## Path parameters

- `database_name` Name, required — unresolved $ref
- `table_name` Name, required — unresolved $ref

## Query parameters

- `include_descriptions` boolean

## Response `200`

OK

- Table — Table
  - `id` integer, required
  - `count` integer, required
  - `counter_updated_at` union, required
    - string, nullable
    - string — Datetime in ISO 8601 format (`2020-12-31T11:22:33-05:00` or `2020-12-31T11:22:33Z` for UTC)
  - `created_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)
  - `delete_protected` boolean, required
  - `estimated_storage_size` integer, required
  - `expire_days` integer, nullable, required
  - `include_v` boolean, required — when true, Hive queries can access a virtual column "v" which contains a map of every data column's name to its value (represented as a string). Prefer to set a schema on the table instead of using "v".
  - `last_log_timestamp` integer, nullable, required
  - `name` string, required
  - `description` string, nullable — user-provided description of the table
  - `schema` string, required — JSON-encoded table schema. When include_descriptions=true, contains column descriptions in format [[name, type, alias, description], ...]
  - `type` 'log', required
  - `updated_at` string, required — Datetime in custom format (`2020-12-31 11:22:33 -0500` or `2020-12-31 11:22:33 UTC` for UTC)

---

[API](https://skmtc.net/treasure/apis/treasure-data-api.md) · [All operations](https://skmtc.net/treasure/apis/treasure-data-api/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/treasure/treasure-data-api/revisions/a753ea35d9dd/schema)