Choose a version:

ColumnDataType

enum

The data type of a column.

Anchor to Valid valuesValid values

Anchor to ARRAYARRAY: Represents an array of values.
Anchor to BOOLEANBOOLEAN: Represents a boolean value.
Anchor to DAY_DURATIONDAY_DURATION: Represents a duration in days.
Anchor to DAY_OF_WEEKDAY_OF_WEEK: Represents a day of week value.
Anchor to DAY_TIMESTAMPDAY_TIMESTAMP: Represents a day-level timestamp value.
Anchor to DECIMALDECIMAL: Represents a decimal value.
Anchor to FLOATFLOAT: Represents a floating point value.
Anchor to HOUR_DURATIONHOUR_DURATION: Represents a duration in hours.
Anchor to HOUR_OF_DAYHOUR_OF_DAY: Represents an hour of day value.
Anchor to HOUR_TIMESTAMPHOUR_TIMESTAMP: Represents a hour-level timestamp value.
Anchor to IDENTITYIDENTITY: Represents an identity value.
Anchor to INTEGERINTEGER: Represents an integer value.
Anchor to MILLISECOND_DURATIONMILLISECOND_DURATION: Represents a duration in milliseconds.
Anchor to MINUTE_DURATIONMINUTE_DURATION: Represents a duration in minutes.
Anchor to MINUTE_TIMESTAMPMINUTE_TIMESTAMP: Represents a minute-level timestamp value.
Anchor to MONEYMONEY: Represents a monetary value.
Anchor to MONTH_OF_YEARMONTH_OF_YEAR: Represents a month of year value.
Anchor to MONTH_TIMESTAMPMONTH_TIMESTAMP: Represents a month-level timestamp value.
Anchor to PERCENTPERCENT: Represents a percentage value.
Anchor to QUARTER_TIMESTAMPQUARTER_TIMESTAMP: Represents a quarter-level timestamp value.
Anchor to SECOND_DURATIONSECOND_DURATION: Represents a duration in seconds.
Anchor to SECOND_TIMESTAMPSECOND_TIMESTAMP: Represents a second-level timestamp value.
Anchor to STRINGSTRING: Represents a string value.
Anchor to TIMESTAMPTIMESTAMP: Represents a timestamp value in seconds.
Anchor to UNSPECIFIEDUNSPECIFIED: Represents an unspecified data type.
Anchor to WEEK_OF_YEARWEEK_OF_YEAR: Represents a week of year value.
Anchor to WEEK_TIMESTAMPWEEK_TIMESTAMP: Represents a week-level timestamp value.
Anchor to YEAR_TIMESTAMPYEAR_TIMESTAMP: Represents a year-level timestamp value.

Was this section helpful?

Anchor to FieldsFields

Anchor to ShopifyqlTableDataColumn.dataType ShopifyqlTableDataColumn.dataType •OBJECT: Represents a column in a ShopifyQL query response.
Anchor to ShopifyqlTableDataColumn.subType ShopifyqlTableDataColumn.subType •OBJECT: Represents a column in a ShopifyQL query response.

Was this section helpful?