Build from codeManage data models as code

Specify column order in the code representation of a data model

View as MarkdownOpen in Claude

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:

1{
2  "dataModelId": "0497bb11-e7d4-43f9-91ef-c76a8015d5c8",
3  "name": "folder",
4  "url": "https://aws-api.sigmacomputing.com/org-name/data-model/folder-pbal6jUmit5VKS4Uu4fmw",
5  "documentVersion": 2,
6  "latestDocumentVersion": 2,
7  "ownerId": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
8  "folderId": "fcb10706-125c-4a83-83d1-2977c8d963a0",
9  "createdBy": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
10  "updatedBy": "fOsrWKBxSMe8HqLmT0nXESkGLpkIc",
11  "createdAt": "2026-01-22T15:51:12.034Z",
12  "updatedAt": "2026-01-22T17:58:10.625Z",
13  "schemaVersion": 1,
14  "pages": [
15    {
16      "id": "Xn9TvLV7dN",
17      "name": "Page 1",
18      "elements": [
19        {
20          "id": "NdI8MLD9LE",
21          "kind": "table",
22          "source": {
23            "connectionId": "9ad28df9-5f5f-4bae-8985-bb12d25829de",
24            "kind": "warehouse-table",
25            "path": [
26              "EXAMPLES",
27              "FAA",
28              "FLIGHTS"
29            ]
30          },
31          "columns": [
32            {
33              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/YEAR",
34              "formula": "[FLIGHTS/Year]"
35            },
36            {
37              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/MONTH",
38              "formula": "[FLIGHTS/Month]"
39            },
40            {
41              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY",
42              "formula": "[FLIGHTS/Day]"
43            },
44            {
45              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY_OF_WEEK",
46              "formula": "[FLIGHTS/Day of Week]"
47            },
48            {
49              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
50              "formula": "[FLIGHTS/Airline]"
51            },
52            {
53              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
54              "formula": "[FLIGHTS/Flight Number]"
55            },
56            {
57              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
58              "formula": "[FLIGHTS/Tail Number]"
59            },
60            {
61              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
62              "formula": "[FLIGHTS/Origin Airport]"
63            },
64            {
65              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
66              "formula": "[FLIGHTS/Destination Airport]"
67            },
68            {
69              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
70              "formula": "[FLIGHTS/Scheduled Departure]"
71            },
72            {
73              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
74              "formula": "[FLIGHTS/Departure Time]"
75            },
76            {
77              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
78              "formula": "[FLIGHTS/Departure Delay]"
79            },
80            {
81              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
82              "formula": "[FLIGHTS/Taxi Out]"
83            },
84            {
85              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
86              "formula": "[FLIGHTS/Wheels Off]"
87            },
88            {
89              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
90              "formula": "[FLIGHTS/Scheduled Time]"
91            },
92            {
93              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
94              "formula": "[FLIGHTS/Elapsed Time]"
95            },
96            {
97              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
98              "formula": "[FLIGHTS/Air Time]"
99            },
100            {
101              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
102              "formula": "[FLIGHTS/Distance]"
103            },
104            {
105              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
106              "formula": "[FLIGHTS/Wheels On]"
107            },
108            {
109              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
110              "formula": "[FLIGHTS/Taxi In]"
111            },
112            {
113              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
114              "formula": "[FLIGHTS/Scheduled Arrival]"
115            },
116            {
117              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
118              "formula": "[FLIGHTS/Arrival Time]"
119            },
120            {
121              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
122              "formula": "[FLIGHTS/Arrival Delay]"
123            },
124            {
125              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
126              "formula": "[FLIGHTS/Diverted]"
127            },
128            {
129              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
130              "formula": "[FLIGHTS/Cancelled]"
131            },
132            {
133              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
134              "formula": "[FLIGHTS/Cancellation Reason]"
135            },
136            {
137              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
138              "formula": "[FLIGHTS/Air System Delay]"
139            },
140            {
141              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
142              "formula": "[FLIGHTS/Security Delay]"
143            },
144            {
145              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
146              "formula": "[FLIGHTS/Airline Delay]"
147            },
148            {
149              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
150              "formula": "[FLIGHTS/Late Aircraft Delay]"
151            },
152            {
153              "id": "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY",
154              "formula": "[FLIGHTS/Weather Delay]"
155            }
156          ],
157          "folders": [
158            {
159              "id": "6dLyS0e3wh",
160              "name": "Date",
161              "items": [
162                "inode-Ayhp5bdwjOj7J3rwU39F9y/YEAR",
163                "inode-Ayhp5bdwjOj7J3rwU39F9y/MONTH",
164                "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY",
165                "inode-Ayhp5bdwjOj7J3rwU39F9y/DAY_OF_WEEK"
166              ]
167            }
168          ],
169          "order": [
170            "6dLyS0e3wh",
171            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
172            "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
173            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
174            "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
175            "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
176            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
177            "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
178            "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
179            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
180            "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
181            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
182            "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
183            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
184            "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
185            "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
186            "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
187            "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
188            "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
189            "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
190            "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
191            "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
192            "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
193            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
194            "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
195            "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
196            "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
197            "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY"
198          ]
199        }
200      ]
201    }
202  ]
203}

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.

1...
2"order": [
3  "6dLyS0e3wh",
4  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE",
5  "inode-Ayhp5bdwjOj7J3rwU39F9y/FLIGHT_NUMBER",
6  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAIL_NUMBER",
7  "inode-Ayhp5bdwjOj7J3rwU39F9y/ORIGIN_AIRPORT",
8  "inode-Ayhp5bdwjOj7J3rwU39F9y/DESTINATION_AIRPORT",
9  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_DEPARTURE",
10  "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_TIME",
11  "inode-Ayhp5bdwjOj7J3rwU39F9y/DEPARTURE_DELAY",
12  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_OUT",
13  "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_OFF",
14  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_TIME",
15  "inode-Ayhp5bdwjOj7J3rwU39F9y/ELAPSED_TIME",
16  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_TIME",
17  "inode-Ayhp5bdwjOj7J3rwU39F9y/DISTANCE",
18  "inode-Ayhp5bdwjOj7J3rwU39F9y/WHEELS_ON",
19  "inode-Ayhp5bdwjOj7J3rwU39F9y/TAXI_IN",
20  "inode-Ayhp5bdwjOj7J3rwU39F9y/SCHEDULED_ARRIVAL",
21  "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_TIME",
22  "inode-Ayhp5bdwjOj7J3rwU39F9y/ARRIVAL_DELAY",
23  "inode-Ayhp5bdwjOj7J3rwU39F9y/DIVERTED",
24  "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLED",
25  "inode-Ayhp5bdwjOj7J3rwU39F9y/CANCELLATION_REASON",
26  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIR_SYSTEM_DELAY",
27  "inode-Ayhp5bdwjOj7J3rwU39F9y/SECURITY_DELAY",
28  "inode-Ayhp5bdwjOj7J3rwU39F9y/AIRLINE_DELAY",
29  "inode-Ayhp5bdwjOj7J3rwU39F9y/LATE_AIRCRAFT_DELAY",
30  "inode-Ayhp5bdwjOj7J3rwU39F9y/WEATHER_DELAY"
31]
32...

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.