---
title: "List columns for all elements in a data model"
method: GET
path: "/v2/dataModels/{dataModelId}/columns"
tags: ["Data models"]
---

# List columns for all elements in a data model

`GET /v2/dataModels/{dataModelId}/columns`

## Request

- Base URL: `https://api.sigmacomputing.com`
- URL: `https://api.sigmacomputing.com/v2/dataModels/{dataModelId}/columns`
- Auth: HTTP bearer

This endpoint retrieves all columns in a data model for all elements in the data model.

  ### Usage notes
  - Retrieve the **dataModelId** by calling the [/v2/dataModels](https://help.sigmacomputing.com/reference/list-data-models) endpoint.

  ### Usage scenarios
  - **Data exploration:** Enable users to explore the data structure of a data model element, facilitating deeper analysis and understanding.
  - **Integration tasks:** Useful for developers integrating Sigma with other tools that need to know the data structure to map data accurately.

  ### Best practices
  - Use this endpoint when setting up interfaces that require specific knowledge about the data structure.

## Path parameters

- `dataModelId` string, required

## Query parameters

- `page` string
- `limit` number, double

## Response `200`

The response body.

- DataModelsGetDataModelColumnsResponse200
  - `entries` V2DataModelsDataModelIdColumnsGetResponsesContentApplicationJsonSchemaEntriesItems[], required
    - `columnId` string, required: Column ID
    - `name` string, required: Column name
    - `formula` string, required: Column formula or source column reference.
    - `type` V2DataModelsDataModelIdColumnsGetResponsesContentApplicationJsonSchemaEntriesItemsType, required: The column's data type, represented as a recursive type object.
    - `elementId` string, required: Element ID
  - `nextPage` string, nullable, required
  - `total` number, double

---

[API](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api.md) - [All operations](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/llms.txt) - [OpenAPI document](https://skmtc.dev/sigmacomputing/apis/sigma-rest-api/revisions/fb6036208c49?raw)