Specify column order in the code representation of a data model

You can specify order of columns in a table when managing data models as code using the order array in the table element.

By specifying column order, you can control how tables created using the Create a data model from a code representation endpoint are presented to users in the UI, allowing you to logically sequence columns left-to-right based on their contents, data types, usage, and more.

Example representation with order

The following example shows a JSON representation of a data model with a table that has a specific column order:

Full JSON representation with column order

{
  "dataModelId": "0497bb11-e7d4-43f9-91ef-c76a8015d5c8",
  "name": "folder",
  "url": "https://aws-api.sigmacomputing.com/org-name/data-model/folder-pbal6jUmit5VKS4Uu4fmw",
  "documentVersion": 2,
  "latestDocumentVersion": 2,
  "ownerId": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
  "folderId": "fcb10706-125c-4a83-83d1-2977c8d963a0",
  "createdBy": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
  "updatedBy": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
  "createdAt": "2026-01-22T15:51:12.034Z",
  "updatedAt": "2026-01-22T17:58:10.625Z",
  "schemaVersion": 1,
  "pages": [
    {
      "id": "Xn9TvLV7dN",
      "name": "Page 1",
      "elements": [
        {
          "id": "NdI8MLD9LE",
          "kind": "table",
          "source": {
            "connectionId": "9ad28df9-5f5f-4bae-8985-bb12d25829de",
            "kind": "warehouse-table",
            "path": [
              "EXAMPLES",
              "FAA",
              "FLIGHTS"
            ]
          },
          "columns": [
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/YEAR",
              "formula": "[FLIGHTS/Year]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/MONTH",
              "formula": "[FLIGHTS/Month]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY",
              "formula": "[FLIGHTS/Day]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY_OF_WEEK",
              "formula": "[FLIGHTS/Day of Week]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
              "formula": "[FLIGHTS/Airline]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
              "formula": "[FLIGHTS/Flight Number]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
              "formula": "[FLIGHTS/Tail Number]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
              "formula": "[FLIGHTS/Origin Airport]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
              "formula": "[FLIGHTS/Destination Airport]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
              "formula": "[FLIGHTS/Scheduled Departure]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
              "formula": "[FLIGHTS/Departure Time]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
              "formula": "[FLIGHTS/Departure Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
              "formula": "[FLIGHTS/Taxi Out]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
              "formula": "[FLIGHTS/Wheels Off]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
              "formula": "[FLIGHTS/Scheduled Time]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
              "formula": "[FLIGHTS/Elapsed Time]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
              "formula": "[FLIGHTS/Air Time]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
              "formula": "[FLIGHTS/Distance]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
              "formula": "[FLIGHTS/Wheels On]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
              "formula": "[FLIGHTS/Taxi In]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
              "formula": "[FLIGHTS/Scheduled Arrival]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
              "formula": "[FLIGHTS/Arrival Time]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
              "formula": "[FLIGHTS/Arrival Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
              "formula": "[FLIGHTS/Diverted]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
              "formula": "[FLIGHTS/Cancelled]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
              "formula": "[FLIGHTS/Cancellation Reason]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
              "formula": "[FLIGHTS/Air System Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
              "formula": "[FLIGHTS/Security Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
              "formula": "[FLIGHTS/Airline Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
              "formula": "[FLIGHTS/Late Aircraft Delay]"
            },
            {
              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY",
              "formula": "[FLIGHTS/Weather Delay]"
            }
          ],
          "folders": [
            {
              "id": "6dLyS0e3wh",
              "name": "Date",
              "items": [
                "inode-Ayhp5bdwjOj7J3rwU39F9y/YEAR",
                "inode-Ayhp5bdwjOj7J3rwU39F9y/MONTH",
                "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY",
                "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY_OF_WEEK"
              ]
            }
          ],
          "order": [
            "6dLyS0e3wh",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
            "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY"
          ]
        }
      ]
    }
  ]
}

Representing order

In this representation, the column order is specified in the order array of the table element. The order array contains the IDs of the columns and folders in a table in the order you want them to appear in the table, where the first item in the order array is the left-most column in the Sigma UI.

Order representation

...
"order": [
  "6dLyS0e3wh",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
  "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY"
]
...

Here, entries formatted as short alphanumeric IDs, such as 6dLyS0e3wh, identify either a folder of multiple columns or a calculated column. Entries formatted as inode-<id>/<column_name> are individual columns from the table source.

Updated about 5 hours ago