> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Alter Dataset Schema

> Modifies the schema of an existing dataset by adding or altering columns



## OpenAPI

````yaml /openapi/product/data-sets.yaml post /api/data/v2/datasources/{datasetId}/schemas
openapi: 3.0.0
info:
  title: Datasets API
  version: v1
  description: >
    The Domo Datasets API provides a set of endpoints for managing, creating,
    and updating datasets within Domo. The API allows developers to execute SQL
    queries on datasets,

    manage access permissions, retrieve metadata, append rows, share datasets,
    and perform various dataset operations.
servers:
  - url: https://{instance}.domo.com
    description: Domo Instance
    variables:
      instance:
        default: example
        description: Your Domo instance name
security:
  - developerToken: []
paths:
  /api/data/v2/datasources/{datasetId}/schemas:
    post:
      tags:
        - Datasets API
      summary: Alter Dataset Schema
      description: Modifies the schema of an existing dataset by adding or altering columns
      parameters:
        - name: datasetId
          in: path
          required: true
          schema:
            type: string
      requestBody:
        required: true
        content:
          application/json:
            schema:
              $ref: '#/components/schemas/Schema'
            example:
              columns:
                - name: name
                  id: name
                  type: STRING
                  visible: true
                  order: 0
                - name: id
                  id: id
                  type: LONG
                  visible: true
                  order: 0
                - name: alertId
                  id: alertId
                  type: LONG
                  visible: true
                  order: 0
      responses:
        '200':
          description: Schema updated
      security:
        - sessionToken: []
      x-codeSamples:
        - lang: HTTP
          source: |
            POST /api/data/v2/datasources/{datasetId}/schemas HTTP/1.1
            Host: {instance}.domo.com
            x-domo-authentication: {session_token}
            Content-Type: application/json
            Accept: application/json

            {
              "columns": [
                {
                  "name": "name",
                  "id": "name",
                  "type": "STRING",
                  "visible": true,
                  "order": 0
                },
                {
                  "name": "id",
                  "id": "id",
                  "type": "LONG",
                  "visible": true,
                  "order": 0
                },
                {
                  "name": "alertId",
                  "id": "alertId",
                  "type": "LONG",
                  "visible": true,
                  "order": 0
                }
              ]
            }
components:
  schemas:
    Schema:
      type: object
      properties:
        columns:
          type: array
          items:
            type: object
            properties:
              type:
                type: string
                enum:
                  - STRING
                  - LONG
                  - DOUBLE
                  - DATE
                  - DATETIME
              name:
                type: string
              id:
                type: string
              visible:
                type: boolean
              order:
                type: integer
  securitySchemes:
    developerToken:
      type: apiKey
      in: header
      name: X-DOMO-Developer-Token
      description: Developer token obtained from Domo
    sessionToken:
      type: apiKey
      in: header
      name: x-domo-authentication
      description: Session token for authenticated requests

````