Column
The data type of a column.
Anchor to Valid valuesValid values
- ARRAY
- BOOLEAN
- COLOR
- DAY_DURATION
- DAY_OF_WEEK
- DAY_TIMESTAMP
- DECIMAL
- FLOAT
- HOUR_DURATION
- HOUR_OF_DAY
- HOUR_TIMESTAMP
- IDENTITY
- INTEGER
- MILLISECOND_DURATION
- MINUTE_DURATION
- MINUTE_TIMESTAMP
- MONEY
- MONTH_OF_YEAR
- MONTH_TIMESTAMP
- PERCENT
- QUARTER_TIMESTAMP
- RATING
- SECOND_DURATION
- SECOND_TIMESTAMP
- STRING
- STRING_IDENTITY
- TIMESTAMP
- UNSPECIFIED
- WEEK_OF_YEAR
- WEEK_TIMESTAMP
- YEAR_TIMESTAMP
- Anchor to ARRAYARRAY
Represents an array of values.
- Anchor to BOOLEANBOOLEAN
Represents a boolean value.
- Anchor to COLORCOLOR
Represents a hex color 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 RATINGRATING
Represents a rating 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 STRING_IDENTITYSTRING_
IDENTITY Represents a string identity 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.
Anchor to FieldsFields
- •OBJECT
Represents a column in a ShopifyQL query response.
- •OBJECT
Represents a column in a ShopifyQL query response.