---
title: "List all Columns"
method: GET
path: "/1/columns/{datasetSlug}"
tags: ["Columns"]
---

# List all Columns

`GET /1/columns/{datasetSlug}`

Get all the Columns in a dataset or environment.
Use `__all__`  as the dataset slug to retrieve all Columns across all datasets in the environment (not available for classic environments).

## Query parameters

- `key_name` string

## Response `200`

When listing all columns, an array of Column objects will be returned. When using `key_name`, will return a single Column object if found.

- union
  - Column[]
    - `key_name` string, required — Name of the Column.
    - `type` 'string' | 'float' | 'integer' | 'boolean' | 'histogram' — Type of data that the Column will contain. Histogram is in beta and only works in your Metrics dataset.
    - `description` string — Column description.
    - `hidden` boolean — If `true`, the column is excluded from autocomplete and raw data field lists.
    - `id` string — Unique identifier (ID), returned in response bodies.
    - `last_written` string — ISO8601 formatted time the column was last written to (received event data).
    - `created_at` string — ISO8601 formatted time the column was created.
    - `updated_at` string — ISO8601 formatted time the column was updated.
  - Column
    - `key_name` string, required — Name of the Column.
    - `type` 'string' | 'float' | 'integer' | 'boolean' | 'histogram' — Type of data that the Column will contain. Histogram is in beta and only works in your Metrics dataset.
    - `description` string — Column description.
    - `hidden` boolean — If `true`, the column is excluded from autocomplete and raw data field lists.
    - `id` string — Unique identifier (ID), returned in response bodies.
    - `last_written` string — ISO8601 formatted time the column was last written to (received event data).
    - `created_at` string — ISO8601 formatted time the column was created.
    - `updated_at` string — ISO8601 formatted time the column was updated.

## Other responses

- `400` — The provided request body was invalid.
- `401` — Unauthorized
- `404` — Not Found
- `429` — Rate Limit Exceeded

---

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