--- title: ColumnDataType - GraphQL Admin description: The data type of a column. api_version: 2025-10 api_name: admin type: enum api_type: graphql source_url: html: https://shopify.dev/docs/api/admin-graphql/latest/enums/columndatatype md: https://shopify.dev/docs/api/admin-graphql/latest/enums/columndatatype.md --- # Column​Data​Type enum The data type of a column. ## Valid values * ARRAY Represents an array of values. * BOOLEAN Represents a boolean value. * DAY\_​DURATION Represents a duration in days. * DAY\_​OF\_​WEEK Represents a day of week value. * DAY\_​TIMESTAMP Represents a day-level timestamp value. * DECIMAL Represents a decimal value. * FLOAT Represents a floating point value. * HOUR\_​DURATION Represents a duration in hours. * HOUR\_​OF\_​DAY Represents an hour of day value. * HOUR\_​TIMESTAMP Represents a hour-level timestamp value. * IDENTITY Represents an identity value. * INTEGER Represents an integer value. * MILLISECOND\_​DURATION Represents a duration in milliseconds. * MINUTE\_​DURATION Represents a duration in minutes. * MINUTE\_​TIMESTAMP Represents a minute-level timestamp value. * MONEY Represents a monetary value. * MONTH\_​OF\_​YEAR Represents a month of year value. * MONTH\_​TIMESTAMP Represents a month-level timestamp value. * PERCENT Represents a percentage value. * QUARTER\_​TIMESTAMP Represents a quarter-level timestamp value. * SECOND\_​DURATION Represents a duration in seconds. * SECOND\_​TIMESTAMP Represents a second-level timestamp value. * STRING Represents a string value. * TIMESTAMP Represents a timestamp value in seconds. * UNSPECIFIED Represents an unspecified data type. * WEEK\_​OF\_​YEAR Represents a week of year value. * WEEK\_​TIMESTAMP Represents a week-level timestamp value. * YEAR\_​TIMESTAMP Represents a year-level timestamp value. *** ## Fields * [Shopifyql​Table​Data​Column.dataType](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShopifyqlTableDataColumn#field-ShopifyqlTableDataColumn.fields.dataType) OBJECT Represents a column in a ShopifyQL query response. * [Shopifyql​Table​Data​Column.subType](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShopifyqlTableDataColumn#field-ShopifyqlTableDataColumn.fields.subType) OBJECT Represents a column in a ShopifyQL query response. *** ## Map ### Fields with this enum * <-|[Shopifyql​Table​Data​Column.dataType](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShopifyqlTableDataColumn#field-ShopifyqlTableDataColumn.fields.dataType) * <-|[Shopifyql​Table​Data​Column.subType](https://shopify.dev/docs/api/admin-graphql/latest/objects/ShopifyqlTableDataColumn#field-ShopifyqlTableDataColumn.fields.subType)